As noted in the SQL server 2008 R2 comparison chart below the Web edition is "memory OS Maximum." Standard 2008 x64 OS supports unto 32GB of RAM, as noted in the Windows Server 2008 R2 Standard Overview below. If the server supports 32GB of RAM can all this
memory be utilized by the SQL Server?
SQL Server 2008 R2 Comparision Chart:
Windows Server 2008 R2 Standard Overview:
View Complete Post