SQL Server performance issue after an upgrade

Question

SQL Server performance issue after an upgrade

Kanishka Basak

Old Hand

Points: 320
More actions
December 16, 2019 at 12:00 am

#3706071

Comments posted to this topic are about the item SQL Server performance issue after an upgrade

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

D_ SSC Enthusiast Points: 190 More actions · Answer 1

Going from CAL to Core licensing for a server this size must have been hugely expensive though... care to share how that went?

sterling3721 SSChasing Mays Points: 653 More actions · Answer 2

true, 36 cores x $7,000 = $252,000, a quarter million for one node, plus SA, about 25% of licensing, or $63,000 per year.

D_ SSC Enthusiast Points: 190 More actions · Answer 3

36 CPUs, if I'm reading it correctly... and that CPU has 18 cores...

sterling3721 SSChasing Mays Points: 653 More actions · Answer 4

this model, Proliant DL360 Gen10, supports 2 processors, with up to 28 cores per processor, so, 36 is the # of cores, before hyperthreading.

D_ SSC Enthusiast Points: 190 More actions · Answer 5

Good to know... still big bucks in SQL licensing... though some companies might not think so, I guess.

Kanishka Basak Old Hand Points: 320 More actions · Answer 6

yes, the change was quite a hard one. The thing that helped was, this being our beta partner, a lot of investments or budget allocation was already made,so it somehow fell in that equation.

The fortunate part though,was, we had a only 2 clients the then, who were with more than 20 cores,so even if we were hit, for future aspects, this saved us!