How to determine obsolete indexes

I have a very heavily queried large table. This table is about 95% read from and 5% written to. The table has 9 indexes some of which are used as covering indexes in queries that have to be very fast.

I would like to see if I can eliminate some of these indexes and I was wondering how I can determine how much a certain index is used to decide whether there are any obsolete indexes that just take up space and slow inserts down.

I do not want to use the Index tuning wizards ad would like to avoid running large jobs just ot determine usage. Any ideas ?  
rkrzystonAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Guy Hengel [angelIII / a3]Billing EngineerCommented:
SQL Server 2005:
there are dynamic views to show exactly these information

SQL Server 2000:
collect all the used WHERE and ORDER BY clauses, and determine the SARGs (SearchableARGuments) that are used. From that, the list of indexes can be determined quite easily...
To collect all the SELECTS/INSERTS etc, you run a trace (SQL Profiler), directly into a table.
From that table, extract the WHERE and ORDER BY clauses...

Hope this helps
rkrzystonAuthor Commented:
I was hoping that SQL Server 2000 keeps some sort of statistics on how often an index is used... Is there nothing of this sort ?
Guy Hengel [angelIII / a3]Billing EngineerCommented:
no

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.