Hello

We are setting up a SQL Server 2000/Windows2003 cluster
ACTIVE/PASSIVE with the following configuration:

Server 1 - Active - 4Gbytes RAM
Server 2 - Passive -2Gbytes RAM

I know that on the server with 4Gbytes I should
enable /PAE on boot.ini and configure SQL for AWE. But on
server 2 (with 2Gbytes) that configurations is not
necessary.

I would like to know how to configure the AWE and PAE
configurations on both servers.

Thanks.

Asymmetrical clusters are not recommended and are not supported by Microsoft
PSS. Asymmetry removes much of the reliability of a cluster and detracts
from the high availability of the system. While I don't know what gear you
are building this out of, you need to have a certified configuration from an
approved vendor before it is certifiable and supportable. Taking gear you
have and plugging it together is not supported, even if the individual
components are on the Cluster Hardware Compatibility List.

--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com




"Carlos Souza" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Carlos,

PAE and AWE are for memory greater than 4GB. You can use the /3GB on the
one with 4GB of Ram and when it fails over SQL Server will just ignore the
/3GB switch.

--
Andrew J. Kelly SQL MVP


"Carlos Souza" <anonymous (AT) discussions (DOT) microsoft.com> wrote

I agree with Geoff and Andrew.

Here are some Microsoft KB articles that may be helpful to you :

HOW TO: Configure Memory for More Than 2 GB in SQL Server
http://support.microsoft.com/?id=274750

Q309395 The Microsoft Support Policy for Server Clusters and the HCL
http://support.microsoft.com/?kbid=309395

Q327518 The Microsoft Support Policy for Clustered SQL Servers
http://support.microsoft.com/?kbid=327518

HTH,

Uttam Parui
SQL Server Developer Support Engineer, MCDBA, MCSE, MCT
Product Support Services
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.