SQL Server 2014和2016优化 [英] SQL Server 2014 and 2016 Optimization

问题描述

大家好，

是的，我们在天蓝色的新数据库服务器上为新应用程序迁移数据库后出现性能问题。问题是最大并行度设置为0，现在我们把8.你能帮我计算这个参数的最佳设置吗？这里我们的vm是在
azure：

yestarday we have a performance problem after migrate a db for a new application on a new db server on azure. The problem was max degree of parallelism set to 0, now we put 8. Can you help me to calculate best setting for this parameters? Here our vm's on azure:

- 2节点alwayson与sql server 2016，vm的大小是32core（1个插槽）和128gb ram。为了解决问题，我们在最大并行度上加上8并且情况正常回归。

- 2 node alwayson with sql server 2016, vm's size are 32core(1 socket) and 128gb ram. To remediate problem we put 8 on both as max degree of parallelism and the situation came back normally.

- 2节点alwayson与sql server 2016，vm的大小8核（1个插槽）28gb ram 。现在最大并行度设置为0

- 2 node alwayson with sql server 2016, vm's size 8core(1 socket) 28gb ram. Now max degree of parallelism is set to 0

- 2节点alwayson与sql server 2014，vm的大小为4核心（1个插槽）14gb ram。  现在最大并行度设置为0

- 2 node alwayson with sql server 2014, vm's size 4 core (1 socket) 14gb ram. Now max degree of parallelism is set to 0

- 2个节点alwayson with sn server 2016，vm的size 4 core（1 socket）14gb ram 。  现在最大并行度设置为0

- 2 node alwayson with sql server 2016, vm's size 4 core (1 socket) 14gb ram. Now max degree of parallelism is set to 0

我在谷歌上建立，最好也增加  并行度的成本门槛。现在在我们的dbs服务器上是5。

i founded on google that is better to increse also Cost Threshold For Parallelism. Now on our dbs servers is 5.

我也是红色的临时数据库。什么是最佳做法？现在我们的数据库服务器上只有2个tempdb。

I red also for temp db. What are the best practice? Now we have only 2 tempdb on our db server's.

感谢您的帮助

推荐答案

您是否遇到实际问题？ 除非您遇到特定问题，否则通常没有理由更改这些设置。

Are you having an actual problem?  There normally is no reason to change those settings unless you are having a specific problem.

这篇关于SQL Server 2014和2016优化的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！