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
|