What are DMVs

What are DMVs

DMVs i.e. Dynamic Management Views expose the memory structures within SQL Server and is used to determine how SQL Server uses res0urces like CPU,Memory,IO,etc.

DMVs can be broadly classified into 2 types Server Level & Component Level where the perfomance related DMVs fall in the server level category

DMVs are views present in the schema sys and can be identified by dm_ prefix, so example of a DMV would be sys.dm_exec_sessions

Lets us see the various DMVs available in the coming posts.