SQL Server Performance

How to see by how much frequecy the index is being used by the optimizer...

Discussion in 'Performance Tuning for DBAs' started by Aston, Apr 30, 2008.

  1. Aston New Member

    Hi ,
    In SQL SERVER 2000 , How can we see that the indexes built by us are being utilized by query optimizer.
    Means i want to identify the indexes that are overhead than the benficial.
    Thanks!!
    Aston, Apr 30, 2008
    #2

  2. MohammedU New Member

    It is very tuff to get this info from SQL 2000 where in 2005 is easy....
    Best option would be run the SQL profiler with Query plan option and parse the info....
    Note: it is not advisable to run this type of profile on production server all day...
    MohammedU, Apr 30, 2008
    #3

  3. satya Moderator

    Not easy to find in SQL 2000 version, rather you hvae to go through the queries that are generated on your database to see their execution plans (manually) or even most complexed queries to fine tune them.
    satya, May 1, 2008
    #4

Share This Page