Monitoring Microsoft SQL Server with Dynamic Management Views
Play Monitoring Microsoft SQL Server with Dynamic Management Views
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.