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 |
|
pras2007
Posting Yak Master
216 Posts |
 Posted - 2010-03-02 : 07:47:42
|
| Hello All,We have 2 instances on SQL Server 2005 64bit on the same box set to use 14GB of memory; at times we get high pagefile/physical memory usage on the server. Does anybody know how this issue can be resolved without moving one of the instances?Please advice.The Server information:- Windows Server 2003- Enterprise x64 Edition- 16.0 GB of RAMThanks |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2010-03-02 : 09:19:23
|
| Is each instance set to use 14 GB or is that the total of both instances?CODO ERGO SUM |
 |
|
|
pras2007
Posting Yak Master
216 Posts |
Posted - 2010-03-02 : 10:44:26
|
| Each instance is set to 14GB, thanks for the reply... Please advice. |
|
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2010-03-02 : 12:09:52
|
| and total RAM is 16GB on system right? |
|
|
|
pras2007
Posting Yak Master
216 Posts |
Posted - 2010-03-02 : 12:46:23
|
| Yes. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2010-03-02 : 15:40:16
|
| How much Virtual Memory have you set? Set Memory limit per instance. |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2010-03-02 : 22:03:04
|
| You should set a limit on each instance so that the sum of the two limits is about 14 GB.For example, set the limit on instance one to 8 Gb and limit on instance two to 6 GB.Or, as an alternative, add more memory to the server to bring it up to 32 GB.CODO ERGO SUM |
|
|
|
|
|
|
High pagefile/physical memory usage