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