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.
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
Horrible behavior of sqlserver 2012 numa mode selection algorithm, thanks to Andrea we could work around it