Uncover Hidden Data to Optimize Application Performance in SQL Server 2005

SQL Server: Uncover Hidden Data to Optimize Application Performance (MSDN Magazine, January 2008)

Dynamic management views and functions
Causes of server waits
Common index problems
Problems associated with logical I/O

SQL Query Records Causes of Wait Times


Identifying the Most Reads and Writes


Missing Indexes by Database


Cost of Missing Indexes


Identifying Most Costly Unused Indexes


Identifying the Most Costly Indexes


Identifying Most-Used Indexes


Logically Fragmented Indexes


Most Costly Queries by I/O


Costly Queries by CPU - SQL Query Records Causes of Wait Times


Most Costly CLR Queries


Most-Executed Queries


Queries Suffering from Blocking


Lowest Plan Reuse



TSQL Queries
Download the code (155 KB)
show script.sql