Operational Defect Database
BugZero found this defect 340 days ago.
Data sources
All data on this page is proprietary to BugZero® or gathered from public sources
Microsoft SQL Server | 2410400
SOS_BLOCKALLOCPARTIALLIST spinlock contention and elevated CPU utilization occur on large-memory machines. DBCC DROPCLEANBUFFERS provides temporary mitigation for this issue when encountered. This occurs when multiple threads concurrently attempt to gain access to a spinlock-protected list used by the SQL operating system for memory management purposes. The following trace flags are required to enable the fix: - TF 8142 partitions list by count of CPU, up to 64 partitions - TF 8145 modifies the partitioning to be count of soft-NUMA nodes These trace flags must be applied as startup parameters to take effect. If SOS_BLOCKALLOCPARTIALLIST spinlock contention is encountered and DBCC DROPCLEANBUFFERS provides temporary mitigation, it's recommended to apply this fix first with both trace flags, and remove Trace Flag 8145 only if symptoms persist.
Last update date:
6/15/2023
Affected products:
SQL Server 2019 on Linux
SQL Server 2019 on Windows
Affected releases:
build lower than 15.0.4316.3
Fixed releases:
15.0.4316.3
Description:
SOS_BLOCKALLOCPARTIALLIST spinlock contention and elevated CPU utilization occur on large-memory machines. DBCC DROPCLEANBUFFERS provides temporary mitigation for this issue when encountered. This occurs when multiple threads concurrently attempt to gain access to a spinlock-protected list used by the SQL operating system for memory management purposes. The following trace flags are required to enable the fix: - TF 8142 partitions list by count of CPU, up to 64 partitions - TF 8145 modifies the partitioning to be count of soft-NUMA nodes These trace flags must be applied as startup parameters to take effect. If SOS_BLOCKALLOCPARTIALLIST spinlock contention is encountered and DBCC DROPCLEANBUFFERS provides temporary mitigation, it's recommended to apply this fix first with both trace flags, and remove Trace Flag 8145 only if symptoms persist.
