SQL Server Performance

index problems

Discussion in 'Performance Tuning for DBAs' started by manu_dba, Oct 3, 2006.

  1. manu_dba New Member

    i have a database very improtant from productio point of view.
    i had run trace on the server and collected the queries,
    can you please guide that how i should learn that
    which indexes on the tables are good and which not.
    there are some indexes which are redundant.please guide me how i can improve the performance after creating and dropping the useless indexes.

    thanks
  2. Roji. P. Thomas New Member

Share This Page