• You can change it right from ssms. No restart or reboot is required. take the current size of your buffer pool, subtract 200 mb, and try that as the size for max mem. Keep bumping it down until the problems go away. if you have to reduce it to under 6gb, then something fishy is going on...