Anyone using /3GB parameter for their SQL Server hosting K2?


Badge +3
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.

3 replies

Badge +13
That parameter allows 3GB memory to be used by SQL Server 32bit edition, otherwise only 2GB memory can be used.
Badge +13
So in your setup are you allowing SQL Server to use more than 3 GB memory?

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

Reply