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