Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Carat
Yak Posting Veteran
92 Posts |
 Posted - 2008-11-21 : 07:37:21
|
| We have a production system that has a dual quad core cpu on Windows Server 2003 Standard Edition.I just read that only 4 cpu's are supported on this version of Windows. Windows Server 2003 Enterprise Edition supports 8 cpu's.Does this mean that our SQL Server is using only 4 cpu's instead of 8 or am I wrong? Thanks. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-11-21 : 10:16:22
|
| Yes, If you are using Standard Edition. |
 |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2008-11-21 : 11:01:14
|
| SQL Server 2005 Standard support in based on processor packages, not cores, so all 8 of the CPU cores are supported.http://www.microsoft.com/Sqlserver/2005/en/us/Special-Considerations.aspx"Microsoft has been driving thought leadership in this area by charging the same amount per processor, regardless of how many cores are in the processor."http://technet.microsoft.com/en-us/magazine/cc162361.aspx"For the purposes of both licensing and CPU edition support, SQL Server considers only the number of physical sockets/CPUs, regardless of the number of cores on the processor. So, for example, the fact that SQL Server 2005 Standard Edition supports up to 4 CPUs means it will support 4 physical CPU sockets, regardless of the number of cores in each one (if you have 4 physical CPUs with 4 cores each, your Standard Edition deployment would have 16 logical CPUs to make use of). Moreover, even though you have 16 cores/logical CPUs, the licensing requires only that you pay for the 4 physical CPUs, not all 16 cores."CODO ERGO SUM |
|
|
|
Carat
Yak Posting Veteran
92 Posts |
Posted - 2008-11-21 : 11:50:38
|
| Many thanks! |
|
|
|
|
|
|
|
|
Dual quad core CPU on Windows Server 2003 Standard