TitleistDBA
IS-IT--Management
In MSSQL 2000 Ent edition is there anyway to tell how often or even if an Index has ever been used?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Index Usage
- Thread starter TitleistDBA
- Start date
- Status
mrdenny
Programmer
- May 27, 2002
- 11,595
SQL Profiler can tell you this. The data isn't stored anywhere in SQL 2000.
Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)
--Anything is possible. All it takes is a little research. (Me)
![[noevil]](/data/assets/smilies/noevil.gif "[noevil] [noevil]")
Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)
--Anything is possible. All it takes is a little research. (Me)
- Thread starter
- #3
TitleistDBA
IS-IT--Management
I know I can get current index usage from SQL Profiler, but I was hoping there was some unsupported DBCC command I didn't know about that would show me how often each index is accessed.
Thanks for your help.
Thanks for your help.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question