This isn't necessarily true. The
sys.dm_db_index_usage_stats DMV is cleared by a restart of SQL or any time the database is closed, so if you've had the instance running for a day then the best you can say is that the indexes that have no seeks or scans is that they haven't been used in a day.
Better to monitor the
sys.dm_db_index_usage_stats DMV over a longer period of time. Can't really suggest a time frame because it depends on your particular database usage - e.g. if you hit the database consistently in the same way then probably only need to monitor for a few days, if you hit the database in an irregular fashion then we could be looking at a much longer time period.
commented on Mar 28 2012 6:33AM