SQL Server: Script to find usage of Database Indexes

In this post, I provide you one script to find total usage of your database indexes in SQL Server.
This is a very useful script for DBA to find out the usage of indexes and ït can also take a decision to remove unused indexes.
Using this script you can find out the total number of seek and scan taken by different indexes.

Anvesh Patel

Leave a Reply

4 Comments on "SQL Server: Script to find usage of Database Indexes"

Notify of
Sort by:   newest | oldest | most voted
Rhonda Swan

Thanks for putting this coding up here. I am going to send it over to my programmer. You have provided a valuable resource to your readers. Thanks so much. Keep it up and live unstoppable my man.

Moises Trucchio

I’d like to start blogging but I have no idea which website to use? Which ones are the best?.