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 |
|
KiteyW
Starting Member
1 Post |
 Posted - 2011-11-30 : 09:00:08
|
| Hi,We have SQL Server 2008 R2 running on a Dell PE T710 Processor is 2 off Quad Core 2.4GhzRAM is 12GbOS is Server 2003 SP2 64-bitWe have two Instances running. Instance 1 runs 2 databases with associated applications, they are QPulse (Quality document Control) and SageCRM (CRM System)Instance 2 has a Solidworks PDM Database and application running on it. My question is what to configure the Max server memory setting to for each instance. Do I assume that an even setting would be 5Gb for Instance 1, 5 Gb for instance 2 leaving 2Gb for the OS etc? Or do I set each to 10Gb, I am as you see a little confused.ThanksCraig |
|
|
influent
Constraint Violating Yak Guru
367 Posts |
Posted - 2011-11-30 : 14:28:19
|
| Look at the section titled Running Multiple Instances of SQL Server, here: http://msdn.microsoft.com/en-us/library/ms178067.aspxI would recommend trying the first option, setting each instance to 5 GB (as you said), and see how that goes, assuming you think that each instance uses an equal amount of memory. You might want to monitor Page Life Expectancy before and after to make sure neither instance is suffering from memory pressure. |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2011-11-30 : 15:38:48
|
| It all depends on which instance needs more memory based on load.You can set max memory settings in Server Setting for each Instance and leave atleast 2GB for OS. I would definitely bump up the memory if I am to run 2 instances in same server. |
|
|
|
|
|
|
Max Mem Config for 2 instances