Licensing Virtual Machines under the per processor Running SQL Server Enterprise edition

  • Hi,

    We have 2 virtual servers for sql server and the underlying Physical server has 16 cpus.

    We have SQL server 2008 r2 EE. Here how the licensing works?

  • SQL is licensed per Physical CPU. How many physical CPU's do you have?

    Also, in order to be able to REALLY take advantage of virtualization, you might want to purchase Windows Datacenter. It is also licensed by Physical CPU.

    For instance, we have a 2 physical CPU HP DL385 that has 12 cores each (total 24 core count) and we licensed the ESXi host for Windows R2 Datacenter for both physical CPU's and licensed for SQL 2008 R2 Enterprise Edition for both physical CPU's. Doing so "Entitles" you to run unlimitted MS Virtual Servers and unlimited MS SQL Servers.

    Someone correct me if i'm wrong.

  • SQL is licensed per Physical CPU. How many physical CPU's do you have?

    Also, in order to be able to REALLY take advantage of virtualization, you might want to purchase Windows Datacenter. It is also licensed by Physical CPU.

    For instance, we have a 2 physical CPU HP DL385 that has 12 cores each (total 24 core count) and we licensed the ESXi host for Windows R2 Datacenter for both physical CPU's and licensed for SQL 2008 R2 Enterprise Edition for both physical CPU's. Doing so "Entitles" you to run unlimitted MS Virtual Servers and unlimited MS SQL Servers.

    Here, we have 2 ESXi physical server with 2 cpu (each with 6 cores). We have build 4 sql servers VMs and installed 4 SQL Server 2008 R2 Enterprise Edition instances (one instance on each server)

    How the licensing works for my above setup?

    Thanks

  • You need to work with your Microsoft Representative to identify the best licensing for your situation.

    Be very careful when looking at licensing on virtual machines. If you buy the right license, you can put SQL Server on every single guest OS with no additional costs. However, if you don't have that - then you have to license based on each guest OS and what it sees.

    In other words - if the guest OS has been setup with 2 logical CPU's, you would need 2 processor licenses for that machine - and every other guest OS would need to be licensed separately.

    So - talk to your licensing representative to make sure you get the right licensing for your environment and what you can afford.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

  • Jeffrey has great advice. Here's the licensing doc on the MS site: http://www.microsoft.com/sqlserver/en/us/get-sql-server/how-to-buy.aspx

Viewing 5 posts - 1 through 4 (of 4 total)

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