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 |
sandesh_moghe
Constraint Violating Yak Guru
310 Posts |
Posted - 2006-12-25 : 19:34:22
|
Hello All,I have two instances of SQL Server 2000.Total Server Memory - 7.75 GBDefault instance is dynamically configured with 6GB as max memory.Named instance is configured in the same way.Let's say, due to heavy connections, default instance is occupying almost 5GB of memory. But now there are very less connections, hence default instance doesnt required that much of memory. I know that SQL Server doesn't return it back unless OS requires it.Now my question is: If named instance require more memory, will default instance return some for named instance?Thanks in advance.-Sandesh |
|
Kristen
Test
22859 Posts |
Posted - 2006-12-26 : 13:19:30
|
My understanding is that if you have two instances of SQL Server installed you should NOT allocate memory to them such that the totally allocated to both exceeds the physical available memory.Kristen |
|
|
sandesh_moghe
Constraint Violating Yak Guru
310 Posts |
Posted - 2006-12-26 : 14:57:17
|
Thanks Kristen.I know this is not good configuration. But just wanted to know if i am having such configuration, will default instance free up some memory for named instance like- it releases for OS?Thanks in advance.Sandesh |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2006-12-26 : 15:16:01
|
As long as you allow SQL Server to reduce memory when necessary it will balance between the instances. In your case you must not use "fixed memory" allocation (ie. don't set min server memory and max server memory to the same values). As long as you have min memory at a lower value than max memory, SQL Server will reduce down to the min value on either instance as necessary.In 2000 Books Online, see "Dynamically Managing Memory Between Multiple Instances", link on MSDN here2000 - http://msdn2.microsoft.com/en-us/library/aa224754(sql.80).aspxIn 2005 Books Online, "Server Memory Options/Running Multiple Instances of SQL Server", link on MSDN herehttp://msdn2.microsoft.com/en-us/library/ms178067.aspx |
|
|
monty
Posting Yak Master
130 Posts |
Posted - 2006-12-26 : 22:15:16
|
its not garunteed that the memory will be released only for the instance in case other applications are in need of memory then it will be difficult for things to happen like wat u want it to be, but if it is a stand alone box then yes it will be relesed for the needded instance, but still i will repeat wat others have said u need to think again about ur configits me monty |
|
|
|
|
|
|
|