065. Find usage of Database Indexes – SQL Server Script

Performance Improvement in SQL, SQL Downloads, SQL SERVER, Sql Server Scripts
1
2
3
4
5
6
7
8
9
10
11
12
SELECT  
    OBJECT_NAME(DDIUS.OBJECT_ID) AS [OBJECT NAME]
     ,I.[NAME] AS IndexName
     ,USER_SEEKS AS TotalUserSeek
     ,USER_SCANS AS TotalUserScan
     ,USER_LOOKUPS AS TotalUserLookup
     ,USER_UPDATES AS TotalUserUpdate
FROM SYS.DM_DB_INDEX_USAGE_STATS AS DDIUS
INNER JOIN SYS.INDEXES AS I
    ON I.OBJECT_ID = DDIUS.OBJECT_ID
    AND I.INDEX_ID = DDIUS.INDEX_ID
WHERE OBJECTPROPERTY(DDIUS.OBJECT_ID,'IsUserTable') = 1