muthyala_51 (3/11/2014)
500 GB RAM
Bit of an odd figure, i'm assuming that's 512GB RAM?
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
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