Strange behavior of Index tuning wizard

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Davie (anonymous_at_discussions.microsoft.com)
Date: 07/01/04 

Date: Thu, 1 Jul 2004 13:27:38 -0700

Hi All,

Having some strange problem with ITW (SQL2K).

Created workload in Production Server, imported trace
table to DEV, running ITW in DEV Server (DB schema is
identical in Prod and Dev).

When I load trace data into ITW and run it I get pop-
up "workload does not contain any events or queries that
can be tuned against current database". My understanding
is that ITW looks for Eventclass value of 10 and 12
(RPC:Completed and SQL:BatchCompleted), which do exist in
trace table.

Trace table does not have any fields identifying name of
the server/database so that is not the problem. The
strangest thing is when I run ITW on small subset of trace
data (1000 rows) which I moved to a different table, it
runs just fine. However I need larger slice of trace data
to do proper analysis.

Can anyone suggest any way to fix that problem ?

TIA, Davie.

Relevant Pages

  • Re: Strange behavior of Index tuning wizard
    ... I suspect that both the DBID and object Ids are stored in the trace file. ... Wayne Snyder, MCDBA, SQL Server MVP ... > Having some strange problem with ITW. ... However I need larger slice of trace data ...
    (microsoft.public.sqlserver.server)
  • Re: Strange behavior of Index tuning wizard
    ... > Having some strange problem with ITW. ... > Created workload in Production Server, imported trace ...
    (microsoft.public.sqlserver.server)
  • 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)
  • Re: Best way to read from directory with many files
    ... These files are ETL files which contain trace information. ... The database is on a different server. ... If you're CPU bound, then you can either partition the work ahead of time, ... Or you can have a central data structure that each thread consumes ...
    (microsoft.public.dotnet.framework)
  • Re: Running profiler on busy 8-cpu Sql Server
    ... I always start with a light trace and add more detail as I go along to ... SQL Server MVP ... > I think it's also worth saying that you should introduce Profiler ... > SQL Server MVP ...
    (microsoft.public.sqlserver.server)