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 |
|
coolerbob
Aged Yak Warrior
841 Posts |
 Posted - 2007-08-14 : 12:07:37
|
| Does SQL Server store somewhere (in a table that I can query) when last an index was used by any queries?Or does it store which query plans it's a part of? |
|
|
ashley.sql
Constraint Violating Yak Guru
299 Posts |
Posted - 2007-08-14 : 12:10:23
|
| maybe some third party tools for auditing can do thisAshley Rhodes |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-14 : 22:24:21
|
| There are index usage report in sql2k5. |
|
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-08-14 : 23:44:56
|
| There are some DMVs that maintain stats on index usage in 2005..http://sqlserver-qa.net/blogs/perftune/archive/2007/07/27/1175.aspxDinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
coolerbob
Aged Yak Warrior
841 Posts |
Posted - 2007-08-15 : 04:32:40
|
quote:
Originally posted by dinakar
There are some DMVs that maintain stats on index usage in 2005..http://sqlserver-qa.net/blogs/perftune/archive/2007/07/27/1175.aspx
very nice!that's exactly what I was after. I'm reading through the DMV stuff in BOL now.It looks like system_seek is referring to when the server uses the index to calculate stuff like whether to put it in a query plan or not and user_seeks means when a user calls a query that actually uses that index. |
|
|
|
|
|
|
Index usage