Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
desp59
Starting Member
1 Post |
 Posted - 2012-03-20 : 15:28:27
|
| I have a SQL server with two instances on it. The server has 8GB of ram and one of the instances is taking up 6.5GB of it. This is a Windows 2008 R2 server running SQL 2008 R2. I see some references online to setting the max memory under the instance properties but then others that say I should not have to do this with 2008. How can I tell why this is using 6.5 GB of ram? There are 4 really small databases on this instance and it shouldnt be using anywhere close to that. The other instance has a 13GB database which still isnt that big but that is only using like 200MB of memory because the one instance is taking it all up. |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2012-03-20 : 18:02:48
|
| Take a look at the Server Properties->Memory->Minimun server memory and Maximum server memory settings on each instance. It's possible that your instances are contending for the same memory resource. Setting the Minimun server memory per instance might help. Be aware though that the term "Minimun server memory" is a misgnomer in that you are not guaranteed that amount of memory. The instance will grab memory as it needs it and won't deallocate memory below the minimum level. However, if someone else, like instance #2, needs and grabs all the memory before instance #1 "needs" it, instance #1 is out of luck until the memory gets released, which may be never.From your description of the "small" instance, perhaps you can find an Min and Max setting for it which will allow your other instance to ebb and flow without too much interference.=================================================It is not so much our friends' help that helps us as the confident knowledge that they will help us. -Epicurus, philosopher (c. 341-270 BCE) |
 |
|
|
|
|
|
High Memory Usage