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


16 core and sql server enterprise license cost


16 core and sql server enterprise license cost

Author
Message
sayedkhalid99
sayedkhalid99
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1130 Visits: 557
hi,
what does enterprise edition per core mean , say if i have 2 cpu with 16 core do i need to buy 16 license of sql server.

https://www.microsoft.com/en-us/server-cloud/products/sql-server/purchasing.aspx#fbid=puguINf8EB5

and from above website what does it mean.

**Editions sold in the Per Core licensing model are sold as 2-core packs.

some one bought two quantity of sql server enterprise edition license , and it is not clear for how many core he has bought .

does it have any default min core requirements for sql server enterprise edition.
Luis Cazares
Luis Cazares
SSC Guru
SSC Guru (162K reputation)SSC Guru (162K reputation)SSC Guru (162K reputation)SSC Guru (162K reputation)SSC Guru (162K reputation)SSC Guru (162K reputation)SSC Guru (162K reputation)SSC Guru (162K reputation)

Group: General Forum Members
Points: 162209 Visits: 22749
You would get better help about licensing if you contact Microsoft directly. Anything said in this forum would be unofficial and possibly different from the real options you have.


Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?


How to post data/code on a forum to get the best help: Option 1 / Option 2
nal4236
nal4236
Old Hand
Old Hand (391 reputation)Old Hand (391 reputation)Old Hand (391 reputation)Old Hand (391 reputation)Old Hand (391 reputation)Old Hand (391 reputation)Old Hand (391 reputation)Old Hand (391 reputation)

Group: General Forum Members
Points: 391 Visits: 12
Yes, you need enough SQL Enterprise licenses to cover all 16 cores, however one SQL Enterprise license = 2 cores. So for a 16-core server you'll need a total of 8 licenses.

To add to that, each license allows for an offline mirror. Meaning you can setup database mirroring, or an unreadable AlwaysOn secondary in a DR site if you want. However, if you want an online mirror, as in a readable secondary for Read-Only Routing, you'll need full licenses for the secondary server too.
Lowell
Lowell
SSC Guru
SSC Guru (292K reputation)SSC Guru (292K reputation)SSC Guru (292K reputation)SSC Guru (292K reputation)SSC Guru (292K reputation)SSC Guru (292K reputation)SSC Guru (292K reputation)SSC Guru (292K reputation)

Group: General Forum Members
Points: 292172 Visits: 42051
a quick google shows me enterprise licenses for SQL2016 are $7,128 per core, so MSRP would be select 7128.00 * 16 = $114,048.00


At the PASS conference Glenn Berry noted it's a dangerous pitfall where the DBA is not in sync with the guy who orders hardware, because the hardware cost of getting more cores is trivial when licensing is not trivial at all;

one of his examples was a half million license cost example, as i remember.

Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!
nal4236
nal4236
Old Hand
Old Hand (391 reputation)Old Hand (391 reputation)Old Hand (391 reputation)Old Hand (391 reputation)Old Hand (391 reputation)Old Hand (391 reputation)Old Hand (391 reputation)Old Hand (391 reputation)

Group: General Forum Members
Points: 391 Visits: 12
Lowell (12/1/2016)
a quick google shows me enterprise licenses for SQL2016 are $7,128 per core, so MSRP would be select 7128.00 * 16 = $114,048.00


At the PASS conference Glenn Berry noted it's a dangerous pitfall where the DBA is not in sync with the guy who orders hardware, because the hardware cost of getting more cores is trivial when licensing is not trivial at all;

one of his examples was a half million license cost example, as i remember.



Yeah, pretty much. Only in this case you wouldn't need 16 licenses. Each license is worth 2 cores, so more accurately: $7,128.00 * 8 = $57,024. If you have an Enterprise Agreement, and you buy those licenses at the beginning of your 3-year contract, then that cost is divided up among the three years. Making it $57,024 / 3 years = $19,008 per year. And yes, do not let your hardware guys replace machines without talking to the Microsoft licensing guy first! Especially since Microsoft just applied the same rules to Windows Server 2016 (although one Windows Server 2016 license is worth 8-cores, I believe).

Oh, and BTW, that's about 1/6th the cost of Oracle, depending on who you ask.
GilaMonster
GilaMonster
SSC Guru
SSC Guru (902K reputation)SSC Guru (902K reputation)SSC Guru (902K reputation)SSC Guru (902K reputation)SSC Guru (902K reputation)SSC Guru (902K reputation)SSC Guru (902K reputation)SSC Guru (902K reputation)

