How To Find Unused Indexes in SQL Server

Index is an object that improves performance in the database in general. Many inexperienced database administrators or application developers create too much index thinking that they always will improve performance. Generally, you do not need most of these indexes. Therefore, when a good database administrator starts looking at a database system, one of the first steps is to find and remove unused indexes in databases. You may also want to read the below articles.

How To Find Missing Indexes in SQL Server“,

How To Find Most Expensive Queries in SQL Server“,

“How To Find Unused Tables in SQL Server”

With the help of the following script, you can find unused indexes since the last restart of the sql server service.