Hi Friends,

Last week we posted SQL Server Performance Counter Ready Reference, of which we had more than 1000 downloads instantly! We hope it was helpful for the SQL Community! You can download it from our Resource Center.

Here is another wonderful piece of document that can help you find the availability of any DMV/DMF in any version of SQL Server starting from SQL 2005.

Many a times, when we are working with various versions of SQL Server, especially in the role of DBA, and we have a need to work with Dynamic Management Views or Dynamic Management Functions, we struggle to figure out whether a particular DMV/DMF exists in a specific version. We have to check the availability of the object by running our DMV/DMF scripts on that specific Windows box – a tedious/time consuming process.

This document lists down all the SQL Server DMVs/DMFs and their availability in SQL Server 2005, 2008, 2008 R2, 2012 and 2014. Here is a screenshot:

SQL Server DMVs and DMFs - Ready Reference

A nice document that can sit on your desktop 🙂

Download it from our Resource Center.

More such documents coming soon! Subscribe to our newsletter to get notified when we publish such resources.

 

Amit Bansal (SQL MCM, SQL MVP) | Twitter | FaceBook | LinkedIn | FB Page|Ask a SQL Question                                                          Browse more blogs on SQLServerGeeks.com