December 2, 2004 at 7:52 am
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
December 2, 2004 at 8:49 am
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
December 3, 2004 at 5:26 am
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.
December 3, 2004 at 5:33 am
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]
December 8, 2004 at 2:58 am
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