• muthyala_51 (3/11/2014)


    425 GB max memory setting.

    Given the fact you have a lot of CLR and ext stored proc, etc i would lower the max memory setting a little. Monitor the server and if necessary increase or decrease again. My temptation would be to lower it to 384GB and then monitor.

    You have to reserve enough RAM for the following

    Ext Stored Proc

    CLR

    Windows OS mem manager

    Any other apps running on the server

    But during the downtime all the memory was able to windows. As the sql server was just trying to grab memory from the windows after restart.