Modern Hardware with 64 CPUs

Published On: 2019-02-01By:

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 aspect of SQL Server that can take advantage of more than 64 CPUs is the database engine itself.  If you plan on using that many CPU’s for things like Integration Services or Analysis services, you might want to think again.

Before implementing new architecture, make sure to review all of the architecture documentation.  Otherwise you might be wasting resources on things that can’t even use them.

© 2019, John Morehouse. All rights reserved.


Contact the Author | Contact DCAC

Video

Globally Recognized Expertise

As Microsoft MVP’s and Partners as well as VMware experts, we are summoned by companies all over the world to fine-tune and problem-solve the most difficult architecture, infrastructure and network challenges.

And sometimes we’re asked to share what we did, at events like Microsoft’s PASS Summit 2015.

Awards & Certifications

Microsoft Partner       Insights Sccess Award    Technology Headlines Award    Golden Bridge Gold Award    CIO Review Top 20 Azure Solutions Providers    VMWare Partner
Microsoft Certified Master    Microsoft MVP
Share via