Click here to Skip to main content
Rate this: bad
good
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 at 11-May-13 4:25am
   
And the question is...
Raja Soosai at 11-May-13 7:00am
   
You want to improve your query performance?
arunrv at 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
0 OriginalGriff 304
1 Sergey Alexandrovich Kryukov 255
2 Shweta N Mishra 216
3 Maciej Los 210
4 PIEBALDconsult 184
0 OriginalGriff 7,630
1 Sergey Alexandrovich Kryukov 7,022
2 DamithSL 5,586
3 Manas Bhardwaj 4,946
4 Maciej Los 4,525


Advertise | Privacy | Mobile
Web01 | 2.8.1411023.1 | Last Updated 12 May 2013
Copyright © CodeProject, 1999-2014
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