Memory Supported by the Editions of SQL Server
SQL Server 2008 R2
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 |
