Search This Blog

Microsoft SQL Server Licensing - abstract

Microsoft SQL Server Licensing – abstract

 

Terms used:

  • An OSE is an Operating System Environment.
  • A POSE is a Physical Operating System Environment.
  • A VOSE is a Virtual Operating System Environment.

General rules

  • SQL Server licenses are assigned only to physical servers.
  • The number of SQL Server instances in an OSE is unlimited.
  • A physical OSE is counted as having a minimum of 4 cores.
  • Counting must be done according to the Core Factors [1].
  • A virtual OSE is counted as having a minimum of 4 cores.
  • A physical hyper-thread is counted as a virtual core, but is not counted as a physical core.

Datacenter per Processor (2008 R2)

  • One license entitles to one physical processor.
  • Must license all physical processors.
  • Number of VOSEs is unlimited.
  • Number of physical cores is unlimited.
  • No CALs.

Parallel Data Warehouse per Core (2012)

  • One license entitles to one core, physical or virtual.
  • If running in POSE, must license by physical core.
  • If running in VOSEs only, may license by physical cores or virtual cores.
  • To license by physical core, must license all physical cores.
    ▶ May run SQL Server in a number of POSEs or VOSEs up to the number of licenses.
    ▶ Counting the physical cores must be done according to the Core Factors.
    ▶ Escapes the VOSE-uses-at-least-4-cores rule, making it more economical when using all or most of a large server via VOSEs.
    ▶ Cannot add licenses to run more VOSEs.
  • To license by virtual core, must license all virtual cores in all VOSEs running SQL Server.
    ▶ Each VOSE is treated as having at least 4 virtual cores.
    ▶ May run SQL Server in VOSEs only.
    ▶ Is more economical when using a small portion of a large server via VOSEs.
  • No CALs.
  • Software Assurance does not entitle to unlimited virtualization.

Parallel Data Warehouse per Processor (2008 R2)

  • One license entitles to one processor, physical or virtual.
  • If running in POSE, must license all physical processors.
  • If running in VOSEs, must license all used virtual processors.
  • Total number of licenses required is sum of POSE and VOSE licenses.
  • Number of physical cores is unlimited.
  • No CALs.

Enterprise per Core (2014 and 2012)

  • One license entitles to one core, physical or virtual.
  • If running in POSE, must license by physical core.
  • If running in VOSEs only, may license by physical cores or virtual cores.
  • To license by physical core, must license all physical cores.
    ▶ May run SQL Server in a number of POSEs or VOSEs up to the number of licenses.
    ▶ Counting the physical cores must be done according to the Core Factors.
    ▶ Escapes the VOSE-uses-at-least-4-cores rule, making it more economical when using all or most of a large server via VOSEs.
    ▶ Can add licenses to run more VOSEs (one additional license per one additional VOSE).
  • To license by virtual core, must license all virtual cores in all VOSEs running SQL Server.
    ▶ Each VOSE is treated as having at least 4 virtual cores.
    ▶ May run SQL Server in VOSEs only.
    ▶ Is more economical when using a small portion of a large server via VOSEs.
  • No CALs.
  • Bonus: If have Software Assurance and license by physical core, then entitled to unlimited virtualization (i.e., only need as many licenses as physical cores, regardless of number of VOSEs running SQL Server).

Enterprise per Processor (2008 R2)
Note: we ignore the option of the POSE using only a subset of the physical processors.

  • One license entitles to one processor, physical or virtual.
  • If running in POSE, must license all physical processors.
    ▶ One license entitles to four VOSEs.
  • If running in VOSEs only, must license all used virtual processors.
    ▶ Usage examples: in case of a physical processor with 4 cores: using 4 cores means using 1 processor; using 5 cores means using 2 processors.
  • Number of physical cores is unlimited.
  • No CALs.

Enterprise per Processor (2008 and 2005)
Note: we ignore the option of the POSE using only a subset of the physical processors.

  • One license entitles to one processor, physical or virtual.
  • If running in POSE, must license by physical processor.
  • If running in VOSEs only, may license by physical processors or virtual processors, whichever is cheaper.
  • To license by physical processor, must license all physical processors.
    ▶ Number of VOSEs is unlimited.
  • To license by virtual processor, must license all virtual processors in all VOSEs running SQL Server.
  • Number of physical cores is unlimited.
  • No CALs.

