I have a SCCM 2007 on a Windows server 2008 R2 Std with orginially 6 GB of memory.
Recently we ran into a pickle and needed to temporarly leverage this server as a File server for out Disk Array.
I noticed throughout the history of this server it would always be at 98% memory usage 5.8 GB used or so. So since were adding addtional overhead to this server I had a surplus of 2 GB sticks. So I max the number of DIMM slots with all the 2 GB stick x 9 = 18 GB of memory thinking that this would give us a surplus of available memory. To my surprise it used up 98% of the memory again 17.7 GB used.
So after seeing this I did some searching and found this info on this link
I also found this KB article about setting a fixed amount of memory for your SQL instance.
Knowing that I have 18 GB to work with and that SCCM 2007 is the only DB on this SQL instance can I set a Fix number of 6 GB for the SQL Server?