Tag: sys.dm_db_index_operational_stats

Snapshots of Index Contention

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…

Monitoring Index Contention With DMFs

Often when I am load testing an application with a client I want to check to see if there is any index contention in a database.  To do this, I use the DMF sys.dm_db_index_operational_stats.  For a good rundown on this DMF, I recommend reading Louis Davidson’s blog entry on sys.dm_db_index_operational_stats.  Instead of repeating that content,…