Post reply

sql server 2008R2 - Memory is not releasing after big job run

  • August 20, 2013 at 7:43 pm

    #281367

    Hello,

    We have migrated to sql server 2008R2 and I have set up my MAX Memory 32 GB and MIN left a default 0.

    When I was watching performance while running big batch job, it was done within 30 minutes but memory was showing almost 30 GB in task manager and after it's ran, it was still showing 30 GB memory.

    I couldn't understand why it's not releasing memory after job is done and still showing 30 GB memory into task manager?

    Thanks,

  • August 21, 2013 at 12:21 am

    #1643316

    SQL Server will use and hold onto as much memory as you allow per the max memory setting. It is expensive to retrieve data from disk and load it into memory so unless Windows compels SQL Server to release memory it has committed why would it release anything if it might need the data it is holding onto for a later request :Whistling:

    Chapter 4: https://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/[/url]

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • August 21, 2013 at 10:49 pm

    #1643741

    Thanks, I will check the link.

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

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