Session Details -
Monitoring SQL Server with Dynamic Management Views (2005 & 2008)
|
|
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.
|
|
|
Satya Shyam K Jayanty
|
|
|
|
Knowledge is the power and you will gain by sharing it;
I'm an Independent Database expert, with over 16 years of experience in application designing, developing and managing database technologies using industry famous technologies & software. I have been working with SQL Server since version 4.2 (1996) and active member & moderator in Technet, MSDN, SQL-Server-Performance.com forums/websites and also writing for http://www.sql-server-performance.com website. I'm a regular speaker and volunteer (Ask The Experts) at SQL Server events such as SQLPASS, Tech-ed etc. and I was awarded as SQL Server MVP since the year 2006. I also update content & manage the website http://www.sqlserver-qa.net.
|