Monitoring Microsoft SQL Server with Dynamic Management Views

Play Monitoring Microsoft SQL Server with Dynamic Management Views
Sign in to queue

Description

Dynamic Management Views were added to SQL Server 2005 and have been enhanced in SQL Server 2008. While they provide great functionality and usefulness, it appears they are not widely understood or implemented as yet. This session provides an overview of the Dynamic Management Objects available (both Views and Functions), describes those considered the most useful, and shows how they can be utilized in monitoring, troubleshooting, and ongoing management of SQL Server systems and in gaining an understanding of SQL Server's operation. It also shows how they can be utilized in custom reports in SQL Server Management Studio.

Day:

0

Code:

08_NA_DAT3

Embed

Download

Download this episode

The Discussion

Add Your 2 Cents