SQL Server Max memory for 64GB

Posted on 2014-08-25
Last Modified: 2014-08-25
right now the max memory option is default size (too big).

the actual physical size of RAM is 64GM.

this is a dedicated sql server. in this case, leaving it to default size is bad idea, as sql can start using up to 62,63,63.5GB and so forth? pl advise.
Question by:25112
    1 Comment
    LVL 4

    Accepted Solution

    SQL Server will take every bit of memory you give it and use it for buffer cache.  So setting max memory correctly is very important.  This is probably the #1 misconfigured item I see on SQL Servers.  Based on your description of your environment, I  would reserve 8GB or so for the OS and then monitor for OS memory issues.

    Here is an excellent article on the details, including how to monitor memory.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
    In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    737 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

    21 Experts available now in Live!

    Get 1:1 Help Now