Blog

SQL Server performance insights – Logical hierarchies in composite indexes

This blogpost starts my series of blogposts in the field of Microsoft SQL Server performance optimization. The goal of these blogposts is to be practical but in-depth, so I hope you find them interest...
Read More

Why understanding CPU contention is so important in Microsoft SQL Server capacity planning

What is CPU contention CPU contention is seriously taken phenomenon in Server, where multiple threads or processes are competing for being processed simultaneously. When level on CPU contention is hig...
Read More

Powerful SQL Server migrations: SQL Governor capacity planning methods

SQL Governor is software for capacity planning of medium to large-scale SQL Server environments to make data migrations smart, easy, and cost efficient.
Read More

Advanced capacity planning techniques on data migration – Scaling up Microsoft SQL Server

This blogpost continues my series of blog posts regarding advanced capacity planning techniques on data migration. In my previous blogpost I wrote an intro regarding this topic. This blogpost is about...
Read More

Predictive monitoring features in SQL Governor

If you had an expensive office full of people and valuable stuff in it, wouldn’t it be totally crazy not to take care of your fire alarm system? But what if you were able to predict a potential fire e...
Read More

Uncover the hidden cost savings in your SQL Server platform

Discover how you can save up to 50% when you next renew your Microsoft SQL Server platform. The traditional lift-and-shift process of renewing or migrating your data platform will not lead to remarkab...
Read More

Three customer cases: How to get the most out of your SQL Server resources

Is it even possible to get the most out of your SQL Server resources while keeping the costs at bay? This brand new webinar recording presents three case studies of how we helped our customers to tack...
Read More

Free webinar: Get the most out of your SQL Server resources

UPCOMING WEBINAR: Join our free webinar on Thu, June 25 to hear how our customers have managed to proactively prevent platform cost growing out of control without sacrificing performance or availabili...
Read More

Capacity Planning on SQL Server Active-Active Failover Cluster Instances [Step by step – Part 4]

In the fourth part of the SQL capacity planning blog series, we conduct a recurring workload analysis of the environment.
Read More

Capacity Planning on SQL Server Active-Active Failover Cluster Instances [Step by step – Part 3]

In the third part of the SQL Server capacity planning blog series, we conduct a best fit analysis of the environment based on the heatmap analysis and right-size the servers.
Read More