September 10, 2007 at 9:24 am
Hi Experts,
I have executed the same query in two different server(sqlserver2000).
Server1 : Execution Time : 30 Seconds
Server2 : Execution Time : 10 minutes
what kind of possibilities forcing server2 to execute the same query for 10 minutes ?
Inputs are welcome !
Regards
Karthik
karthik
September 10, 2007 at 1:24 pm
it could be so many things there are almost too many to mention. Are the db's from the same backup or are they different versions? does the hardware match exactly? are they setup the same as far as how sql is setup to use memory, cpu, etc. are the indexes being rebuilt on the regular for both boxes? statistics updated on both boxes?
another thing to look at is the execution plans to see if they match or not.
September 11, 2007 at 6:31 am
Both server has the same configuration ,whatevere you mentioned in your post. But i dont know why the server2 is taking long time to execute the query ?
karthik
September 11, 2007 at 6:44 am
As Adam said, look at the execution plans on both servers.
Assuming that everything else is equal, I'd guess a parameter sniffing issue.
September 11, 2007 at 7:30 am
Another thing is - the queries is said to be the same, but what about the answers..?
Are both queries on both servers returning the exact same result?
/Kenneth
September 11, 2007 at 8:38 am
Yes both servers returning the exact result.
karthik
September 11, 2007 at 10:17 am
You didn't answer the questions regarding execution plans.
September 11, 2007 at 11:40 am
check the fragmentation level of the indexes used in the queries and the statistics of the tables involved.
* Noel
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply