Script to list out all DMVs and DMFs of SQL Server
Posted by Jugal Shah on December 8, 2010
-- To check the diffrent kind of system objects
SELECT Distinct type_desc
FROM sys.system_objects
-- To get the list of DMVs or DMFs
SELECT name, type, type_desc,SCHEMA_NAME(schema_id) as SNAME
FROM sys.system_objects
WHERE name LIKE 'dm[_]%'
ORDER BY name
