I just learned some NUMA related knowledge and I want to know:
1. Is NUMA a bad thing for SQL Server? I ask because this Microsoft employee said that:
> Basically fewer nodes is better, but there's a limit to how many cores and how much RAM you can put on a single NUMA node.
It seems that we use NUMA on SQL Server servers solely because we want huge RAM and more processors, and the hardware vendor created these NUMA nodes for us just because the server is more performant with NUMA architecture. Is this true?
2. Since I don't have a computer with multiple hardware CPU, I can't test NUMA architecture. Is possible to test it on Azure or AWS? What's the approximate cost of using it for 24 hours?
Asked by Fajela Tajkiya
(1239 rep)
Sep 7, 2022, 02:05 PM
Last activity: Sep 7, 2022, 02:56 PM
Last activity: Sep 7, 2022, 02:56 PM