homepage Welcome to WebmasterWorld Guest from 50.17.176.149
register, free tools, login, search, subscribe, help, library, announcements, recent posts, open posts,
Pubcon Website
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderators: physics

Databases Forum

    
AWE and Fixed vs Dynamic Memory Allocation
Configuration question.
woop01




msg:1579579
 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.
Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About
© Webmaster World 1996-2014 all rights reserved