Can someone shed a light on this; it is Windows 2008 memory concern. WE have Windows 2008 R2 that is running SQL, I have risen my concern about memory is LOW; as you can see from the image 8GB is installed. My concern is that as per image the server is at 95% usage and hence the memory is at almost peak and hence may risk the server crashing or not being responsive and overall performance is effected, I have recommended that extra memory should be installed.
However the other system administrator argues and says this is normal behavior of windows 2008 and there should be no concern! And NO additional memory is required!
Now looking at the image provided I can see the following, 95% Used memory SQL server have 6.7GB of memory committed to it and rest is divided to the OS. The other admin argues that the memory committed to the SQL is not all consumed by SQL and can be taken from SQL instance when the system (OS) requires it. I argue back and say this is not true and only 45MB of memory is permissible to be taken from SQL as per image (Sharable memory)
Can someone please clearly explain how memory is used in windows 2008 and provide links where I can take back to the other system admin and discuss further and put this matter to rest. I appreciate if you could explain the memory categories in the image such as WORKING SET, COMMITED, SHAREABLE, PRIVATE, IN USE, MODIFIED, STANDBY FREE etc
I have awarded MAX points for this
Please feel free if you require further information
Thanks in advance