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.

What SQL Statements Are Currently Executing?

This article describes a utility that allows you to identify what SQL statements are currently executing.

SQL Server System Configuration Values

Often times we need to review the SQL Server instance configuration values while troubleshooting performance problems. What alternatives are available to capture this information? With all of the new views in SQL Server 2005, is one available with the configuration values, a description and the list of possible values?

Dynamic Management Views