SELECT
OBJECT_NAME(s.object_id) AS TableName,
i.name AS IndexName,
i.type_desc AS IndexType,
s.leaf_insert_count AS Inserts,
s.leaf_update_count AS Updates,
s.leaf_delete_count AS Deletes
FROM
sys.dm_db_index_operational_stats(NULL, NULL, NULL, NULL) s
INNER JOIN
sys.indexes i ON i.object_id = s.object_id AND i.index_id = s.index_id
WHERE
s.leaf_insert_count > 0
ORDER BY
s.leaf_insert_count DESC;
|