Skip to content

Instantly share code, notes, and snippets.

@codingbadger

codingbadger/Index Usage

Created September 4, 2013 10:12
Show Gist options
  • Save codingbadger/6435153 to your computer and use it in GitHub Desktop.
Save codingbadger/6435153 to your computer and use it in GitHub Desktop.
Download ZIP
Index Usage for Insert / Update / Delete stats
Raw
Index Usage
SELECT OBJECT_NAME(A.[OBJECT_ID]) AS [OBJECT NAME],
I.[NAME] AS [INDEX NAME],
A.LEAF_INSERT_COUNT,
A.LEAF_UPDATE_COUNT,
A.LEAF_DELETE_COUNT
FROM SYS.DM_DB_INDEX_OPERATIONAL_STATS (NULL,NULL,NULL,NULL ) A
INNER JOIN SYS.INDEXES AS I
ON I.[OBJECT_ID] = A.[OBJECT_ID]
AND I.INDEX_ID = A.INDEX_ID
WHERE OBJECTPROPERTY(A.[OBJECT_ID],'IsUserTable') = 1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment