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-06-22 : 16:37:07
|
| When I run an index usage report on the database it tells me the number of index scans, index seeks, etc.I know that I can restart SQL Server to clear out those statistics but is there a way to clear them out without restarting it? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
ferrethouse
Constraint Violating Yak Guru
352 Posts |
Posted - 2011-06-22 : 17:06:20
|
| Oops, sorry, I ask lots of questions. Don't really understand what was suggested there.The problem I have is that I have 12 indexes on a table. I added two new indexes a couple of days ago. I want to know if the addition of those two new indexes have caused SQL Server to use other indexes much less - to the point that I can delete them now. There is a "last used" statistic but I can't rely on that because it doesn't give me an idea of how much they are still being used. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Clear out report statistics