We have a 2 node windows 2000 active/active cluster running with 3 instances
of SQL 2000. I have set the memory up for each as follows:

Sp_configure 'show advanced options',1

RECONFIGURE

GO

Sp_configure 'awe enabled',1

RECONFIGURE

GO

Sp_configure 'min server memory',1536

RECONFIGURE

GO

Sp_configure 'max server memory',1536

RECONFIGURE

GO

sp_configure 'set working set size', 1
reconfigure with override

Sp_configure 'show advanced options',0

RECONFIGURE

GO



When two of the instances fail over I receive the following error in the
event log:



Event ID: 17055

Description:

17122:

initdata: Warning: Could not set working set size to 1572864
KB



The servers these are running on have 8GB of RAM each, and the OS is set to
use 1 GB through the /3GB switch in the boot.ini





What do these errors mean?



Thanks,

JBailey

Is there a reason I need to have AWE enabled if I am not dedicating 4 GB of
memory to the SQL server? Is there a better way to configure this?

Thanks,
JBailey

[quoted text, click to view]

The warning message occurs because when you have AWE enabled. Set Working
Set Size option is not supported when Address Windowing Extensions (AWE)
option is enabled on your SQL Server 2000.

Rand
This posting is provided "as is" with no warranties and confers no rights.

No you do not need AWE if SQL Server is configured to use less than 4 gig
of memory.

Rand
This posting is provided "as is" with no warranties and confers no rights.

So If I have 3 instances of SQL

Instance 1: 4.5GB min/max
Instance 2: 2.0GB min/max
Instance 3: 1.5GB min/max

I would only need to enable AWE on instance 1?

Thanks,
JBailey


[quoted text, click to view]

That is correct.

Rand
This posting is provided "as is" with no warranties and confers no rights.