Dynamic Management Views and Functions Tips

added by cengizh
7/25/2010 6:53:32 AM


Dynamic Management Views and Functions feature comes with SQL Server 2005 version. They provides some information about system, and what is going under when SQL Server running. So you can use DMV and DMF objects to monitor the system and tune it. These object located under sys schema and names are start with the dm. As previous system objects in SQL Server, internal implementation of these objects can be change with the future releases. I want to share some code snippets about some of DMV/F’s which I had use while tuning and monitoring SQL Server.