-- Esse script retorna uma série de view's de gerenciamento dinâmico divididas por categorias.
-- Veja mais detalhes aqui

	
SELECT name as [DMV/DMF Name],type_desc as [Type], [DMV Category]= CASE WHEN name LIKE 'dm_audit%' THEN 'Auditing Related DMV' WHEN name LIKE 'dm_cdc%' THEN 'Change Data Capture Related DMV' WHEN name LIKE 'dm_clr%' THEN 'CLR Related DMV' WHEN name LIKE 'dm_db%' THEN 'Database&Objects Related DMV and DMF' WHEN name LIKE 'dm_exec%' THEN 'Execution Related DMV and DMF' WHEN name LIKE 'dm_xe%' THEN 'Extended Events Related DMV' WHEN name LIKE 'dm_fts%' THEN 'Full-Text Search Related DMV and DMF' WHEN name LIKE 'dm_filestream%'THEN 'FileStream Related DMV' WHEN name LIKE 'dm_io%' THEN 'I/O Related DMV and DMF' WHEN name LIKE 'dm_sql%' THEN 'Object Ref Related DMV and DMF' WHEN name LIKE 'dm_provider%'THEN 'Provider Related DMV and DMF' WHEN name LIKE 'dm_qn%' THEN 'Query Notifications Related DMV' WHEN name LIKE 'dm_repl%' THEN 'Replication Related DMV' WHEN name LIKE 'dm_resource%'THEN 'Resource Governor Related DMV' WHEN name LIKE 'dm_broker%' THEN 'Service Broker Related DMV' WHEN name LIKE 'dm_os%' THEN 'SQL Server OS Related DMV' WHEN name LIKE 'dm_server%' THEN 'Server Audit Related DMV and DMF' WHEN name LIKE 'dm_tran%' THEN 'Transactions Related DMV' WHEN name LIKE 'dm_cryp%' THEN 'Security Related DMV and DMF' WHEN name LIKE 'dm_cdc%' THEN 'Change Data Capture Related DMV' WHEN name LIKE 'dm_database%'THEN 'Transparent Data Encryption Related DMV' ELSE'Other DMV' END FROM sys.system_objects WHERE name LIKE 'dm[_]%' ORDER BY [DMV Category]