ALL DMV’s In SQL SERVER

SELECT * FROM SYS.dm_os_memory_allocations               –<< Notice that all DMVs starts with SYS.DM SELECT * FROM SYS.dm_db_xtp_nonclustered_index_stats   SELECT * FROM SYS.dm_db_mirroring_past_actions

Continue reading