Dynamic Management View

GPTKB entity

Statements (17)
Predicate Object
gptkbp:instanceOf SQL Server feature
gptkbp:abbreviation gptkb:DMV
gptkbp:accessibleBy T-SQL queries
gptkbp:category sys.dm_* views
gptkbp:documentation https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-views-transact-sql
https://www.w3.org/2000/01/rdf-schema#label Dynamic Management View
gptkbp:introducedIn gptkb:SQL_Server_2005
gptkbp:permits VIEW SERVER STATE
VIEW DATABASE STATE
gptkbp:purpose diagnose performance issues
monitor SQL Server health
provide server state information
gptkbp:type system view
gptkbp:usedIn gptkb:Microsoft_SQL_Server
gptkbp:bfsParent gptkb:sys.dm_exec_requests
gptkb:sys.dm_os_wait_stats
gptkbp:bfsLayer 7