March 4, 2010 at 8:31 am
There are two instances per machine (total 2). And also during failover, all of the instances (totally 4) move onto one machine.
There is 64 GB of physical RAM available. But AWE is not enabled on any of the instances.
Could you kindly advise if AWE can be enabled on the instances and
If so what should be the min and max memory that needs to be allocated.
This is a 32 Bit OS and SQL
M&M
March 4, 2010 at 8:40 am
Moin,
Please specify your OS and SQL version/Edition.
Windows Server 2003, Standard Edition supports physical memory up to 4 GB.
Windows Server 2003, Enterprise Edition supports physical memory up to 32 GB.
Windows Server 2003, Datacenter Edition supports physical memory up to 64 GB.
MJ
March 4, 2010 at 10:34 am
Thanks Manu,
OS version is Windows Server 2003 Enterprise Edition
and
SQL Server is
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
M&M
March 4, 2010 at 11:22 am
32-bit or 64-bit?
The Redneck DBA
March 4, 2010 at 11:55 am
it is 32 bit both os and sql
M&M
March 4, 2010 at 12:13 pm
It looks only 32GB would be addressable by OS in such case. Better configure each instance max server memory in such a way that when all instances failover to one node their combined mm. usage is below 28GB leaving 4GB aside for OS.
http://msdn.microsoft.com/en-us/library/aa366778(VS.85).aspx#physical_memory_limits_windows_server_2003
Experts plz comment..
Manu
March 4, 2010 at 4:51 pm
Hi:
It may also be worth investigating if you A) have 64 GB presented to the OS and a different OS version or B) have 32 GB presented, the OS mentioned and the remaining 32 GB unutilized. Maybe you can use it elsewhere?
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply