SQL 2008 R2 Ram Limitiation

[hennessy1]

I was reading conflicting information some say that sql memory limit is what ever the OS limit is others say there is a limit for the different versions. I was wondering if anyone knew a link that had the definite answer or knew offhand themselves.

 

[DnetMHZ]

According to Microsoft the limitations are as follows:

Express Edition: 1 GB
Web Edition: OS Limit
Workgroup: 4GB
Standard: 64GB
Enterprise: 2TB

http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx

 

[hennessy1]

Thank you very much.

 

[Emulex]

oh damn i was hoping to use 72gb with standard. i guess i can let the o/s spare some ram for cache/whatever.

 

[yinan]

If you need 72GB of RAM for SQL then you should be able to afford enterprise.

 

[hennessy1]

Ya I am ending up going enterprise for both server and sql because of that. Quick question though if they are x64 why is there a ram limitation like that when windows 7 has 192GB?

 

[Emulex]

isn't that per instance?

Lol the dl380 G7 server cost less than MSRP on enterprise edition base 2008 R2 🙂 not all of us pay list price