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.
No comments:
Post a Comment