Enterprise per Server (2014 and 2012)
Available to existing Software Assurance customers only. Not available under new licenses.

  • One license entitles to four OSEs, physical or virtual.
  • Must license all OSEs running SQL Server.
  • POSE has core limit of 20.
  • Set of VOSEs has a total virtual core limit of 20.
    ▶ Can add licenses to run more VOSEs (one additional license per four additional VOSEs).
    ▶ Each additional set of VOSEs has a total virtual core limit of 20.
  • User and/or Device CALs required.

Enterprise per Server (2008 R2)

  • One license entitles to four OSEs, physical or virtual.
  • Must license all OSEs running SQL Server.
  • Number of physical processors is unlimited.
  • Number of physical cores is unlimited.
  • User and/or Device CALs required.

Enterprise per Server (2008 and 2005)

  • One license entitles to one POSE and an unlimited number of VOSEs.
  • Number of physical processors is unlimited.
  • Number of physical processors is unlimited.
  • Number of physical cores is unlimited.
  • User and/or Device CALs required.

Standard per Core (2014 and 2012)

  • One license entitles to one core, physical or virtual.
  • For SQL Server running in POSE, must license all physical cores.
    ▶ There is a 4-core minimum.
  • For SQL Server running in VOSE, must license all virtual cores in all used VOSEs.
    ▶ There is a 4-core minimum in each VOSE.
  • Total number of licenses required is sum of POSE and VOSE licenses.
  • No CALs.

Standard and Workgroup per Processor (2008 R2)

  • One license entitles to one processor, physical or virtual.
  • If running in POSE, must license all physical processors.
  • If running in VOSEs, must license all used virtual processors.
    ▶ Usage examples: in case of a physical processor with 4 cores: using 4 cores means using 1 processor; using 5 cores means using 2 processors.
  • Total number of licenses required is sum of POSE and VOSE licenses.
  • Number of physical cores is unlimited.
  • No CALs.

Standard and Workgroup per Processor (2008)

  • One license entitles to one processor, physical or virtual.
  • If running in POSE, must license all physical processors.
  • If running in VOSEs, must license all used virtual processors.
  • Total number of licenses required is sum of POSE and VOSE licenses.
  • Number of physical cores is unlimited.
  • No CALs.

Standard and Workgroup per Processor (2005)
Note: we ignore the option of the POSE using only a subset of the physical processors.

  • One license entitles to one processor, physical or virtual.
  • If running in POSE, must license all physical processors.
  • If running in VOSEs, must license all used virtual processors.
  • Total number of licenses required is sum of POSE and VOSE licenses.
  • Number of physical cores is unlimited.
  • No CALs.

Standard and Business Intelligence per Server (2014 and 2012)

  • One license entitles to one OSE, physical or virtual.
  • Must license all OSEs running SQL Server.
  • Each OSE is limited to 16 cores.
  • User and/or Device CALs are required.

Standard and Workgroup per Server (2008 R2 and 2008 and 2005)

  • One license entitles to one OSE, physical or virtual.
  • Must license all OSEs running SQL Server.
  • Number of physical processors is unlimited.
  • Number of physical cores is unlimited.
  • User and/or Device CALs are required.

Footnotes

[1] A "Core Factor" must be applied to certain AMD processors and to CPUs with single or dual cores:

Processor Type
Core Factor

AMD Series 31XX, 32XX, 33XX, 41XX, 42XX, 43XX, 61XX, 62XX, 63XX, with 6 or more cores  0.75

Single core 4

Dual core  2

Other  1

 

26 comments:

Priya Tamil said...

I am really enjoying reading your well written articles. It looks like you spend a lot of effort and time on your blog. I have bookmarked it and I am looking forward to reading new articles. Keep up the good work..

Android Training in Chennai

Priya Tamil said...

Thanks, I really appreciate the kind words ..thanks for sharing that valuable information.

SEO Training in Chennai

Dhiya L said...

Superb i really enjoyed very much with this article here. Really its a amazing article i had ever read. I hope it will help a lot for all. Thank you so much for this amazing posts and please keep update like this excellent article.

Hadoop Training in Chennai

Abiya Carol said...

Great Article… I love to read your articles because your writing style is too good, its is very very helpful for all of us and I never get bored while reading your article because, they are becomes a more and more interesting from the starting lines until the end.

PPC Services in Chennai

Suseela Susiee said...



