SQL Server 2008 R2 - Memory Allocation We have a SQL Server 2008 R2 instance that is running on a Windows Server 2008 R2 Enterprise server that has been allocated 128GB of memory. However, it maxes out at 70GB. Can anyone tell me how I can allow the SQL server to utilize the majority of its memory?? Thanks in advance.
If you use SQL Server 2008 R2 Standard Edition, you are limited to 64GB RAM per SQL-Server instance.

Memory Supported by the Editions of SQL Server