Was this page helpful?

Memory

    How to adjust memory usage by using configuration options in SQL Server

    When you start Microsoft SQL Server, SQL Server memory usage may continue to steadily increase and not decrease, even when activity on the server is low.

    This behavior alone does not indicate a memory leak. This behavior is typical and is an intended behavior of the SQL Server buffer pool.

     

    You can establish upper and lower limits for how much memory (buffer pool) is used by the SQL Server database engine with the min server memory and max server memory configuration options.

    Server_Properties.jpg

    Example:

    Minimum server memory (in MB) = 2000
    Maximum server memory (in MB) = 3000

     

    MemoryStatus.jpg

    Was this page helpful?
    Tag page (Edit tags)
    • No tags
    Page statistics
    1952 view(s), 2 edit(s) and 1064 character(s)

    Comments

    You must login to post a comment.

    Attach file

    Attachments

    FileSizeDateAttached by 
     MemoryStatus.jpg
    No description
    70.23 kB15:01, 8 Nov 2013cedActions
     Server_Properties.jpg
    No description
    38.91 kB15:01, 8 Nov 2013cedActions