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...
When is NUMA node assigned? > At connection time
Metric and monitoring:
sys.dm_os_schedulers > View per-scheduler runnable_tasks_count, current_tasks_count, and cpu_id
sys.dm_os_nodes > Get NUMA node details
What SQL Server version and edition are you on, as there are some limitations in editions/versions.
https://learn.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2019?view=sql-server-ver15&preserve-view=true#Cross-BoxScaleLimits
How is the MAXDOP setting configured?
https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/configure-the-max-degree-of-parallelism-server-configuration-option?view=sql-server-ver16#recommendations