homepage Welcome to WebmasterWorld Guest from 54.161.246.212
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

    
AWE and Fixed vs Dynamic Memory Allocation
Configuration question.
woop01

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

 

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