Update: Microsoft will be moving away from UserVoice sites on a product-by-product basis throughout the 2021 calendar year. We will leverage 1st party solutions for customer feedback. Learn more here.

Do you have a comment or suggestion to improve SQL Server? We’d love to hear it!

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.

29 votes

Andrea Caldarone shared this idea · September 27, 2019 · Flag idea as inappropriate… · Admin →

4 comments

An error occurred while saving the comment

Anonymous commented · February 24, 2020 13:10 · Flag as inappropriate

Very good point! thanks for sharing

Submitting...
Stefano Cotignoli commented · October 07, 2019 07:42 · Flag as inappropriate

We hope you change this behavior, NUMA nodes imbalance causes troubles to ours and on SAP applications. Thanks Andrea for the suggestion

Submitting...
Ugo Conte commented · September 30, 2019 11:14 · Flag as inappropriate

Great suggestion, thanks Andrea

Submitting...
Anonymous commented · September 28, 2019 00:47 · Flag as inappropriate

Horrible behavior of sqlserver 2012 numa mode selection algorithm, thanks to Andrea we could work around it

Submitting...

SQL Server: Suggestions

Searching…

No results.
Clear search results

Give feedback
- (General Feedback) 7,055 ideas
- Additional Services 326 ideas
- Analytics Platform System 20 ideas
- API Apps 0 ideas
- API Management 654 ideas
- Automation 532 ideas
- Azure Active Directory 5,269 ideas
- Azure Active Directory Application Requests 286 ideas
- Azure Advisor 35 ideas
- Azure Analysis Services 189 ideas
- Azure API for FHIR 14 ideas
- Azure App Configuration 49 ideas
- Azure Arc 27 ideas
- Azure Automanage 11 ideas
- Azure Backup 602 ideas
- Azure Blockchain Service 12 ideas
- Azure Bot Service 35 ideas
- Azure Certified Device 16 ideas
- Azure Cloud Shell 368 ideas
- Azure Cognitive Services 67 ideas
- Azure Communication Services 16 ideas
- Azure Confidential Compute 2 ideas
- Azure Container Instances 168 ideas
- Azure Container Registry 101 ideas
- Azure Cosmos DB 290 ideas
- Azure CycleCloud 6 ideas
- Azure Data Explorer 221 ideas
- Azure Data Share 12 ideas
- Azure Database for MariaDB 18 ideas
- Azure Database for MySQL 76 ideas
- Azure Database for PostgreSQL 159 ideas
- Azure Database Migration Service 79 ideas
- Azure Databricks 293 ideas
- Azure Dev Spaces 11 ideas
- Azure Digital Twins 20 ideas
- Azure Event Grid 67 ideas
- Azure FarmBeats 14 ideas
- Azure Functions 242 ideas
- Azure FXT Edge Filer 0 ideas
- Azure Governance 205 ideas
- Azure HPC Cache 0 ideas
- Azure IoT (Hub, DPS, SDKs) 335 ideas
- Azure IoT Central 159 ideas
- Azure IoT Edge 95 ideas
- Azure IoT Security 0 ideas
- Azure IoT Solution Accelerators 45 ideas
- Azure Key Vault 178 ideas
- Azure Kinect DK 69 ideas
- Azure Kubernetes Service (AKS) 310 ideas
- Azure Lighthouse 32 ideas
- Azure Management Groups 24 ideas
- Azure Maps 77 ideas
- Azure Marketplace 462 ideas
- Azure Media Services 260 ideas
- Azure Migrate 76 ideas
- Azure mobile app 366 ideas
- Azure Monitor 265 ideas
- Azure Monitor- Alert Management 162 ideas
- Azure Monitor-Application Insights 810 ideas
- Azure Monitor-Log Analytics 1,010 ideas
- Azure NetApp Files (ANF) 33 ideas
- Azure Object Anchors 0 ideas
- Azure Pack 298 ideas
- Azure Portal 2,228 ideas
- Azure Purview 183 ideas
- Azure Quantum 0 ideas
- Azure Red Hat OpenShift 13 ideas
- Azure Remote Rendering 10 ideas
- Azure Reservations 187 ideas
- Azure Resource Manager 564 ideas
- Azure Search 300 ideas
- Azure Security Center 327 ideas
- Azure Sentinel 118 ideas
- Azure Service Health 46 ideas
- Azure SignalR Service 17 ideas
- Azure Spatial Anchors 31 ideas
- Azure Sphere 81 ideas
- Azure Spring Cloud 3 ideas
- Azure Stack HCI 8 ideas
- Azure Stack Hub 204 ideas
- Azure Synapse Analytics 494 ideas
- Azure TCO Calculator 30 ideas
- Azure Time Series Insights 33 ideas
- Batch 39 ideas
- Batch AI 10 ideas
- Biztalk Services 14 ideas
- Blockchain 55 ideas
- Cache 43 ideas
- Change Tracking 14 ideas
- Cloud Services (Web and Worker Role) 274 ideas
- Cost Management 359 ideas
- Cross region move for Azure resources 11 ideas
- Customer Insights 13 ideas
- Customer Lockbox for Microsoft Azure 1 idea
- Data Catalog 180 ideas
- Data Factory 1,295 ideas
- Data Lake 355 ideas
- Data Science VM 24 ideas
- Diagnostics and Monitoring 204 ideas
- Event Hubs 43 ideas
- Global Infrastructure 44 ideas
- HDInsight 137 ideas
- Lab Services 386 ideas
- Logic Apps 1,896 ideas
- Machine Learning 240 ideas
- Mobile Engagement 19 ideas
- Networking 1,481 ideas
- Notification Hubs 37 ideas
- Project Bonsai 31 ideas
- Scheduler 43 ideas
- Scripting and Command Line Tools 103 ideas
- SDK and Tools 150 ideas
- Security and Compliance 106 ideas
- Service Bus 209 ideas
- Service Fabric 304 ideas
- Signup and Billing 1,800 ideas
- Site Recovery 299 ideas
- SQL Data Sync 68 ideas
- SQL Database 896 ideas
- SQL Managed Instance 154 ideas
- SQL Server 10,777 ideas
- SQL Server - Big Data Clusters 48 ideas
- Storage 1,040 ideas
- StorSimple 26 ideas
- Stream Analytics 271 ideas
- Support Feedback 276 ideas
- System Center Data Protection Manager 152 ideas
- Update Management 186 ideas
- Virtual Machines 1,712 ideas
- Web Apps 668 ideas
Microsoft Azure