Click here to Skip to main content
15,799,019 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
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
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

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?
Share this answer

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

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900