March 4, 2011 at 7:51 am
Hi All,
I've been having a bit of an argument with a project manager this afternoon.
He wants to put SQL Server 2008 Standard Edition onto a (VMWare) Virtual Server with 8 virtual CPUs.
I think he's getting confused between the licensing arrangements and product edition features.
He's convinced that we can use Standard Edition and use the 8 virtual CPUs because the underlying hardware is a 4 x Quad core CPU server so it's actually only using 2 real CPUs (2 x 4 cores).
I'm arguing that SQL doesn't give a monkeys whether the CPUs are real or virtual, the way the virtual CPUs are presented to SQL makes them look like 8 real CPUs and therefore Enterprise Edition will be required otherwise it will only use 4 of the 8 CPUs.
Who's right?
March 4, 2011 at 9:10 am
He is almost right, but wrong because of VM.
Non-VM, it is licensed by physical CPU socket and can use all logical CPUs which are utilizing no more than 4 physical processor sockets.
However, in a virtual environment, the licensing doesn't care if the CPU is physical or logical - so 4 is the max for standard edition. R2 has some enterprise changes, but not for standard that I saw. http://www.microsoft.com/sqlserver/2008/en/us/licensing-faq.aspx
Jim
Jim Murphy
http://www.sqlwatchmen.com
@SQLMurph
June 8, 2014 at 12:41 am
On vmware vsphere v5 i've set virtual socket =1 and virtual cores per socket=8. In this way sql2008 std ed. use all of 8 cores available.
The OS is a win 2008 R2 enterprise edition
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply