Category: NUMA

SQL Server Availability Impact on BigBox – Non yielding Resource Monitor after changing NUMA-NODE Processor Affinity causes instance to failover

Change NUMA-Node Processor Affinity is an online operation that can be done without causing downtime but I have experienced that it can lead to bring an instance offline if the resource monitor takes long time to free memory and keeps generating Mini-Dumps, at #51 it will bring the instance offline. Started to have Non yielding

Continue reading