SQLPS Meets the DMV's

This is a great wrapper for your DMV's to automate a quick performance metric capture.

Understanding Dynamic Management Views and Functions in SQL Server 2008

Performance monitoring and optimization is an inseparable part of a DBA's activities. To optimize a poorly performing system/query or to troubleshoot the performance issues you need to know the root cause. Prior to SQL Server 2005, we had several system tables to monitor the state of the system.

SQL Server DMVs in Action - Sample Chapter

Read the first chapter of this new book on DMVs.

SQL Server DMV Green Paper

Get a free green paper, an early access look at a new DMV book from longtime author Ian Stirk.

Server-scoped Dynamic Management Views

Database-scoped dynamic management views

DMV

Finding the Worst Performing T-SQL Statements on an Instance

Greg Larsen introduces some Dynamic Management Views (DMVs) and Dynamic Management Functions (DMFs) to help monitor your application's T-SQL performance. In addition, he provides a Stored Procedure that utilizes the DMVs and DMFs to produce a report that quickly identifies poorly performing T-SQL statements.

Using DMVs to improve SQL index effectiveness

Dynamic management views measure the effectiveness of indexes and discover fragmented indexes that may slow down SQL Server.

Gaining the benefits of DMVs for SQL Server

Dynamic management views help monitor SQL Server health and tune performance. Learn how to use DMVs to retrieve critical data on the internal workings of SQL Server.