SQL Server core usage

Question

SQL Server core usage

Viewing 5 posts - 16 through 19 (of 19 total)

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

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

You really should sort the VM configuration out.

You can 'just' upgrade to Enterprise edition, but 16 cores of Enterprise licenses will be quite a bit more expensive than your current BI edition (and I don't think that BI to Enterprise is a supported upgrade, you'd probably need to uninstall/reinstall)

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

richardmgreen1 SSChampion Points: 10353 More actions · Answer 2

Thanks Gail

I'll get onto our server team and ask them to sort the sockets/cores so we can use the lot.

richardmgreen1 SSChampion Points: 10353 More actions · Answer 3

Another question (that's vaguely related to this...)

Let's say we have a virtual server that's got 64 cores in total and we want to install 4 instances of SQL Server 2012 (Business Intelligence edition for all 4).

Can we restrict the number of cores per instance using "Processor Affinity"?
The idea is to have a server with multiple instances but the maximum number of cores available to each instance (so 16 cores per instance in this case).

My thought is that restricting the number of cores per instance will allow each instance to use the maximum number of cores with none being idle.

Is my reasoning sound and, if so, is Processor Affinity the place to make the restrictions?

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 4

tbh, I would recommend rather have 4 virtual servers, each with 16 cores and 1 instance of SQL Server 2012. You get far better seperation of resources (like memory) doing it that way, plus it should be easier to manage, upgrade, patch, etc.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

richardmgreen1 SSChampion Points: 10353 More actions · Answer 5

richardmgreen1

SSChampion

Points: 10353

April 27, 2017 at 9:12 am

#1940229

Thanks Gail