What an awesome post, I just read it from start to end. Learned something new after a long time.

AWS training in Chennai

Jeffy said...

I just stumbled upon your blog and wanted to say that I have really enjoyed reading your blog posts. It will be helpful for resolving the license key for the people those who are installing. Any way I’ll be subscribing to your feed and I hope you post again soon.

SEO Training in Chennai

Thanu Abi said...

Excellent incredible blog layout! How long have you been blogging for? you make running a blog look easy. The overall glance of your website is magnificent, let alone the content!

Seo Company in Chennai

Shalini said...

Superb i really enjoyed very much with this article here. Really its a amazing article i had ever read. I hope it will help a lot for all. Thank you so much for this amazing posts and please keep update like this excellent article.thank you for sharing such a great blog with us. expecting for your updation.
Digital Marketing Company in Chennai

Xplorant Seo said...

Wonderful blog.. Thanks for sharing informative blog.. its very useful to me..

iOS Training in Chennai

Shalini said...

Superb. I really enjoyed very much with this article here. Really it is an amazing article I had ever read. I hope it will help a lot for all. Thank you so much for this amazing posts and please keep update like this excellent article.thank you for sharing such a great blog with us. expecting for your.
Digital Marketing Company in India

Shalini said...

Superb. I really enjoyed very much with this article here. Really it is an amazing article I had ever read. I hope it will help a lot for all. Thank you so much for this amazing posts and please keep update like this excellent article.thank you for sharing such a great blog with us. expecting for your.
Digital Marketing Company in India

Abiya Carol said...

Great Article… I love to read your articles because your writing style is too good, its is very very helpful for all of us and I never get bored while reading your article because, they are becomes a more and more interesting from the starting lines until the end.

Seo Training in Chennai

Jones Sathya said...

Dot Net Framework is the software framework developed by Microsoft Corporation. A programming infrastructure created by Microsoft for building, deploying, running applications and services use of Learn .net technologies such as desktop applications and web services.Dot Net Training in Chennai

sunitha vishnu said...


This is excellent information. It is amazing and wonderful to visit your site.Thanks for sharng this information,this is useful to me...
Android training in chennai
Ios training in chennai

sunitha vishnu said...


This is excellent information. It is amazing and wonderful to visit your site.Thanks for sharng this information,this is useful to me...
Android training in chennai
Ios training in chennai

sunitha vishnu said...




Thanks for posting useful information.You have provided an nice article, Thank you very much for this one. And i hope this will be useful for many people.. and i am waiting for your next post keep on updating these kinds of knowledgeable things...Really it was an awesome article...very interesting to read..please sharing like this information......
Web Design Development Company
Mobile App Development Company

Reena raj said...


Really it was an awesome article...very interesting to read..You have provided an nice article....Thanks for sharing..
Web Design Company
Web Development Company

Reena raj said...


Really it was an awesome article...very interesting to read..You have provided an nice article....Thanks for sharing..
Web Design Company
Web Development Company

Vamshi Krishna said...



Thanks for posting such an interesting inforamtion, Please keep updates us and make us up to date....

Philips Huges said...



Wonderful blog.. Thanks for sharing informative Post. Its very useful to me.

Installment loans
Payday loans
Title loans

john stany said...

This article is very much helpful and i hope this will be an useful information for the needed one. Keep on updating these kinds of informative things...

Android App Development Company

Priya Kannan said...

Excellent ! I am truly impressed that there is so much about this subject that has been revealed and you did it so nicely. SQL Server Training in Chennai

Sharon Sandy said...

great and nice blog thanks sharing..I just want to say that all the information you have given here is awesome...Thank you very much for this one.
web design Company
web development Company
web design Company in chennai
web development Company in chennai
web design Company in India
web development Company in India

Sharon Sandy said...

great and nice blog thanks sharing..I just want to say that all the information you have given here is awesome...Thank you very much for this one.
web design Company
web development Company
web design Company in chennai
web development Company in chennai
web design Company in India
web development Company in India

louis philip said...

You have provided an nice article, Thank you very much for this one. And i hope this will be useful for many people.. and i am waiting for your next post keep on updating these kinds of knowledgeable things...
Fitness SMS
Salon SMS
Investor Relation SMS

john stany said...

I wondered upon your blog and wanted to say that I have really enjoyed reading your blog posts. Any way I’ll be subscribing to your feed and I hope you post again soon.
iOS App Development Company