Pre-Release of SQL Server DMV Book

• Download DMV Starter Guide:  Red Gate

My Top Ten DMVs – Tim Ford

• SQLServerPedia Article

Connections, Sessions, Requests

• sys.dm_exec_connections
• sys.dm_exec_sessions
• sys.dm_exec_requests
• Identify Last Statement Run on a Session – Tim Ford, MSSQLTips

Indexes

• Inside sys.dm_db_index_physical_stats – Paul Randal
• Index Defrag Script – Michelle Ufford
• Index Defrag Script – Andrew Kelly****
• Index Metadata and Statistics Update Date – Tim Ford, MSSQLTips
• Retaining Historical Index Usages Stats In SQL Server – Tim Ford, MSSQLTips

Waits

• SQL Server Wait Type Repository – CSS Blog

File I/O

• sys.dm_io_virtual_file_stats
• Getting to Know Virtual File Stats – Andrew Kelly
• sys.dm_os_schedulers

Query Stats

• sys.dm_exec_query_stats

 Locking & Blocking

• Understanding SQL Server Locking – Tim Ford, MSSQLTips
• Understanding SQL Server Blocking – Tim Ford, MSSQLTips

Performance Counters

• sys.dm_os_performance_counters primer – Tim Ford, MSSQLTips