SQL 2005 and Windows 2003 Enterprise Edition

SQL Server 2005 32 bit Standard is installed on a Windows 2003 32 bit
Enterprise Server with 8GB memory.

Is any special configuration to do to use all memry?

Regrads,
Daniel

If you use /3GB swith in the boot.ini file, then your OS will allocate 1GB
memory for itself, if not then it takes 2GB.

You must use /PAE switch in your boot.ini file to be able to use more than
4GB memory for 32Bit systems.

You also should enabled AWE option in Server Properties (in SSMS) after
connecting to your SQL Server instance so that you can use more than 4GB of
memory for the buffer pool of SQL Server. And to enable this option, first
you need to add your SQL Server service account to the "Lock pages in
memory" in Local Security Policy -> Local Policy -> User Rights Assignment.
After enabling this AWE option, although it doesn't warn you to restart SQL
Server service, you'll need to restart it to take this change effect.

--
Ekrem Önsoy




"Daniel Imesch" wrote in message

> SQL Server 2005 32 bit Standard is installed on a Windows 2003 32 bit
> Enterprise Server with 8GB memory.
>
> Is any special configuration to do to use all memry?
>
> Regrads,
> Daniel