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 |
