SQL Server Performance

How to use Index Tuning Wizard

Discussion in 'SQL Server 2005 T-SQL Performance Tuning' started by tboonleong, Mar 5, 2007.

  1. tboonleong Member

    Dear All,
    I am totally new with this index tuning wizard. Wat is the purpose and how to use the index performing tuning? When do we need to use this index tuning wizard?


  2. dineshasanka Moderator

    ITW will give recommentdation to improve performance by introducing indexes and updating statistics.

    you can use thiw when you feel your queries have low performance.


    ----------------------------------------
    Contributing Editor, Writer & Forums Moderator
    http://www.SQL-Server-Performance.Com

    Visit my Blog at
    http://dineshasanka.spaces.live.com/
  3. MohammedU New Member

    I believe you are using sql 2005 because you posted in 2005 forum...

    In sql 2005 ITW changed to DTA (Database Tuning Advisor)
    For more details read SQL Server 2005 Books Online topic "
    Database Engine Tuning Advisor Overview "....


    Database Engine Tuning Adviser: How to tune your new SQL Server
    http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1161285,00.html


    MohammedU.
    Moderator
    SQL-Server-Performance.com

Share This Page