• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 861
  • Last Modified:

What is the recommended maximum SQL Server memory for SharePoint 2010


What is the recommended maximum SQL Server memory for SharePoint 2010?  I have SQL Server 2008 R2 and SharePoint 2010 installed on the same box (yes, not recommended). The server has 8 GB of physicall memory installed.

What would be the recommend maximum server memory (in MB) be set at in SQL Server?

1 Solution
Do you mean max ram to install or max ram to allocate to SQL? If install then there is no real max, this would be based on performance and what you can afford. If you mean allocate... I wouldn't. Best to let it handle itself. SQL will steadily earmark all the available physical memory (even if not using it) and release it to windows as requested
PBITAuthor Commented:
Does not the default setting for the maximum server memory for SQL Server leave no memory for the OS and other applications?
Max available memory not all the memory. The OS will claim unused memory back for itself as and when it needs it. SQL "takes" unused memory in advance so that queries can run faster without having to request the necessary memory first.
But the best way (if you must have both on the same server) will be to let it self manage and then investigate any bottlenecks. Depending in your load/traffic then RAM may only be one of several things to suffer

If you are using SQL 2008 R2 express then the maximum database space would be 10 gb
I would recomend to get more free space for your sharepoint to work as expected

Justin SmithSr. System EngineerCommented:
Since it's all on the same machine, I wouldn't recommend allocating more than 4 GB to SQL.

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Tackle projects and never again get stuck behind a technical roadblock.
Join Now