List of Figures
Chapter 1. The Dynamic Management Views gold mine
Figure 1.1. Output showing if anything is blocked and what individual SQL queries are running
Figure 1.2. Identify the slowest SQL queries on your server, sorted by duration.
Figure 1.3. Output from the missing indexes SQL
Figure 1.4. Output identifies which SQL queries are currently running on the server.
Figure 1.5. Output showing searched-for cached plans
Figure 1.6. Missing indexes details included with a 2008 cached plan
Figure 1.7. Cached plan showing cost by statement and within each statement
Chapter 2. Common patterns
Figure 2.1. Execution plan for WHERE 1 = 2
Figure 2.2. Output showing the most-used cached plans that contain the text “CREATE PROCEDURE”
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.
