Skip to content

NUMA

Wait stats and Sub-NUMA clustering 

During a healthcheck at a client’s site, we collected performance data from a SQL Server 2019 Enterprise instance hosting a BI / data warehouse workload. Two lines in the wait statistics report immediately caught the eye: hundreds of hours of parallelism waits accumulated in only 11 days of uptime.  Here are the questions that arise  The waits themselves were not… 

SQL Server: Automatic Soft-NUMA and uneven CPU load

SQL Server has CPU limitations depending on the Edition. If your VM is not configured properly you can reach these limits very easily. In a previous post, I described the effect VM misconfigurations can have on performance because not all available cores are used as expected. See: SQL Server CPU limitation for Express and Standard Edition In this article I…