SQLServer 7.0 dynamic memory on W2K Advanced

[BootMeUp]

1)How do you safely change the limit (or amount) of dynamic memory available to SQLServer (I have heard that more than just changing the server properties is necessary with W2K Advanced)?
2)What is the safe max amount of dynamic memory alloc for SQL on a server with 8 GB RAM?
3)Is there a Microsoft document on this subject?

SQL7.0 SP3 W2K Advanced SP2 4Proc

Thanks
Steve A.

 

[aalmeida]

The following exerpt is from BOL article "Memory Arquitecture"
Microsoft® SQL Server™ 2000 dynamically acquires and frees memory as needed. It is typically not necessary for an administrator to specify how much memory should be allocated to SQL Server, although the option still exists and is required in some environments. When running multiple instances of SQL Server on a computer, each instance can dynamically acquire and free memory to adjust for changes in the workload of the instance.

SQL Server 2000 Enterprise Edition introduces support for using Microsoft Windows® 2000 Address Windowing Extensions (AWE) to address approximately 8GB of memory for instances running on Windows 2000 Advanced Server, and approximately 64GB for instances running on Windows 2000 Data Center. Each instance using this extended memory, however, must statically allocate the memory it needs.

AL Almeida
NT/DB Admin
"May all those that come behind us, find us faithfull"