Uses of SQL Server Index Tuning Wizard

The following are the uses of Index Tuning Wizard:

1>For a given workload,the best possible combination of indexes for a database is recommended.

2>The effects of the proposed recommendation about the indexes, distribution of queries among tables,and the query performance in the workload can be analyzed.

3>For a small set of problem queries,the way to tune the database will be recommended.

4>It will specify the advanced options such as the disk space constraints that can be customized.

The recommendation provided by the wizard can either be implemented immediately ,or saved and executed manually by the user at later time,or can be implemented later by creating a SQL Server job to execute a SQL script.


Author: Mayur20 Jun 2008 Member Level: Silver   Points : 1

Hi Dude,
Thanks for the info.
Looking forward can you add some more info about index tuning wizard?

  • Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
  • No HTML formatting and links to other web sites are allowed.
  • This is a strictly moderated site. Absolutely no spam allowed.
  • Name: