The FK Columns

Parameter Defaults

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.