In this post I’ll examine how installing SQL Server from the incorrect ISO can lead to CPU throttling. If you aren’t careful, you could be paying for SQL Server cores that you can’t even use!
Sometimes things just don’t make sense.
One of our production servers has 4×8 (4 sockets, 8 core) processors with hyper threading enabled. This results in 32 physical cores or 64 logical cores. Therefore, this particular server should have 4 NUMA nodes available.