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 |
|
kcconnor
Starting Member
5 Posts |
 Posted - 2005-10-12 : 14:55:00
|
| I have 2 SQL Servers, each a 4x700mhz IBM server with 5.5GB of matching RAM. They run Windows 2003 Server sp1 with SQL 2000 sp4 in a cluster for one SQL Server. Each server has had it's boot.ini file modified to allow for PAE.SQL Server is configured (via sp_configure) to use AWE. The max ram setting is set to 4.5GB. The min ram setting is set to 3.5GB.Server #2, when the SQL Service is active on it, immediately grabs 4.5GB, just like it is supposed to.Server #1, when the SQL Service is active on it, immediately grabs 2.7GB. Watching from Perfmon, 1.9GB of physical memory remains free after all services are started. Why is Server #1 not even grabbing the minimum ram I specify? The max amount is available...the min is definitely available.What should I look for? |
|
|
|
|
|
AWE and Fail Over Cluster Problem