Post reply

Free memory after DBCC CHECKDB

  • July 18, 2012 at 5:27 am

    #264011

    Hi,

    When I run the DBCC CHECKDB, the SQL Server use intensive memory.

    Is there a way to release memory after passing the command?

    Thanks !!

    JoseACJr

  • July 18, 2012 at 5:36 am

    #1514139

    Memory utilization is dynamic in SQL server, SQL Server will take care of it very well.

  • July 18, 2012 at 5:44 am

    #1514144

    but the sqlservr.exe process continues to occupy too much memory ..

  • July 18, 2012 at 5:49 am

    #1514146

    I take it you haven't capped SQL's maximum memory and left it at the default 2TB.

    SQL will manage its own memory and release memory as and when it needs to as requested by the operating system. For example if SQL is holding 8GB of memory it needs 8GB of memory and will not release that 8GB of memory unless the OS tells it to.

    I suggest reading chapter 4 of the accidental DBA e-book (link in my signature) on memory management.

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

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