Dr. DMV's Troubleshooting Toolkit

Explore a comprehensive set of diagnostic DMV queries for detecting and diagnosing configuration and performance issues in SQL Server instances and databases. Learn how to interpret query results and gain insights into properly configuring hardware, storage subsystems, operating systems, SQL Server instances, and databases to avoid performance and scalability problems. Discover techniques to identify top wait types, CPU-intensive stored procedures, missing indexes, and unused indexes. Delve into exhaustive details on result interpretation and acquire essential background information for optimal SQL Server performance tuning in this 2.5-hour conference talk from PASS Data Community Summit.