Index Tuning Wizard

  • Hi, I am experiencing a strange problem that has been buggng me for some time now. I have a stored procedure that that is taking 2 - 2.5 minutes to complete when executed from Query Analyser.  I  run the Index Tuning Wizard that does not identify any viable index changes. However, when I execute the query following this analysis, it now completes in a couple of seconds.  It continues to do this for a while (sorry, can't be more specific), before reverting back to the +2 minute response. Any ideas on what may be happening here and more importantly, how I can use this to bring about a permamnent performance improvement. Thanks

  • Hi,,

    When you execute a query two or tree times, the statistics of the query is in "cache"  and the next times is excuted more quickly.

    When you run the execution plan is some icon with high %, may be you need review the info..

    The tables involved are big??

    Thnks¡¡

    JR

  • I am not a giant fan of Index Tuning Wizard.

    I usually look at the columns being joined and the columns used for filtering especially if the tables are over 1,000 rows.

  • What about starting up Profiler and see what's going on behind the scenes?

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • Thanks Frank (and everybody else). I will give the profiler a try to see what is going on behind the scenes.

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

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