Manual soft-NUMA configuration can result in txlog writer contention - by Lonny Niederstadt

Status : 

 


4
0
Sign in
to vote
ID 3143898 Comments
Status Active Workarounds
Type Bug Repros 0
Opened 11/9/2017 12:03:45 AM
Access Restriction Public

Description

Documentation states that there will be one txlog writer on NUMA node 0 per NUMA node, up to 4 txlog writers.
However, manually configuring soft-NUMA (eg to ensure optimal distribution of a set of DOP 1 queries started in a burst) can result in up to 4 txlog writers on the same logical or virtual processor.  This configuration has the additional cost of distributing/coordinating txlog writer work across up to 4 threads while not receiving any of the benefits of spreading the txlog writers over multiple cores.
Sign in to post a comment.