SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Multiple SQL Standard Instances on 4 Processor/32-core Server


Multiple SQL Standard Instances on 4 Processor/32-core Server

Author
Message
tharwood 94756
tharwood 94756
Forum Newbie
Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)

Group: General Forum Members
Points: 5 Visits: 4
We have a large 4 processor/32-core server with 192GB of memory available in the data center and over twenty small SQL Standard databases to consolidate. They are a mix of SQL 2012 and 2008 R2 for 3rd-party apps.

Is there any issue with simply installing two instances of SQL Standard on the server - one for 2012 and one for 2008 R2 ? Each instance will use up to 64GB out of the 192GB and 16 cores. If we did this with Enterprise, the licensing would be a fortune and the Enterprise features are not needed.
HowardW
HowardW
SSCrazy
SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)

Group: General Forum Members
Points: 2239 Visits: 9892
Assuming you're talking about running on physical infrastructure on the same host, I'm fairly sure you'd need to license all of the physical cores on the box for Enterprise Edition regardless.

Processor affinity has nothing to do with licensing requirements. You'd need to virtualise the environment and assign virtual cores to two different hosts in order to license them individually.
HowardW
HowardW
SSCrazy
SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)

Group: General Forum Members
Points: 2239 Visits: 9892
Sorry, re-reading, I think I slightly misunderstood. You may be able to fully license the server for SQL 2012 Standard Edition (32 cores) and run both 2012 Standard Edition and 2008 R2 Standard Edition on the same box.

You just can't mix Standard and Enterprise Edition on the same host without fully licensing for Enterprise Edition.
tharwood 94756
tharwood 94756
Forum Newbie
Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)

Group: General Forum Members
Points: 5 Visits: 4
Thanks. If SQL Standard is installed on a 32-core server, how exactly does SQL Standard limit itself to 16 cores ? I am wondering if there would be any performance or other issues in running two instances of Standard side by side considering they are doing something to limit themselves to a certain number of cores.
HowardW
HowardW
SSCrazy
SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)

Group: General Forum Members
Points: 2239 Visits: 9892
tharwood 94756 (7/2/2013)
Thanks. If SQL Standard is installed on a 32-core server, how exactly does SQL Standard limit itself to 16 cores ? I am wondering if there would be any performance or other issues in running two instances of Standard side by side considering they are doing something to limit themselves to a certain number of cores.



SQL Standard Edition will only ever use 16 cores per instance (and it does physically limit it), but you can run as many instances as you want, as long as you've licensed them.


You can set processor affinity for each instance to a different 16 cores each (e.g. 0-15 for Instance1 and 16-31 for Instance2), so they're not contending for the same CPU threads. AFAIK, there are no particular performance issues with doing this, assuming all your shared resources are not in contention (Disk, Network etc.).
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search