Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

MS SQL Server 2008

Posted on 2009-07-09
4
Medium Priority
?
209 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.

0
Comment
Question by:hotex
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 3

Accepted Solution

by:
AdoBeebo earned 1500 total points
ID: 24812027
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
 
LVL 3

Expert Comment

by:AdoBeebo
ID: 24812042
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
 

Author Comment

by:hotex
ID: 24820138
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
 

Author Closing Comment

by:hotex
ID: 31601488
thanks
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You might have come across a situation when you have Exchange 2013 server in two different sites (Production and DR). After adding the Database copy in ECP console it displays Database copy status unknown for the DR exchange server. Issue is strange…
Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
This tutorial will walk an individual through locating and launching the BEUtility application and how to execute it on the appropriate database. Log onto the server running the Backup Exec database. In a larger environment, this would generally be …
This tutorial will walk an individual through the steps necessary to configure their installation of BackupExec 2012 to use network shared disk space. Verify that the path to the shared storage is valid and that data can be written to that location:…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question