February 6, 2008 at 7:59 am
IS there any way to get this info on sql server 2000?
February 6, 2008 at 8:50 am
No, it's not tracked.
You can profile all your queries and do some heavy duty analysis, but there's no other way to tell.
February 12, 2008 at 8:26 am
This was what we did previously. We had one large database, with a lot of large tables and indexes that grew over time. When we wanted to identify unused indexes, we targeted the large indexes, as these were the ones that would incur the highest hit when updating.
We ran DBCC MEMUSAGE periodically e.g. DBCC MEMUSAGE (names, 100), to identify the largest x objects in the cache after the database had been running for a while. Because only objects (including indexes)that were frequently used would show up in the list, we had a rough idea of which indexes were infrequently used, or not used at all.
SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.
February 13, 2008 at 7:05 am
run profiler whilst representative work is taking place and feed the results into the index tuning wizard? The recommendations it gives compared to the indexes you have could give clues.
---------------------------------------------------------------------
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply