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
WHERE name LIKE 'dm_%'
ORDER BY name