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