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