Posts Tagged: sys.dm_db_index_operational_stats

Snapshots of Index Contention

Posted by & filed under , , , , .

Occasionally, I need to determine where index hotspots are located within databases.  To do this, I use the DMV sys.dm_db_index_operational_stats.  I’ve talked about this DMV before while I was going through the index analysis blogs posts. This DMV returns locking and blocking information for tables and indexes in the database.  This information is aggregated since […]