sqlrus.com
Modern Hardware with 64 CPUs | John Morehouse
In today's world, more often then not you might run into systems that have large beefy hardware. Hundreds of gigabytes of memory, ultra fast solid state disks and many CPUs to push your workloads. These types of systems are no longer unicorns in the wild but are becoming more and more prevalent. Further more, in today's world, it's also very likely that you will see the different facets of SQL Server, such as Integration Services, Reporting Services, or Analysis Services split out to better manage hardware resources. These facets of SQL Server all compete for hardware resources against the database engine so having them reside on individual servers help to ensure better performance for each of them. However, did you know that not everything related to SQL Server can utilize more than 64 CPUs? It's true, look for yourself. The chart shown below, taken from this Microsoft article, breaks it down as to which component can use more than 64 CPUs. According to that document, the only