Click here to Skip to main content
12,064,855 members (40,942 online)
Rate this:
 
Please Sign up or sign in to vote.
I have a local and remote server and I’m executing same query on both but it takes a lot longer to execute on the remote server.

I’ve checked the query plans and they are same on both servers
Posted 10-May-13 18:51pm
stoores253
Comments
Maciej Los 11-May-13 4:25am
   
And the question is...
Raja Soosai 11-May-13 7:00am
   
You want to improve your query performance?
arunrv 11-May-13 7:51am
   
May be server is having more data than your local system so it is taking a long time

1 solution

Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

There are way too many things that could be the issue. Try troubleshooting these and see if problem is there:
Are running on a slow connection?
Is it a server in your local network?
Are there any other heavy queries being run on the server?
Try pinging the sever and see what are response times.
Is remote server busy?
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web04 | 2.8.160204.4 | Last Updated 12 May 2013
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100