sys.dm db index usage stats

GPTKB entity

Statements (30)
Predicate Object
gptkbp:instanceOf gptkb:dynamic_management_view
gptkbp:hasColumn database_id
index_id
last_system_lookup
last_system_scan
last_system_seek
last_system_update
last_user_lookup
last_user_scan
last_user_seek
last_user_update
object_id
system_lookups
system_scans
system_seeks
system_updates
user_lookups
user_scans
user_seeks
user_updates
https://www.w3.org/2000/01/rdf-schema#label sys.dm db index usage stats
gptkbp:isAvailableSince gptkb:SQL_Server_2005
gptkbp:partOf gptkb:SQL_Server
gptkb:Azure_SQL_Database
gptkbp:requiresPermission VIEW SERVER STATE
gptkbp:result index usage statistics
gptkbp:usedFor index maintenance decisions
monitoring index usage
gptkbp:bfsParent gptkb:Dynamic_Management_Views
gptkbp:bfsLayer 6