Click here to Skip to main content
11,711,750 members (69,283 online)
Rate this: bad
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 17:51pm
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
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?

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

  Print Answers RSS
0 CHill60 280
1 Sergey Alexandrovich Kryukov 264
2 Andy Lanng 160
3 OriginalGriff 130
4 Richard MacCutchan 130
0 CHill60 280
1 Sergey Alexandrovich Kryukov 125
2 Andy Lanng 120
3 Abhinav S 95
4 Maciej Los 95

Advertise | Privacy | Mobile
Web04 | 2.8.150819.1 | Last Updated 12 May 2013
Copyright © CodeProject, 1999-2015
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