Posted by Plamen Ratchev on 03/15/07 13:56

For licensing purposes SQL Server 2005 counts only physical CPU's,
regardless of whether they are hyper-threaded, dual-core, quad-core, etc.
Also, SQL Server 2005 will use all of the logical CPU's that are present
(based on the physical CPU count limitation).

See more details in the SQL Server Multicore Licensing Policy:
http://www.microsoft.com/sql/howtobuy/multicore.mspx

As for the physical CPUs supported by the different SQL Server 2005
Editions, here it is:
- Express - 1 CPU with multicore support
- Workgroup - 2 CPUs with multicore support
- Standard - 4 CPUs with multicore support
- Enterprise - Unlimited CPUs with multicore support

Have in mind that SQL Server will see only as many CPUs as the OS supports.

HTH,

Plamen Ratchev
http://www.SQLStudio.com

• Next in forum: restaurant database
• Prev in forum: sql server 2005 enterprise - Max CPUs
• Thread view: Re: sql server 2005 enterprise - Max CPUs

[Reply to this message]