Post reply

Index Tuning Wizard error

  • October 14, 2004 at 3:47 pm

    #162307

    I have captured a trace file with daily statements that I want evaluated to have indexes suggested for performance improvement.  I want to use the Index Tuning Wizard to help me decide on what indexes to add or to delete.  I have thousands of queries and I already know that the indexes that are already on the tables in the database are not being used as they should.  My problem is that when I use the ITW either with my trace file or a SQL script as my workload file, I get a error that says...

    "There are no events in the workload.  Either the trace file contained no SQL Batch or RPC events or the SQL Script contained no SQL queries."

    The trace file does contain bothe SQL Batch and RPC events.  I went Googling for this error and only found one place that says that this could be an issue with the install of SQL Server.  I went to another SQL Server and captured a like trace file on a different database and used the ITW and it worked fine. 

    Has anyone had this error and what can I do about it???

    --Lori

  • October 18, 2004 at 8:00 am

    This was removed by the editor as SPAM

  • October 18, 2004 at 9:12 am

    #527058

    if the trace is incomplete it could cause this. Usually its due to a trace that isn't setup to caputure the correct data for the ITW.

    Wes

  • February 16, 2005 at 2:19 pm

    #542643

    I am getting the exact same error using ITW in Query Analyzer against a single select statement.  In playing with it, I have found it will not analyze a query it cannot parse.

    Take care,

    Bert

    "Speculations? I know nothing about speculations. I'm resting on certainties. I know that my Redeemer lives, and because He lives, I shall live also." - Michael Faraday

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply