SQL Server Performance tuning approach – deduce information from wait statistics data

In our last post, we started a journey for SQL Server DBAs so that they can establish an approach for performance tuning issue. We went through some of the basic wait types are and shared links for downloading queries to gather those. Now that you have gathered total wait statistics from a SQL Server instance, … Read more

SQL Server Performance tuning approach – Wait statistics

As a SQL Server DBA one of the most important part of our job is to do performance tuning. But, as soon as some says performance tuning, most DBAs are clueless on how to start troubleshooting. There are many articles, blogs which focuses on key aspects of performance tuning. However, in this series, we will … Read more