#sys.dm_db_index_usage_stats

[seniordba]

Find Unused Indexes in SQL Server

Find Unused Indexes in SQL Server

Every SQL Server Database Administrator must monitor database performance and add or remove indexes as required. In this article by Sudarshan Narasimhan we see a couple of scripts on the subject.

Identifying Unused Indexes

USE [DBNAME] /* Replace with your Database Name */ GO --TOTALLY UN-USED INDEXES SELECT DB_NAME(s.database_id) as [DB Name], OBJECT_NAME(s.[object_id]) AS [Table Name], i.name…

View On WordPress