SQL Server new algorithm to chose NUMA node to bind connection to
When SQL Server is deployed on NUMA hardware or virtual hardware, it binds connections to NUMA nodes in a round robin fashion. This is not correct and often lead to NUMA node imbalance. I suggest to create an algorithm which takes into account the nodes load and choses the least loaded.
28
votes
Andrea Caldarone
shared this idea
4 comments
-
Anonymous
commented
Very good point! thanks for sharing
-
Stefano Cotignoli
commented
We hope you change this behavior, NUMA nodes imbalance causes troubles to ours and on SAP applications. Thanks Andrea for the suggestion
-
Ugo Conte
commented
Great suggestion, thanks Andrea
-
Anonymous
commented
Horrible behavior of sqlserver 2012 numa mode selection algorithm, thanks to Andrea we could work around it