What Happens to Pages in the Buffer Pool when your Availablity Group Fails Over?
Recently at SQL Saturday Philadelphia, we started discussing failover as it relates to mirroring and Always On Availability Groups. Specifically, we were wondering what would happen if you had a relatively busy readable secondary replica (which would have a lot of pages in the buffer pool on the secondary instance) and if those pages would […]
How is performance impacted by having too many NUMA nodes?
Having too many NUMA nodes can lead to some really strange CPU behavior. What you’ll probably see is that the CPU workload of the machine isn’t evenly balanced across the CPUs. If for example you have 32 cores on the VM, and you have 16 NUMA nodes, with two cores per NUMA node you’ll probably…
The post How is performance impacted by having too many NUMA nodes? appeared first on SQL Server with Mr. Denny.