May 9, 2011 at 7:33 am
Hi All,
I have a query that in Management studio returns in about 2 seconds, but from the application it takes nearly a minute. I also remember a while back there being an article or blog post on how to diagnose the issue, but I can't find it. Anyone know where I can find that article?
May 9, 2011 at 8:24 am
Not sure what article you're talking about, but I'd check the connection settings between the two. Probabably one has different ANSI settings than the other which leads to a different execution plan. You can also see the ANSI settings in the execution plan itself, so checking that is a great place to start. Plus, to validate that's the issue, you'd want to know that you're getting two different execution plans anyway. You should be able to pull both as an estimated plan from the plan cache using DMOs.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply