SQL Server wait stats

SQL Server wait statistics provide the most objective indication of the perfomance of a SQL Server instance and this post explores how to use them to get more details about performance issues.

The single biggest clue to the source of a performance problem will be from something referred to as the wait stats. What are waitstats? In short wait stats are statistics gathered on what resources SQL Server is waiting on internally whilst executing queries. Why are they useful? They can often provide very quick and objective […]