Sample Header Ad - 728x90

CPU clock speed versus CPU core count - higher GHz, or more cores for SQL Server?

36 votes
4 answers
30302 views
We are beginning to provision a set of physical servers for a virtual cluster of SQL Server 2016 nodes within VMware. We will be utilizing Enterprise Edition licenses. We plan on setting up 6 nodes, but there is a bit of a debate on what the ideal way to provision the physical servers with regards to CPU clock speed versus CPU core count. I know this is largely dependent on transaction volume and number of databases stored among other software-specific factors, but is there a general rule of thumb that is advised? For instance, is a dual 8-core, 3.2 GHz physical server (16 cores) more preferential to a dual 16-core, 2.6 GHz server (32 cores)? Has anyone come across a white paper that further delves into this type of topic?
Asked by PicoDeGallo (1554 rep)
Apr 4, 2017, 07:07 PM
Last activity: May 10, 2022, 12:15 PM