SQL Server 2005 CPU Licensing with Multi Core Technology


By:   |   Updated: 2007-01-26   |   Comments (1)   |   Related: More > Licensing

Problem
In addition to hyper-threading (i.e. multiple threads execute on a single physical CPU appearing as 2 logical CPUs) and dual-core technology (i.e. a single CPU socket that has more than 1 core appearing as multiple logical CPUs), chip vendors are beginning to release processors with more than 2 cores.  I am considering purchasing a new SQL Server with multi-core processors to support a SQL Server 2005 Standard Edition deployment.  What are the impacts when using a 4-core processor with SQL Server 2005 Standard Edition?  Will I only be able to make use of a single physical CPU since Standard Edition is limited to 4 CPUs? Additionally, what is the overall licensing policy in relation to multi-core technologies with SQL Server 2005?

Solution
One key competitive licensing advantage of SQL Server is related to this exact question - for the purposes of both licensing and CPU edition support, SQL Server considers the number of physical sockets/CPUs, regardless of the number of cores on the processor.  So, for example, if you are planning to deploy SQL Server 2005 Standard Edition, which supports up to 4 CPUs, that means Standard Edition will support 4 physical CPU sockets, regardless of the number of cores in each CPU.  If you have 4 physical CPUs with 4 cores each, then your SQL Server Standard Edition deployment would have 16 logical CPUs to make use of. Additionally, even though you have 16 cores/logical CPUs, the licensing of this requires that you pay for only the 4 physical CPUs, not all 16 cores.  This offers a very attractive return on investment (ROI) for any organization looking at the latest hardware with SQL Server 2005. 

For additional information on SQL Server 2005 and multi-core licensing, reference the SQL Server Multicore Licensing Policy article.

Next Steps

  • With these new CPU options, research these options with your hardware vendor of choice to see what opportunities are available with their latest and greatest servers
  • If your applications are CPU bound and you are unable to tune the SQL Server and queries any further, then research the multi-core opportunities to meet your CPU needs
  • Keep in mind the huge pricing advantage for SQL Server 2005 with support for multiple cores when you start to look at other DBMS's in your environment or considering upgrading
  • Special thanks to Chad Boyd from the MSSQLTips.com community for this tip.  


Last Updated: 2007-01-26


get scripts

next tip button



About the author
MSSQLTips author Chad Boyd Chad Boyd is an Architect, Administrator and Developer with technologies such as SQL Server, .NET, and Windows Server.

View all my tips
Related Resources





Comments For This Article




Tuesday, April 15, 2014 - 9:44:06 AM - Jay Back To Top (30071)

Hi,

 

Could you please provide me some SQL DBA interview questions for 8 - 10 years experience candidates. When i google for dba interview question i am getting only basic level of questions. kindly email me those questions.

 

Thanks in advance

Jay



download


Recommended Reading

Script to get CPU and Cores for SQL Server Licensing

Understanding the SQL Server 2012 Licensing Model

Differences between SQL Server 2012 Enterprise Edition - Server CAL and Per Core Licensing





get free sql tips
agree to terms


Learn more about SQL Server tools