We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

MS SQL Server 2008

Medium Priority
221 Views
Last Modified: 2015-01-05
Dear Experts,

There's some time our database server's memory reach the maximum available memory.
Is is a common thing in MS. SQL Server 2008?

Someone said that SQL server2008  just takes all the memory available and will release some back what's not needed when Windows OS asks for it.
If so.. then how we know when we need to upgrade the server's memory?

Kindly advise.

Thank you.

Comment
Watch Question

Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Commented:
Regarding upgrading the memory, that is up to you to decide, but you can use the Server 2008 utility Performance Monitor to see how the server performs. As RAM is cheap, I would certainly consider putting more RAM in to the server if it can take more, and you are running Server 2008 64 bit (for more than 4GB total RAM).

Author

Commented:
Hello AdoBeebo,

we are using windows server 2008 64bit with 8GB RAM and it's database server so the only main application is MS. SQL server 2008.

I open the Performance Monitor but still could not analyse and decide when we need to add more RAM or not.
In Reliability and Performance on Memory tab there are header fields:
Image, PID, Hard Faults/min, Commit, Working Set (KB), Shareable (KB), Private (KB)

is it from above fields we should analyse?

Kindly advise.

Thank you.





Author

Commented:
thanks
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.