Microsoft SQL Dynamic Management Views

The Dynamic Management Views (DMVs) introduced in Microsoft SQL Server 2005 provide DBA information about the current state of the SQL Server machine.

These values help an administrator diagnose problems and tune the server for optimal performance. For more information about dynamic management views and functions, refer to the Microsoft Developer Network Web site, which can be accessed from:

http://msdn.microsoft.com/en-us/library/ms188754(SQL.90).aspx