November 25, 2011 at 10:14 am
In summary, when I do a simple query in SS_2000 query analyzer against a sql 2000 databases that runs on a local server, I can see 201 ms as duration for SS:stmtcompleted, but Q/A reports a 20 sec execution time.
So would the difference in time be a sum of all the 'overhead' in that statement returning to my desktop Q/A session ?
November 28, 2011 at 11:54 am
npcrwill8 (11/25/2011)
In summary, when I do a simple query in SS_2000 query analyzer against a sql 2000 databases that runs on a local server, I can see 201 ms as duration for SS:stmtcompleted, but Q/A reports a 20 sec execution time.So would the difference in time be a sum of all the 'overhead' in that statement returning to my desktop Q/A session ?
What's the # of rows returned by the two queries? Are the indexes different? Are you going through a linked server? Are statistics up to date in QA? Are the plans the same?
There's so many possible reasons for the difference it's almost impossible to troubleshoot from this side without a lot more information.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply