Skip to main content
We use a back-end SQL cluster running win2k3 enterprise and 5gb of ram. We use the /3gb and /pae extensions in the boot.ini, as well as enabling AWE from within SQL as well. Works fine.
That parameter allows 3GB memory to be used by SQL Server 32bit edition, otherwise only 2GB memory can be used.
So in your setup are you allowing SQL Server to use more than 3 GB memory?

Are you using SQL 2005 SP1?
The above configuration along with the awe parameter has it setup to use 4GB of ram. We are using SQL 2000 SP3

Reply