Memory Supported by the Editions of SQL Server

The following table specifies the maximum memory support for each edition of SQL Server 2008 R2.

SQL Server edition

Maximum memory supported

Datacenter

Operating system maximum

Enterprise

2 TB

Developer

Operating system maximum

Standard

64 GB

Web

64 GB

Workgroup

4 GB (64-bit), OS maximum (32-bit)

Express

1 GB

Express with Tools

1 GB

Express with Advanced Services

1 GB

4 GB for Reporting Services