Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ferrethouse
Constraint Violating Yak Guru
352 Posts |
 Posted - 2011-03-03 : 22:40:49
|
| I use the "index usage report" to keep on eye on used and unused indexes. I though that recycling sql server would clean out these statistics so I could start fresh. Is there a way to "reset" the numbers? |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2011-03-04 : 05:52:05
|
| You may consider storing the data in the DMV - sys.dm_db_index_usage_stats - at regular intervals and working out any movements INSTEAD of "resetting the numbers"According to BOL, the counters are initialized wherever the SQL server service is started; whenever a database is detached or is shut down (e.g. AUTO_CLOSE). |
 |
|
|
|
|
|
Clear out index usage statistics