Welcome to WebmasterWorld Guest from

Forum Moderators: open

Message Too Old, No Replies

AWE and Fixed vs Dynamic Memory Allocation

Configuration question.

11:15 pm on Sep 7, 2005 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Feb 25, 2003
votes: 0

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.

Server Specs

3 Ghz
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.