Group: General Forum Members
Points: 902163 Visits: 48702
nal4236 (12/1/2016)
Yes, you need enough SQL Enterprise licenses to cover all 16 cores, however one SQL Enterprise license = 2 cores. So for a 16-core server you'll need a total of 8 licenses.


One license = one core. 16 cores, 16 licenses.
You buy the licenses in packs of two.

https://www.microsoft.com/en-us/sql-server/sql-server-2016-pricing

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass


nal4236
nal4236
Old Hand
Old Hand (391 reputation)Old Hand (391 reputation)Old Hand (391 reputation)Old Hand (391 reputation)Old Hand (391 reputation)Old Hand (391 reputation)Old Hand (391 reputation)Old Hand (391 reputation)

Group: General Forum Members
Points: 391 Visits: 12
One license = one core. 16 cores, 16 licenses.


Incorrect. You can only buy licenses in packs of two. The the price mentioned above is for one license "pack". Meaning 2 cores. The double ** at the bottom of the URL you posted:

**Editions sold in the per-core licensing model are sold as 2 core packs.

I've spent over $170,000 over a 6 year period on the 12 licenses of Enterprise Edition to cover the 24 cores we are running. Planned and purchased through a licensed Microsoft re-seller.
GilaMonster
GilaMonster
SSC Guru
SSC Guru (902K reputation)SSC Guru (902K reputation)SSC Guru (902K reputation)SSC Guru (902K reputation)SSC Guru (902K reputation)SSC Guru (902K reputation)SSC Guru (902K reputation)SSC Guru (902K reputation)

Group: General Forum Members
Points: 902163 Visits: 48702
nal4236 (12/2/2016)
One license = one core. 16 cores, 16 licenses.


Incorrect. You can only buy licenses in packs of two.


Indeed you can only buy licenses in packs of two, as my post clearly stated. A 16 core server requires 16 licenses which means buying 8 license packs. Not, as your post stated
So for a 16-core server you'll need a total of 8 licenses.


You mixed up license and license pack there.
16 cores = 16 licenses = 8 license packs.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass


nal4236
nal4236
Old Hand
Old Hand (391 reputation)Old Hand (391 reputation)Old Hand (391 reputation)Old Hand (391 reputation)Old Hand (391 reputation)Old Hand (391 reputation)Old Hand (391 reputation)Old Hand (391 reputation)

Group: General Forum Members
Points: 391 Visits: 12
Sounds like we're basically saying the same thing, we're just getting caught up in terminology. You cannot buy a single SQL Enterprise license that covers one single CPU core. SQL Enterprise licenses are only sold in the 2-core "pack", essentially what I'm referring to as a "single SQL Enterprise license" since you do not have the option to buy anything smaller. This line item has an associated cost and part number. In this example, that part number cost is $7,128.00. (That price is negotiable dependent on the deal you can make with Microsoft.) If you found licenses for $7,128, that means $7,128 for one "license" which is equivalent to 2-cores. Not $7,128 for one single core. Licenses are only sold in the 2-pack. So in this example, 16-cores means you will be purchasing a quantity of 8 licenses (or "license packs", depending on what terminology you want to use). So your effective cost is $7,128 * 8 = $57,024. If you buy that as a new Enterprise Agreement (EA), or at the start of a new 3-year EA then your yearly cost will be $57,024 / 3 years = $19,008 per year for 3 years.

Clear as mud?
GilaMonster
GilaMonster
SSC Guru
SSC Guru (902K reputation)SSC Guru (902K reputation)SSC Guru (902K reputation)SSC Guru (902K reputation)SSC Guru (902K reputation)SSC Guru (902K reputation)SSC Guru (902K reputation)SSC Guru (902K reputation)

Group: General Forum Members
Points: 902163 Visits: 48702
nal4236 (12/3/2016)
SQL Enterprise licenses are only sold in the 2-core "pack", essentially what I'm referring to as a "single SQL Enterprise license" since you do not have the option to buy anything smaller.


Yup, I'm well aware of that.
I was clarifying the terminology for the OP and others reading this who aren't as clued up on licencing, since saying "for a 16-core server you'll need a total of 8 licenses." could easily lead someone to conclude that they need a total of 8 licenses, and since licenses are sold in packs of two, they go any buy 4 packs, since "one SQL Enterprise license = 2 cores"

sayedkhalid: To summarise, you have a 16 core server, so you need to buy 16 licenses. All visible cores must be licensed. Licenses are sold in packs of two, hence you need to buy 8 license pack (each containing two core licenses). Is that any clearer?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass


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