查询在SQL Server（远程）上执行缓慢 [英] Query is executing slow on SQL Server (remote)

问题描述

我的查询在一台服务器上运行速度非常慢但在另一台服务器上运行正常。系统设置相同（硬件配置，操作系统，Sql Server设置......）。这不是关于查询，我测试了不同的查询，仍然得到相同的结果。有人知道发生了什么吗？

My query is running very very slow on one server but works fine on another. System settings are identical(hardware configuration, OS , Sql Server settings ...). It is not about query, I tested different queries and still got the same results. Anyone know what is going on ?

推荐答案

你必须分析查询执行计划到意识到问题所在。



分析查询



干杯，

JAFC

Hi,

You must analyze the query execution plan to realize where the problem are.

Analyzing a Query

Cheers,
JAFC

你好Angela



我建议你检查数据库索引的性能（填充因子，碎片...检查索引键列和包含的列），windows log找到任何与磁盘有关的错误导致你的麻烦... RAM，主板，RAID状态。



比较服务器硬盘的rpm与所涉及的较大表的大小您的查询。



当您在本地或远程运行时（例如，通过使用ADO的程序），是否会出现查询问题？

它使用链接服务器或openquery到另一台服务器？



最好的问候。

Hello Angela

I suggest you to check performance on the Database Indexes (fill factor, fragmentation... check index key columns and included columns), windows log to find any error related to disk that is causing you trouble... RAM, motherboard, RAID status.

Compare rpm of your servers hard drives vs size of the larger table involved on your query.

Does the query problem occur when you run it locally or remotely (through a program using ADO for example)?
Does it use linked server or openquery to another server?

Best regards.

有任何错误吗？尝试重新安装SQL Server。您可能还想检查您的硬盘。第二台服务器上是否还有其他进程在运行？您是否尝试过运行性能计数器并检查具体导致速度减慢的原因？



检查

http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread / d5ba772f-9683-4780-8efa-038cb8d75531 / [ ^ ]

Any errors ? Try to reinstall SQL Server. You may also want to check your hard drive. Are there any other processes running on the second server? Have you tried running performance counters and checking what specifically is causing the slowdown?

Check
http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/d5ba772f-9683-4780-8efa-038cb8d75531/[^]

这篇关于查询在SQL Server（远程）上执行缓慢的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！