We just upgraded our server from 2 to 4 GB of RAM and we're trying to figure out the best way to configure the SQL memory allocation.
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.