We have a 32 bit SQL 2005 active-active clusterd server, with 8GB RAM in
each node. What should we do with boot.ini?

1 /3GB
2 /PAE
3 /3GB /PAE

You sepcify /3GB if you want the SQL process to be able to use 3GB virtual
address space. On most modern servers (at least the ones from tier-1 system
suppliers), if you are running Win2K3 Enterrprise, you don't need to specify
/PAE for the OS to see 8GB of physical memory. In fact, if the OS can see 8GB
of RAM, you don't need to specify /PAE.

Linchi

"NT007" wrote:

You sepcify /3GB if you want the SQL process to be able to use 3GB virtual
address space. On most modern servers (at least the ones from tier-1 system
suppliers), if you are running Win2K3 Enterrprise, you don't need to specify
/PAE for the OS to see 8GB of physical memory. In fact, if the OS can see 8GB
of RAM, you don't need to specify /PAE.

Linchi

"NT007" wrote:

You sepcify /3GB if you want the SQL process to be able to use 3GB virtual
address space. On most modern servers (at least the ones from tier-1 system
suppliers), if you are running Win2K3 Enterrprise, you don't need to specify
/PAE for the OS to see 8GB of physical memory. In fact, if the OS can see 8GB
of RAM, you don't need to specify /PAE.

Linchi

"NT007" wrote:

You sepcify /3GB if you want the SQL process to be able to use 3GB virtual
address space. On most modern servers (at least the ones from tier-1 system
suppliers), if you are running Win2K3 Enterrprise, you don't need to specify
/PAE for the OS to see 8GB of physical memory. In fact, if the OS can see 8GB
of RAM, you don't need to specify /PAE.

Linchi

"NT007" wrote:

You sepcify /3GB if you want the SQL process to be able to use 3GB virtual
address space. On most modern servers (at least the ones from tier-1 system
suppliers), if you are running Win2K3 Enterrprise, you don't need to specify
/PAE for the OS to see 8GB of physical memory. In fact, if the OS can see 8GB
of RAM, you don't need to specify /PAE.

Linchi

"NT007" wrote:

You sepcify /3GB if you want the SQL process to be able to use 3GB virtual
address space. On most modern servers (at least the ones from tier-1 system
suppliers), if you are running Win2K3 Enterrprise, you don't need to specify
/PAE for the OS to see 8GB of physical memory. In fact, if the OS can see 8GB
of RAM, you don't need to specify /PAE.

Linchi

"NT007" wrote:

You sepcify /3GB if you want the SQL process to be able to use 3GB virtual
address space. On most modern servers (at least the ones from tier-1 system
suppliers), if you are running Win2K3 Enterrprise, you don't need to specify
/PAE for the OS to see 8GB of physical memory. In fact, if the OS can see 8GB
of RAM, you don't need to specify /PAE.

Linchi

"NT007" wrote:

You sepcify /3GB if you want the SQL process to be able to use 3GB virtual
address space. On most modern servers (at least the ones from tier-1 system
suppliers), if you are running Win2K3 Enterrprise, you don't need to specify
/PAE for the OS to see 8GB of physical memory. In fact, if the OS can see 8GB
of RAM, you don't need to specify /PAE.

Linchi

"NT007" wrote:

You sepcify /3GB if you want the SQL process to be able to use 3GB virtual
address space. On most modern servers (at least the ones from tier-1 system
suppliers), if you are running Win2K3 Enterrprise, you don't need to specify
/PAE for the OS to see 8GB of physical memory. In fact, if the OS can see 8GB
of RAM, you don't need to specify /PAE.

Linchi

"NT007" wrote: