SQL 2012 Core Factor Table

You may well have seen by now that SQL 2012 bring with it a big change, moving from “Per CPU” to “Per Core” licensing. (Read more here.)

Well there’s one more bit that hasn’t been widely announced but can make a fair difference in certain scenarios, and that is the “Microsoft SQL 2012 Core Factor Table”:



There is a minimum of 4 core licenses per physical processor so the above table shows that:

1 x Single Core = 4 Cores

2 x Dual Core = 4 Cores

which fits the model. However you can see that there is special dispensation for certain AMD processors where each physical core is worth just 0.75 cores when it comes to SQL. S0 that means:

6 physical cores on an AMD 32XX CPU = 4.5 SQL Cores*

*I believe this would be rounded up to 5…and you have to buy in multiples of 2 so doesn’t alter anything…but if you have an 8 core CPU of the above kinds, you’d then only need to buy 6 SQL cores (8*.75=6).

This does add an extra bit of complexity to correctly designing an SQL solution but hey, that’s what us licensing gurus are for right? Smile

I do wonder how this will affect decisions when companies are speccing up hardware for SQL deployments. Will previously 100% Intel houses start looking at AMD chips for the SQL cost savings they can bring?

3 Replies to “SQL 2012 Core Factor Table”

  1. This helps AMD be a little more competitive, but it far from closes the gap in my opinion based on the benchmarks I have seen so far. I wish AMD was doing better on the high end, to help keep Intel focused on pushing the release cycle.

  2. Core factor table was supposed to counterbalance CPU power in case of multi-core chips. When i see 1 x Single Core(ie Intel Pentium III) = 4 Cores. Are you kidding ?!?!

    The only purpose of this figure is to force company to trash their old assets, not counterbalance CPU power. When i see other vendor’s core factor table like IBM, ORACLE that says 1 single core CPU = 1 Core, from my point of view, with this metric and + 25% for the CAL Price, Microsoft try to swindle its customers.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: