October 3, 2014 at 10:53 am
Howdy - -
We're about to buy a new server which will be running SQL 2014 Standard.
Under consideration are two machines: one with 16 cores (3.3 GHz), and one with 24 cores (2.7 GHz).
We frequently run fairly complex queries and processes that have all eight of our (current) cores banging.
We are wondering what (if any) is the common wisdom on this. Would we typically be better of with 16 cores, rather than 24, but with the superior clock speed---or vice versa ?
Thanks.
October 3, 2014 at 10:58 am
From a financial standpoint I'd say go with clock speed because SQL Server is licensed per core, so you're going to save like $50,000 by going with 16 vs 24. The other thing you have to keep in mind that if MAXDOP is left at 0 SQL Server will use all the cores for anything is parallelizes and often-times with many cores this is more of a performance problem than a help.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
October 3, 2014 at 11:01 am
Actually, we're not going to be using per-core licensing. We will be way ahead of the game with CAL licensing.
October 3, 2014 at 12:08 pm
Jack - -
The questions still stands, since we can set MAXDOP to 8, and have six users running hairy queries with eight schedulers each.
- - Herb
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply