Skip to content

Instantly share code, notes, and snippets.

@codingbadger

codingbadger/Index Usage - Seeks

Created September 4, 2013 10:12
Show Gist options
  • Save codingbadger/6435159 to your computer and use it in GitHub Desktop.
Save codingbadger/6435159 to your computer and use it in GitHub Desktop.
Download ZIP
Index Usage stats for reads
Raw
Index Usage - Seeks
SELECT OBJECT_NAME(S.[OBJECT_ID]) AS [OBJECT NAME],
I.[NAME] AS [INDEX NAME],
USER_SEEKS,
USER_SCANS,
USER_LOOKUPS,
USER_UPDATES
FROM SYS.DM_DB_INDEX_USAGE_STATS AS S
INNER JOIN SYS.INDEXES AS I
ON I.[OBJECT_ID] = S.[OBJECT_ID]
AND I.INDEX_ID = S.INDEX_ID
WHERE OBJECTPROPERTY(S.[OBJECT_ID],'IsUserTable') = 1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment