Post reply

Will reducing max server memory setting need a reboot

  • March 9, 2017 at 9:56 pm

    #328189

    Hi I inherited one old DB Server which had 98% memory util,

    I changed the max server memory to 20 GB FROM the original setting 24 GB and memory util for sqlserver.exe came down to 70%, (otherwise it would have crashed the instance! )

    Does it need any reboot ? or is that the correct way to fix this?

    Thanks

  • March 9, 2017 at 10:01 pm

    #1932643

    sqlguy80 - Thursday, March 9, 2017 9:56 PM

    Hi I inherited one old DB Server which had 98% memory util,

    I changed the max server memory to 20 GB FROM the original setting 24 GB and memory util for sqlserver.exe came down to 70%, (otherwise it would have crashed the instance! )

    Does it need any reboot ? or is that the correct way to fix this?

    Thanks

    No reboot necessary. Other than ensuring there is no other software running that might run in and grab the 4GB you just freed up, you're done.

    Eddie Wuerch
    MCM: SQL

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

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