Statements (21)
| Predicate | Object |
|---|---|
| gptkbp:instanceOf |
SQL Server feature
|
| gptkbp:abbreviation |
gptkb:DMVs
|
| gptkbp:accessedWith |
T-SQL SELECT statements
|
| gptkbp:category |
database-scoped DMV
server-scoped DMV |
| gptkbp:documentation |
https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-views-transact-sql
|
| gptkbp:example |
gptkb:sys.dm_db_index_usage_stats
gptkb:sys.dm_exec_requests gptkb:sys.dm_exec_sessions gptkb:sys.dm_os_wait_stats |
| https://www.w3.org/2000/01/rdf-schema#label |
Dynamic Management Views
|
| gptkbp:introducedIn |
gptkb:SQL_Server_2005
|
| gptkbp:purpose |
diagnose performance issues
monitor SQL Server health provide server state information |
| gptkbp:securityRequirement |
gptkb:VIEW_DATABASE_STATE_permission
gptkb:VIEW_SERVER_STATE_permission |
| gptkbp:type |
system view
|
| gptkbp:usedBy |
database administrators
|
| gptkbp:bfsParent |
gptkb:SQL_Server
|
| gptkbp:bfsLayer |
5
|