Post reply

Changing memory does it recycle buffer pool?

  • October 6, 2010 at 9:07 am

    #241369

    Changing memory at sql instance level does it recycle buffer pool? Is it safe to do it anytime? Thanks

  • October 6, 2010 at 9:18 am

    #1232699

    It does not flush the buffer cache, no.

    Adding memory at any time is safe..removing it will definitely kick things out of the cache, of course, so I wouldn't necessarily do it during peak hours (though I have before with no adverse effects).

  • October 6, 2010 at 9:59 am

    #1232747

    I am not a memory guru by any means but about the only way to clear the buffer pool is to reboot, restart the instance, or run dbcc dropcleanbuffers. Changing the memory setting should be fine.

  • October 6, 2010 at 10:16 am

    #1232769

    thanks

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

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