SQL语句在具有相同执行计划的远程服务器上花费太长时间 [英] SQL statement taking too long on remote server with same execution plan

问题描述

我有一个本地和远程服务器，我在两者上执行相同的查询，但在远程服务器上执行需要更长的时间。



我检查了查询计划，它们在两台服务器上是相同的

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

推荐答案

有办法太多可能成为问题的事情。尝试对这些进行故障排除，看看是否存在问题：

是否在慢速连接上运行？

它是您本地网络中的服务器吗？

服务器上是否还有其他重要查询？

尝试ping服务器和看看什么是响应时间。

远程服务器忙吗？

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?

这篇关于SQL语句在具有相同执行计划的远程服务器上花费太长时间的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！