sys.dm_db_index_operational_stats

(Louis Davidson) This object provides very useful stats on how many times an index has been used, locked, waited on, etc. An index in this context can mean several things: a clustered index, heap, index, or a partition of either of these. The grain of the function is down to the partition level, so

Read More - Register for Free Membership