DMV – Finding the list of DMV or DMF in SQL Server

We know that DMV are a great improvement from SQL Server 2005. To achieve proficiency using DMV, first step is to figure out what are the DMV and DMF available for the specific SQL Server. Please use below query to find the result:

SELECT name, type, type_desc
FROM sys.system_objects
WHERE name LIKE 'dm_%'
ORDER BY name

Comments