Forum Discussion
SQL Server - SOS_SCHEDULER_YIELD and Unbalanced NUMA Node Usage
Hi everyone, we've faced an unusual behavior on our SQL Server and would like to understand the cause and how to manage it properly. Our DB Server is a physical server with 64 cores (128 logical CP...
I would first make sure that your MAXDOP is not set to 0 and your Cost Threshold for Parallelism is set to a reasonable high number so you're not using multiple parallel processes unnecessarily. Setting these is more of an art form and not an exact science since it's affected by your hardware config, data structures, indexing, statistics etc. etc. The settings are dynamic so if you make a change that affects things adversely you can set it back quickly.
Here's an MS article that may help: https://learn.microsoft.com/en-us/answers/questions/2103761/need-recommendations-for-maxdop-and-cost-threshold