Post reply

SQL server hogging memory

  • February 20, 2012 at 7:53 am

    #255937

    Can someone tell me if this is normal behaviour , I am watching the memory usage of SQLserver 2008 r2, every time i run some queries the memory goes up and up, when i close the open sessions down and exit SQL management server SQL server still holds on to the memory, if i restart the VOS service the memory is released is this normal?

    ***The first step is always the hardest *******

  • February 20, 2012 at 8:00 am

    #1449255

    The database engine is not going to release memory just because sessions are closed and SSMS is closed. SQL Server takes the memory it needs up to its max setting and holds onto it unless the OS needs it.

    Jared
    CE - Microsoft

  • February 20, 2012 at 8:02 am

    #1449260

    thanks that makes sense cheers

    ***The first step is always the hardest *******

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

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