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.


Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members