dynamic management view

GPTKB entity

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