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 |