I am a small business owner. My company does data analytics. No OLTP. Mostly running queries against a large DB. There will be writes as well because the DB has to be updated each day with new data. I need a new computer to host SQL Server 2019. I am thinking of getting Xeon Gold 5222 but there are so many choices (CPU, cores, clock speed etc) it is really hard to make a decision.
Is there a tool available that compares the different Xeon processors to determine performance? Like a score so I can compare different options.
What is more important? clock speed? number of cores?
There are quite a few websites that do this but I don't know how reliable they are. Hopefully someone can point me in the right direction.
If you use Intel's https://ark.intel.com site, you can flag a number of processors and compare them. For example, here is a link to a comparison of a few of the (many) Cascade Lake Xeon Gold processors: https://ark.intel.com/content/www/us/en/ark/compare.html?productIds=199343,199342,198655,198652,2027...
Importance? Both, of course! ;^)
Hope this helps,
Thanks for the reply.
What I struggle with is deciding which is better. For example, if compare Intel Xeon Gold 5222 vs Intel Xeon W-2275. 5222 is 3.8 Ghz/4C but W-2275 is 3.3Ghz/14C. Which is a better performing CPU?
Any guidance you can offer is much appreciated.
Thank you @n_scott_pearson. I have been using that link. I am a bit surprised that some of the Xeon W series have way higher scores than the non W series. I am a rookie so I am sure I am overlooking something. Here is an example:
Is the main difference between 5222 and the W series that 5222 is scalable whereas W series are not? If yes, what exactly does it mean to be scalable?
It seems like from a performance perspective, the W series are way better than 5222. Is that accurate?
Thank you so much for your help.
Sorry, I am a desktop guy and don't consider myself competent enough to attempt to answer that (I embarrass myself enough as it is).
If you want to read further, Intel's documentation starts here: https://www.intel.com/content/www/us/en/products/details/processors/xeon/scalable.html