Statements (19)
| Predicate | Object |
|---|---|
| gptkbp:instanceOf |
database concept
|
| gptkbp:abbreviation |
gptkb:DMV
|
| gptkbp:accessibleBy |
T-SQL SELECT statement
|
| 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 |
diagnosing problems
monitoring database health tuning performance |
| gptkbp:relatedTo |
dynamic management function
|
| gptkbp:result |
database state information
server state information |
| gptkbp:usedIn |
gptkb:Microsoft_SQL_Server
|
| gptkbp:bfsParent |
gptkb:sys.dm_db_index_usage_stats
gptkb:sys.dm_exec_sessions |
| gptkbp:bfsLayer |
7
|