August 21, 2008 at 1:47 pm
Hi All,
I have two servers following are the description:
X1 -- Development server
X2 -- Test Server
Both server is using same linked server with same configuration. Test server is having 16 processors and 8 gigs of Ram and Dev server is having 8 Processors and 4 gigs of ram.
Today I am executed select statement from dev server and it took around 13 sec to fetch the results but when I tried to execute same select statement from Test server which is having far good configuration than dev it took around 30 min to fetch the records.
I don't know what is happining.
Urgent help would be appriciable.
Thanks in advance.
Ausin
August 21, 2008 at 2:03 pm
Have you analyzed both execution plans to see where it is you are slowing down? That would be the first place to start...
August 21, 2008 at 2:07 pm
The query cost was 100% on both servers and other attributes were also common.
August 21, 2008 at 2:11 pm
Austin_123 (8/21/2008)
The query cost was 100% on both servers and other attributes were also common.
I haven't done much execution plan analyzing on a linked server call in awhile, so I don't remember how it is displayed. But anyways, do you get the breakdown in that batch showing how the 100% is consumed per step?
What exactly is your querying doing against the remote location? Is all the work done remotely? Is data pulled back and joined on? The more information the better ...
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply