Post reply

Sql Reconfigure

  • August 5, 2022 at 4:54 pm

    #4073073

    Hi

    Will the below script will stop services ot will execute without restarting services

    sp_configure 'show advanced options', 1;

    GO

    RECONFIGURE;

    GO

    sp_configure 'max server memory', 65536; --64GB

    GO

    RECONFIGURE;

    GO

    WAITFOR DELAY '00:02:00';

    GO

    sp_configure 'max server memory', 215040; --210 GB

    GO

    RECONFIGURE;

    GO

    Thanks

     

  • August 5, 2022 at 5:47 pm

    #4073101

    it will execute fine without restarting the instance. and effect is immediate e.g. memory setting will apply immediately (unless the first one is a reduction of memory on which case it can take awhile until memory is released) - the second one will make the memory available to SQL Server and will be "filled" as soon as SQL needs it.

    Assumption here is that the underlying OS has the required memory available.

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

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