sqlserver2014补丁速度慢,SQL Server 2014和2016优化

Hi all,

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 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 node alwayson with sql server 2016, vm's size 8core(1 socket) 28gb ram. Now max degree of parallelism is set to 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 node alwayson with sql server 2016, vm's size 4 core (1 socket) 14gb ram. Now max degree of parallelism is set to 0

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

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

Thanks for your help

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