Tag: DMFs

  • Script to list out all DMVs and DMFs of SQL Server


    -- 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