January 12, 2009 at 6:16 am
Hi All,
I have fine tuned a query from 4 hours to 5 minutes. I have execute the same query( fine tuned one) in other server. It took 45 seconds only.
say for example,
Server Details:
DEV_SERVER1
DEV_SERVER2
Assume, i have execute my query on DEV_SERVER1. It took 5 minutes.
Now, i have executed the same query(Not even modified a single dot) on DEV_SERVER2. It took 45 seconds only.
So i just thought the following things may get affect the query performance.
1) RAM capability
2) HARD DISK space
3) No of users connected to that server
4) No of applications installed in that server
Please let me know whether my thoughts are correct or not.
it would be appreciable if somebody add more points.
🙂
karthik
January 12, 2009 at 6:18 am
I have posted it twice. How should i delete it ?
I clicked 'DELETE' button. but i am unable to delete it.
karthik
January 12, 2009 at 6:25 am
Add...
Indexes & Statistics
--Ramesh
January 12, 2009 at 6:28 am
Perhaps an obvious question but is the quantity of data the same on each DEV_SERVER as many organisations run different projects on different DEV servers resulting in completely different volumes of data on each?
Regards,
Simon
January 12, 2009 at 6:30 am
Some more points...
I have tested the indexes and statistics...there is no difference between both servers and number of rows are almost same between the two server.
karthik
January 12, 2009 at 7:16 am
karthikeyan (1/12/2009)
Some more points...I have tested the indexes and statistics...there is no difference between both servers and number of rows are almost same between the two server.
I meant last index/statistics update on the database....
--Ramesh
January 12, 2009 at 7:23 am
yes..it was run 15 days back only ( in both server).
karthik
January 12, 2009 at 7:35 am
Have you checked the execution plans? Can you attach those with the post?
--Ramesh
January 12, 2009 at 7:55 am
One thing I run into with such problems is fragmentation.
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply