Memory management (fixed memory, AWE)

Hi,

I am going to install SQL Server 2000 (then SQL 2K5) on a Win Server 2K3 with 8 GB of ram, but it will be 16 GB in the near future.

I would like to reserve a fixed memory (for momemt less than 3-4 GB) for SQL Server and the rest for application (virtualization).

Without AWE enabled, max memory for SQL Server 2K5 is 4GB as for SQL Server 2000?

How can I manage and optimize memory keeping in mind AWE. (any doc, website available?)

Thank

I forgot to write that SQL server is 2000 Standard Ed:

On Windows Server 2003, max memory is 2 or 4 GB

And in the case of SQL Server 2K5?

Thank

|||

I am a bit confused by your questions but I can tell you that SQL 2005 Std. edition UNLIKE 2000's max memory is only bound by the OS it runs on. Thus I have deployed sql 2005 std on 2003 server ent. with 16GBs of memory in them.

Derek

|||fasttrack, did this solve your problems? Can you update thread?|||

Thank,

how to solve:

/PAE for win server 2003 Enterprise edition.

If SQL server 2000 Std, not enable AW, because max memory is 4 gb.

If SQL server 2000 Ent AWE enable to take advantage of all memory available. Setted max memory for other applications.

If SQL server 2005, both std and Ent AWE is enable. Max memory setted for others applications