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 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy