May 2011
Intermediate to advanced
352 pages
11h 27m
English
SQL Server provides several operating system-related DMVs that allow you to understand, at the server level, why your queries are waiting. Investigating these in conjunction with the SQL queries that are running should enable you to identify the problem areas and provide solutions to improve your SQL queries. I’ll provide a script to show your most common waits, both at the server level and those that occur when you run a given SQL query or batch.
Another DMV allows you to access the Windows internal performance counters for various SQL Server-related objects. These ...