List of Listings
Chapter 1. The Dynamic Management Views gold mine
Listing 1.2. Find your slowest queries
Listing 1.3. Find those missing indexes
Listing 1.4. Identify what SQL is running now
Chapter 2. Common patterns
Listing 2.1. Restricting output to a given database
Listing 2.2. Top 10 longest-running queries on server
Listing 2.3. Creating a temporary table WHERE 1 = 2
Listing 2.4. Looping over all databases on a server pattern
Listing 2.5. Quickly find the most-used cached plans—simple version
Listing 2.6. Extracting the Individual Query from the Parent Query
Listing 2.7. Identify the database of ad hoc queries and stored procedures ...
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.
