MS SQL Server 2008

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.

hotexAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

AdoBeeboCommented:
You are correct, SQL Server will take as much memory as is available to work with when it needs it and will release the memory when it does not. You can set the maximum memory that SQL is allowed to use in the SQL Server properties of Management Studio. If you are concerned about running other applications on the server then you could set the value to 2GB less than the total memory in the server. I say 2GB because that is the minimum recommended RAM for Server 2008, although you could change this value to suit your needs. For example, if you have 4GB memory in the server, set the max memory value to 2048 MB and restart the SQL Server services. This will impact how well SQL processes though, so it is a trade off.
If there are other applications on the server which you want to perform better you might consider moving them to a different server.
This article on MSDN explains SQL Server's use of memory very well.
http://msdn.microsoft.com/en-us/library/aa196734(SQL.80).aspx
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
AdoBeeboCommented:
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).
0
hotexAuthor 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.





0
hotexAuthor Commented:
thanks
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.