SQL Server Performance

Tool for determining index usage

Discussion in 'Third Party Tools' started by bbains, May 6, 2003.

  1. bbains New Member

    Hi Again!

    I'm trying to optimize a database that has just tons and tons of indexes. I've already identified several that don't need to be there based on their selectivity (or complete lack there of). I'd like to know if there's a tool available that can monitor the activity on the database and tell me which indexes are being used and how often. Perhaps there's some way to have Profiler do this? Or maybe a 3rd party tool?

    Any thoughts or assistance is greatly appreciated.

    [8]

    Cheers,

    Buddy
  2. satya Moderator

Share This Page