Post reply

release memory

  • May 19, 2008 at 1:01 pm

    #186778

    Could you tell me how i can release memory after ran a proccess, because, this process takes my pc over at all.

    The process is sqlservr.exe, I am working with sql 2000 SP4,

    please tell me if exist any command

  • May 19, 2008 at 1:32 pm

    #817421

    SQL Server will grab as much memory as it can (up to the sp_configure 'max server memory (mb)' setting). It will not release it without re-starting the service. If you want to limit SQL Server's memory usage, you'll have to set the max server memory setting to a value that works for you.

    The following example will set the limit to 1 GB

    sp_configure 'max server memory (MB)', 1024

    GO

    RECONFIGURE WITH OVERRIDE

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • May 19, 2008 at 2:17 pm

    #817442

    SQL is supposed to release memory if other applications request it, but I don't think it does it very quickly. However I agree with John that you should limit the memory used by SQL Server if it is causing issues.

  • May 19, 2008 at 3:46 pm

    #817497

    How about?

    DBCC FREEPROCCACHE

  • May 19, 2008 at 4:01 pm

    #817505

    DBCC FREEPROCCACHE removes the stored execution plans from cache. I don't think this actually 'frees' memory from the SQL Server process. If you've read otherwise; please post the link.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

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

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