October 20, 2010 at 1:15 pm
Hello, can some one please help me to figiure out if I have enough memory on the SQL server and if I need and can add more memory. I have on maximum server 8115 MB. I also have 10 databases.Thank you
October 20, 2010 at 1:36 pm
Is the server running out of memory? If yes, then you need more. If no, then you don't.
There's no way to tell if a certain number of databases will require a certain amount of memory. It doesn't work that way.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
October 20, 2010 at 1:39 pm
How to find out if server running out of memory?
October 20, 2010 at 1:42 pm
If you really can't answer that, you probably need to hire an IT person who knows how to use server tools.
Start by opening up the task manager on the server and looking at the Performance tab. That'll at least give you a "right now" value for memory use. Then Performance Monitoring, et al, will need to be used to really monitor it. If you don't know how to open up Task Manager and look at the Performance tab, you definitely need to hire an IT person to handle the server for you, or you need to move your databases to a hosting company that will do that kind of thing for you.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
October 20, 2010 at 2:06 pm
What I am trying to understand is: I calculated all databases and I got 61586.55 MB in databases memory,on sql server max memory I have 8115 MB, on the drive where the data for databases leaves I have free of 80G, do I need to add more max memory ?
Thank you
October 20, 2010 at 2:30 pm
valeriepobeda (10/20/2010)
What I am trying to understand is: I calculated all databases and I got 61586.55 MB in databases memory,on sql server max memory I have 8115 MB, on the drive where the data for databases leaves I have free of 80G, do I need to add more max memory ?Thank you
Valerie,
You seem to have been kinda thrown under the bus here if you're stuck asking these questions about SQL Server. Involuntary DBA, I assume, or an intern? You're crossing definitions about memory like you're not sure which is which. Available RAM has nothing to do with physical storage space, and 'sql server max memory' is a server setting as to how much of that available RAM to use, which means that usually already have more you can grow into if you needed, or there's other apps contending for it.
Your physical file storage for a DB is not necessarily the memory it needs to use. You have 8Gigs of RAM. What GSquared is trying to say is that it will depend on usage to determine if this is enough, not depending on the database storage itself.
The drive space itself that's free/not free will have nothing to do with if you have enough RAM, either. You don't want to use the page file (physical file that takes over for RAM if RAM gets overloaded). If you're using a lot of the pagefile, then yes, you will also want to add more RAM.
You will need to look into monitoring techniques (google and perfmon, to start with), and then start looking up articles on 'memory pressure', 'cpu pressure', and 'page file'. You need to understand your system before you can determine what RAM modifications are correct, if any.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply