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.

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