Chapter 6. Operating system DMVs
- Identifying why your queries are waiting
- Obtaining performance counter information
- Capturing DMV data periodically
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 ...
Get SQL Server DMVs in Action now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
