Re: Strange behavior of Index tuning wizard

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

From: ME (mail_at_mail.com)
Date: 07/01/04 

Date: Thu, 1 Jul 2004 14:30:20 -0700

different DBID?
same thing here.

"Davie" <anonymous@discussions.microsoft.com> wrote in message
news:244af01c45fa9$da0a33f0$a601280a@phx.gbl...
> 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)
  • 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 Wizard problems
    ... The replay trace is not very suitable for the ITW. ... "If you do not have an existing workload for the Index Tuning Wizard to ...
    (microsoft.public.sqlserver.security)
  • 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)