AMD Ryzen Machines的查询速度慢 [英] Slow Query Performance on AMD Ryzen Machines

问题描述

我们在3个SQL Server版本和几代Intel / AMD CPU的混合开发工作站，测试服务器和生产服务器上运行SQL Server。我们在Intel Xeon E5-2650v4上有10.50SP3，在Intel Xeon E5-5620上有11.0SP4，在AMD Ryzen 2700上有14.0RTM。

查询在20左右执行在Intel机器上运行40秒，但在AMD机器上运行时间接近10分钟。 

运行查询时，所有机器上的CPU峰值达到100％，但英特尔完成了在极短的时间内查询，AMD在整个10分钟内保持100％的CPU。在AMD计算机上运行时，资源监视器
的内存使用率为60％，磁盘使用率较低。 

我不知道如何获得更多有关此问题的信息，但我可以在不同的计算机上包含查询的查询执行计划，如果这有用的话。 

解决方案

Hi Anarian，

正如你所说，你在三个不同的开发工作站上有SQL Server 2008 R2，SQL Server 2012，SQL Server 2017，我担心我可能无法告诉你低性能
的实际原因，因为许多环境因素也许你可以做一个测试。

 

在三个环境因素中，安装具有相同版本的SQL Server 2017。如果性能结果不相似，则可能的一个问题是：b b   该问题可能与 不同代的Intel / AMD CPU。

 

< p style ="margin：0in; font-family：Calibri; font-size：11.0pt">如果它们仍有不同的性能结果，请检查SQL Server的版本。

< p style ="margin：0in; font-family：Calibri; font-size：11.0pt">计算容量对每个SQL Server版本的单个实例有不同的限制。有关 的详细信息
SQL Server 2017的版本和支持的功能，请参考它。

 

所以请检查版本和&NBSP;
检查配置管理器中的可用CPU。有一个类似的问题，请参考它。

https ：//www.mssqltips.com/sqlservertip/4801/sql-server-does-not-use-all-assigned-cpus-on-vm/

 

顺便提一下，问题可能是
  与 不同的
相关 CPU  ，请在相应的论坛中发布此问题。

英特尔

ADM

 

希望它可以帮到你。

 

最好的问候，

Rachel

We run SQL Server on a mix of development workstations, test servers, and production servers in 3 SQL Server versions and generations of Intel/AMD CPUs. We have 10.50SP3 on Intel Xeon E5-2650v4, 11.0SP4 on Intel Xeon E5-5620, and 14.0RTM on AMD Ryzen 2700.

The query executes in around 20-40 seconds on the Intel machines, but takes close to 10 minutes on the AMD machines. 

The CPU spikes to 100% on all machines when running the query, but the Intel completes the query in significantly less time, and the AMD stays at 100% CPU for the entire 10 minutes. Memory usage sits at 60%, and disk usage is low in the Resource Monitor while it's running on the AMD machine. 

I'm not sure how to get more information on this issue, but I can include the query execution plans for the query on the different machines if that would help. 

解决方案

Hi Anarian,

As you said that you has SQL Server 2008 R2,SQL Server 2012 ,SQL Server 2017 on three different development workstations, I am afraid that I might be unable to tell you actual reason for low performance because of many environment factors. Maybe you can do a test .

 

In your three environment factors, install SQL Server 2017 which has the same version. If the results of performance are not the similar , one possibility  is that the issue may be related to different generations of Intel/AMD CPUs.

 

If they still have different result of the performance, please check the edition of your SQL Server.

The compute capacity has different limits for a single instance of each edition of SQL Server. For more details about  Editions and supported features of SQL Server 2017, please refer to it.

 

So please check the edition and  check available CPUs from configuration manager. There is a similar issue, please refer to it. https://www.mssqltips.com/sqlservertip/4801/sql-server-does-not-use-all-assigned-cpus-on-vm/

 

By the way, one possibility  is that the issue may be related to different CPUs , and please post this issue in the corresponding forum.

Intel

ADM

 

Hope it can help you .

 

Best Regards,

Rachel

这篇关于AMD Ryzen Machines的查询速度慢的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！