Post reply

MEM usage is high

  • April 5, 2011 at 10:27 pm

    #248230

    Hi,

    I have sql server 2008 databases running on windows server 2003 R2.

    When i check in task manager mem usage is high for sqlservr.exe (around 13GB).

    Total RAM 16GB.

    Pls suggest me how can i decrease mem usage?

    Regards

    Shekar

  • April 5, 2011 at 11:03 pm

    #1307805

    By default SQL Server uses everything that is available that it needs, if the OS pushes back SQL Server can give some back. (It is normally a good idea to leave at least 2-4 GB for the OS, more if you are running other process on the server like SSIS.)

    If you don't want SQL Server to use that much memory you can adjust the MAX server memory option. Here is a link to BOL about it: http://msdn.microsoft.com/en-us/library/ms178067.aspx

  • April 6, 2011 at 3:00 am

    #1307866

    Also set the MIN memory value and the option Lock Pages in Memory ON.This will make sure that sqlserver wont flush the memory to the OS

    in case of memory pressure and the memory value always remain between MIN and MAX value specified.

    Remember the memory value setting will affect only the memory for data pages.The memory used by SQL jobs,users and internal processes of SQL Server can be flushed to OS.

    --------------------------------------------------------------------------------------------------
    I am just an another naive wannabe DBA trying to learn SQL Server

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply