Set MAXDOP to 1/4 of the number of available CPUs in OLTP and half those in Data Warehouse systems. Do not exceed the number of CPUs in the NUMA node.


No responses yet

Bir cevap yazın

E-posta hesabınız yayımlanmayacak.

Get Application and Check Your SQL Server. You can call us to ask for further questions.