Forum Moderators: open
Server Specs
3 Ghz
4 GB RAM
Windows 2003
SQL Server 2000 Enterprise
AWE enabled
/3G switch on
Should we use a fixed or dynamic memory allocation? I've seen in some places that with the AWE option, you might as well used a fixed amount of memory for SQL server. In others they always recommend using the dynamic option.