O'Reilly logo

Microsoft® SQL Server™ 2005 Administrator's Companion by Victor Isakov, Stacia Misner, Burzin Patel, Marcilina Garcia, Edward Whalen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using Dynamic Management Views

SQL Server 2005 groups the DMVs into twelve distinct categories based on the engine component to which they relate. These twelve categories are listed below:

  1. Common language runtime

  2. Database

  3. Database mirroring

  4. Execution

  5. Full-text search

  6. Input/output

  7. Index

  8. Query notifications

  9. Replication

  10. Service broker

  11. SQL Server operating system

  12. Transaction

In the sections below, the DMVs contained within each of these categories are explained in detail, along with example queries where applicable. Additional details about the DMVs can be found in the SQL Server Books Online.

On the CD

The sample DMV T-SQL statements in the sections below that are longer than four lines are provided on the CD. Look for the DMV_Example_Scripts.sql file in the \Scripts\ ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required