Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Maximum Number of Processors Supported by the Editions of SQL Server

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

Community Additions

ADD
Show:
© 2015 Microsoft