April 1, 2009 at 3:17 am
Hi Experts,
I have found that SQL server 2008 standard edition supports 4 CPU.Can anyone please tell me the number of core it supports?
April 1, 2009 at 8:24 am
I believe it is license PER PHYSICAL CPU, not core
http://www.developer.com/db/article.php/3502746
Of course, the pricing is being changed for 2005 - which is a polite way of saying that it's going up. For SQL Server 2005, per-processor licenses list at $24,999 for Enterprise, $5,999 for Standard, and $3,899 for Workgroup (at least Workgroup isn't going up). Enterprise server plus 25 CALs will be $13,499; Standard with 10 CALs is $2,799 and Workgroup with 10 CALs is $1,478. Of course, you can expect to see upgrade pricing that is much lower than this if you've got existing SQL Server 2000 licenses.
EXECUTIVE SUMMARY
SQL Server 2008 is available under three licensing models:
Server plus device client access license (CAL). Requires a license for the computer running the Microsoft server product, as well as CALs for each client device.
Server plus user client access license (CAL). Requires a license for the computer running the Microsoft server product, as well as CALs for each user.
Processor license. Requires a single license for each CPU in the operating system environment running SQL Server. This license includes unlimited client device access.
This document explains key licensing considerations for SQL Server 2008 customers.
http://www.mssqltips.com/tip.asp?tip=1164
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.
April 1, 2009 at 11:34 am
I don't think cores matter. You can have dual or quad cores.
April 2, 2009 at 7:11 am
Or 6-core processors, and shortly there will be 8-core procesors. SQL is licensed by number of CPU sockets, not number of cores.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
April 3, 2009 at 1:05 am
Thanks to all 😛
April 22, 2009 at 5:17 am
Oh itz ok Ratheeesh
[font="Comic Sans MS"]+++BLADE+++[/font]:cool:
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply