Was this page helpful?


    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.



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



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


    You must login to post a comment.

    Attach file


    FileSizeDateAttached by 
    No description
    70.23 kB15:01, 8 Nov 2013cedActions
    No description
    38.91 kB15:01, 8 Nov 2013cedActions