homepage Welcome to WebmasterWorld Guest from
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

AWE and Fixed vs Dynamic Memory Allocation
Configuration question.

WebmasterWorld Senior Member 10+ Year Member

Msg#: 15 posted 11:15 pm on Sep 7, 2005 (gmt 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.


Global Options:
 top home search open messages active posts  

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved