How many DMV are available in SQL Server 2008 ?

Leave a comment (2) Go to comments

If you have the following questions, then have landed up the right page

How many Dynamic Management Views (DMV) are available in SQL Server 2008 ?

How SQL Server DMV are interlinked ?

From where these DMV gets the data ?

What are the key columns in the DMV?

How many Dynamic Management Function (DMF) are available in SQL Server 2008 ?

There is a single answer to all these question and the answer is "SQL Server 2008 System Views Map", this, SQL Server 2008 System Views Map, a  pdf file, shows the key system views included in SQL Server 2008, and the relationships between them, which is available at Microsoft site for download.

Click Here to download SQL Server 2008 System Views Map


Click Here to download SQL Server 2005 System Views Map

Every DBA, should have this tool handy to know, what all information can be fetched from the the DMV and DMF.

Tags : SQL Server DMV interlinked,list all Dynamic Management Views, list all DMV, DMV sql server,sql server Dynamic Management Function , list all DMF, DMF, DMV, sql server DMF, DMF available in sql server, DMV available in sql server,list all DMV, list all DMF,DMV data source,How SQL Server DMV are interlinked, DMV and DMF, DMV DMF SQL Server

EOF - How many DMV are available in SQL Server 2008 ?, SQL Server 2012 , 2008 R2 , 2008 , 2005 , 2000
Leave a comment

2 Comments.

  1. good page-the link provided is just the job!

Leave a Reply

Your email address will not be published. Required fields are marked *


*


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Notify me of followup comments via e-mail. You can also subscribe without commenting.

Trackbacks and Pingbacks: