SQL Server supports the specified number of processor sockets multiplied by the number of logical CPUs in each socket. For example, the following is considered a single processor for purposes of this table:
-
A single-core, hyper-threaded processor with 2 logical CPUs per socket.
-
A dual-core processor with 2 logical CPUs.
-
A quad-core processor with 4 logical CPUs.
SQL Server is licensed per processor socket, and not per logical CPU basis.
|
SQL Server 2008 edition
|
Number of processors supported
|
|---|
|
Enterprise
|
Operating system maximum
|
|
Developer
|
Operating system maximum
|
|
Standard
|
4
|
|
Web
|
4
|
|
Workgroup
|
2
|
|
Express
|
1
|
|
Express with Tools
|
1
|
|
Express with Advanced Services
|
1
|
See Also