What is the recommended maximum SQL Server memory for SharePoint 2010

Posted on 2012-09-14
Last Modified: 2012-09-17

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?

Question by:PBIT
    LVL 29

    Expert Comment

    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

    Author Comment

    Does not the default setting for the maximum server memory for SQL Server leave no memory for the OS and other applications?
    LVL 29

    Expert Comment

    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
    LVL 2

    Expert Comment


    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

    LVL 38

    Accepted Solution

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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    The Scenario: Let’s say you have a quote worksheet in Excel that you use to work up sales figures and such for your clients. You utilize SharePoint to manage and keep track of these documents. You would like values from your worksheet to populate Sh…
    When setting up new project requests for our site, one of the most powerful tools our team has available to use is Axure ( It’s a tool for creating software and web prototypes that can function and interact as if it were the a…
    The purpose of this video is to demonstrate how to reset a WordPress password if you are locked out and cannot reset the password. A typical use would be if you cannot access the email to which WordPress would send the password recovery email to…
    The purpose of this video is to demonstrate how to prevent comment spam on a WordPress Website. This will be demonstrated using a Windows 8 PC. Plugin Akismet will be used. Go to your WordPress login page. This will look like the following: myw…

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now