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
Last activity: May 10, 2022, 12:15 PM