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 –SQL Server Database Consolidation

This blogpost continues my series of blogposts on advanced capacity planning techniques on data migration. In my previous blogpost I told about SQL Server Instance consolidation. This blogpost is abou...
Read More

Advanced capacity planning techniques on data migration –SQL Server Instance Consolidation

This blogpost continues my series of blogposts regarding advanced capacity planning techniques on data migration. In my previous blogpost I wrote about right sizing and virtualizing SQL Servers. This ...
Read More

Advanced capacity planning techniques on data migration – Right sizing SQL Server

This blogpost continues my series of blogposts regarding advanced capacity planning techniques on data migration. In my previous blogpost I wrote about scaling up SQL Servers. This blogpost is about r...
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

Advanced capacity planning techniques on data migration

This blogpost starts my series of blogposts regarding advanced capacity planning techniques on data migration. Capacity planning is the most lucrative part of data migration projects. It is not unusua...
Read More

SQL Governor V15 - what is new

SQL Governor V15 has now been available for some time. This article goes through the new cool features in brief.
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