Blog Post

Check unused index in SQL Sever 2008

,

Checking for unused indices across your database should also be a part of housekeeping. Usually i would schedule checking for unused indices on quarterly basis. Just to minimize surprises on a database suddenly timing out. The DMV for checking on usage and statistics is sys.dm_db_index_usage_stats. Here’s a script that i use most of the time […]

Rate

Share

Share

Rate