Post reply

Increasing Max Server Memory on the fly

  • May 14, 2003 at 9:33 am

    #80154

    Hi All,

    I want to increase the Max Server Memory on my SQL server on the fly. Nowhere in BOL does it say you need to restart SQL services or reboot the server. I am wondering if this is the case and if i can change these memory settings on the fly (and have them take effect right away).

    I understand that if i increase it, it will not automatically allocate that memory to SQL server right away but will allocate up to that setting if needed.

    Thanks!

  • May 14, 2003 at 9:40 am

    #457118

    yes, there is no need to reboot the server.

  • May 14, 2003 at 9:41 am

    #457119

    And no need to restart SQL services as well?

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

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