RE: Index Tuning Wizard problems

From: Jivko Dobrev [MS] (jivkod@online.microsoft.com)
Date: 07/06/02 

From: jivkod@online.microsoft.com (Jivko Dobrev [MS])
Date: Sat, 06 Jul 2002 00:01:15 GMT

Hello Raymond,

The replay trace is not very suitable for the ITW. From Books Online:

"If you do not have an existing workload for the Index Tuning Wizard to
analyze, you can create one using SQL Profiler. Either create a workload
using the Sample 1 - TSQL trace definition or create a new trace that
captures the default events and data columns. After you have determined
that the trace has captured a representative sample of the normal database
activity, the wizard can analyze the workload and recommend an index
configuration that will improve the performance of the database."

So, just accept the defaults and capture the trace and you should be good
to go with the ITW.

Hope that this information will be useful for you.
Have a wonderful day!
Jivko Dobrev

This posting is provided "AS IS" with no warranties, and confers no rights.

Relevant Pages

  • Re: Strange behavior of Index tuning wizard
    ... > Having some strange problem with ITW. ... > Created workload in Production Server, imported trace ...
    (microsoft.public.sqlserver.server)
  • Re: [patch] speed up / fix the new generic semaphore code (fix AIM7 40% regression with 2.6.26-r
    ... workload by getting rid of the BKL dependency altogether. ... Did somebody have any trace on which BKL taker it is? ... wasn't file locking. ... system overhead is consistently 20% during this test. ...
    (Linux-Kernel)
  • Strange behavior of Index tuning wizard
    ... Having some strange problem with ITW. ... Created workload in Production Server, imported trace ... table to DEV, running ITW in DEV Server (DB schema is ...
    (microsoft.public.sqlserver.server)
  • Re: index tuning
    ... I would run a trace on this table over a typical ... Find out what the SARGs are for these queries and make sure you are ... dimitris wrote: ... > fed to the index tuning wizzard and now over the last 3 months it has ...
    (microsoft.public.sqlserver.tools)
  • Index Tuning Wizard Misbehaves
    ... I get inconsistent behavior when running ITW against the *same* trace ... using the Thorough option against the *same* trace file I get: ... Once ITW has made the above statement, no amount of reconfiguration of the ... reconfiguration is to reselect the previously successful Fast option. ...
    (microsoft.public.sqlserver.server)
Quantcast