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 |
|
CanadaDBA
583 Posts |
 Posted - 2012-02-14 : 09:23:10
|
| - 64 bit 2008 server with 128 GB RAM- SQL Server 2005 SP2- 20 SQL instances (1 root and 19 other instances)This is a new server and the instances from two other servers are being moved into this machine. Therefore, I don't want to change anything like applying SP3/4 or use SQL 2008 for now.Right now, SQL Server has allocated 127 GB of RAM and I am afraid nothing has left for Windows. Is it a good approach to set the Max server memory to 6 GB for each instance? Isn't it possible to tell SQL Server to use and manage 124 GB for its all instances?Thanks!Canada DBA |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2012-02-14 : 11:52:06
|
| You have to set it per instance.Leaving 8 GB for the OS is a good approach. Setting each of them to 6 GB, well, we can't tell from here. Depends on the memory requirements for each instance. |
 |
|
|
|
|
|
Memory management