SQL Server 2012 Core Factor Table for AMD Processors

As of April 1, 2012, Microsoft has a new SQL Server 2012 Core Factor Table for AMD processors. You can download it here (PDF warning). The complete SQL Server 2012 Licensing Overview is here. The most relevant part of this table regards the newer AMD 31XX, 32XX, 41XX, 42XX, 61XX, 62XX Series Processors with 6 or more cores, that have a core factor of 0.75. This means that AMD cores are somewhat more affordable for SQL Server 2012.

Back in January 2012, I talked about a new Hewlett Packard TPC-E benchmark submission that showed a 1,232.84 TpsE score for a two socket, 32 physical core AMD system, compared to a 1284.14 TpsE  score for a two socket, 12 physical core Intel system. Both of these TPC-E benchmark submissions were on SQL Server 2008 R2.  Back then, I pointed out how you would be paying 2.66 times as much for SQL Server 2012 Enterprise Edition licenses for the AMD system compared to the Intel system (32 physical cores vs. 12 physical cores).

Now, with the SQL Server 2012 Core Factor Table, you would only be paying twice as much for SQL Server 2012 Enterprise Edition licenses for the AMD system compared to the Intel system (32 physical cores times 0.75 vs. 12 physical cores). That is a slightly better story for AMD, but it is still a pretty hard sell. Based on the TPC-E benchmark results, both the older Intel Xeon X5600 Westmere-EP series and the new Intel Xeon E5-2600 Sandy Bridge-EP series do much better per physical core on OLTP workloads than the latest AMD Opteron 6200 series processors. These Intel processors simply have significantly better single-threaded performance, which is very important for OLTP workloads.

I really hope that AMD can do better with the upcoming Piledriver core based Opteron series in 2013.

About these ads
This entry was posted in AMD, Computer Hardware, Processors, SQL Server 2012 and tagged , . Bookmark the permalink.

3 Responses to SQL Server 2012 Core Factor Table for AMD Processors

  1. Jeff Bennett says:

    Glenn,
    Thanks for everything that you do. Good article. i will do my best to keep any manager from reading it, because all they will take away is that AMD is cheaper and therefore a better fit.
    “So what if it doesn’t perform? That why you are here” will be the justification..

    • Glenn Berry says:

      SQL Server 2012 Processor licenses will be a little cheaper (than they were) for those listed AMD processor families that have more than six cores, but they will still be more expensive than a better performing Intel solution. The somewhat lower hardware cost for the AMD processor compared to the hardware cost of the Intel processor is pretty trivial compared to the difference in the licensing cost. Glad you enjoyed the blog post!

  2. Pingback: Aaron Bertrand : A cautionary tale about grandfathering CAL licenses in SQL Server 2012 Enterprise

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 )

Google+ photo

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

Connecting to %s