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 editionMaximum memory supported
DatacenterOperating system maximum
Enterprise2 TB
DeveloperOperating system maximum
Standard64 GB
Web64 GB
Workgroup4 GB (64-bit), OS maximum (32-bit)
Express1 GB
Express with Tools1 GB
Express with Advanced Services1 GB

4 GB for Reporting Services