SQL Server DMV Starter Pack

Free eBook “SQL Server DMV Starter Pack” from Red Gate. The Dynamic Management Views booklet offers an introduction to DMVs and de-mystifies the process of collecting the information you need to troubleshoot SQL Server problems.
Description
The SQL Server DMV Starter Pack also contains more than 30 sample scripts that you can use to diagnose common SQL Server performance problems.
The Dynamic Management Views booklet offers an introduction to DMVs and de-mystifies the process of collecting the information you need to troubleshoot SQL Server problems. Dynamic Management Objects (DMOs) are a set of SQL Server objects, stored in the system schema, which provide the SQL Server DBA with a window into the activities being performed on their SQL Server instances, and the resources that this activity is consuming.
Contents

• Introducing Dynamic Management Objects
• Connections, Sessions, Requests, Queries
• Transactions
• Databases and Indexes
• Disk I/O
• Operating System
• Other Useful DMVs

Download: SQL Server DMV