April 29, 2009 at 12:13 pm
I have 2 servers where in if i run a job the difference in the time to ran the same job has lot of difference.
on ServerA it takes 5hrs and ServerB it takes 9 hrs. I assume both the servers should take same time approx as i am running same piece of code against the same data unless there is some hardware diffference. There is a small diffrence in the RAM as far as i know part from that everything is same.
How would i find the bottle neck on the slowest server? and is there an easy way to compare every configuration of the 2 servers.
April 29, 2009 at 12:18 pm
First you have to do couple of things...
1. Make sure you have updated the statistics on both the DB
2. Check the execution plan and see if there is a difference in the execution plan
3. Check if there is some kind of IO bottle neck
4. Check if there is some kind of blocking on the second server where it takes more time.
Any of these three things can make the query to take different amount of time when executing a query
Just my 2 cents. Maybe others have a better idea.
-Roy
April 29, 2009 at 1:16 pm
For step 1 as you said, I am running against the same databases from both the servers.
how wud i check step 3 and 4?
April 29, 2009 at 1:25 pm
Tara,
I misunderstood your question. I thought you were running it on two DB and not two clients. That is why I raised the Blocking issue and IO issue.
Are both clients running using the same Login? A badly configured network card can cause the drastic drop in performance. Or your second client does not have enough page file or memory.
Just for curiosity sake, did you check the execution plan.
-Roy
April 29, 2009 at 2:07 pm
1. badly configured network card can cause the drastic drop in
2. enough page file
how would i check these 2.
April 29, 2009 at 2:18 pm
There are some recommended size for page file. I think it is one and a half time the total size of your RAM.
-Roy
May 1, 2009 at 6:28 am
is there a way i script out complete configuration of the server bu that way i can check whats the diffference in the configuration and settings.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply