September 5, 2002 at 5:12 pm
Two Servers, each run one instance of SQL Server 2000 EE, Win2K Adv Server, they're the only application
SQL1 - 8 proc, 3.6 GB RAM
SQL2 - 2 proc, 1.0 GB RAM
Does AWE need to be set on SQL1 to take full advantage of available memory, or will SQL Server dynamically use it?
Does "max server memory" need to be fixed on SQL2 so as not to starve the O.S.?
September 6, 2002 at 1:23 am
SQL1: To allow SQL Server to use more than 2GB of memory, AWE needs to be enabled.
SQL2: Well, SQL will always leave about 180MB (I think that's the amount, could be wrong though) for the OS, but if you want to leave the OS more than that you'll have to set it yourself.
Chris Hedgate @ Apptus Technologies (http://www.apptus.se)
September 6, 2002 at 5:50 am
One of these days we'll have to get this written down exactly! Chris, you dont need AWE to use up to the 3G mark, correct? If you use /3GB in boot.ini you would get 3g for SQL, the remainder over 3G would not get used. If you want to leverage the additional .5g of memory, then you would need to use AWE.
Andy
September 6, 2002 at 6:41 am
This is from from BOL:
Enabling AWE
To enable AWE, set awe enabled to 1. SQL Server will reserve almost all available memory, leaving 128 megabytes (MB) or less, unless a value has been specified for max server memory.
Disabling AWE
To disable AWE, set awe enabled to 0. This setting is the default. The AWE API is not used. SQL Server 2000 operates in a normal dynamic memory allocation mode and is limited to 3 GB of physical memory.
Cheers,
Prakash
Prakash Heda
Lead DBA Team - www.sqlfeatures.com
Video sessions on Performance Tuning and SQL 2012 HA
September 7, 2002 at 10:04 am
Andy, you are absolutely right. In the conditions mcinmx01 describes it is possible to use the /3GB switch to use up to 3 GB. But, since the question was how to let SQL take full advantage of the available memory, I chose AWE. Could have answered in a different way of course, noting the /3GB switch as well. And yes, an article on this matter would be great, not just the 'how-to-do-it' part but experiences and in-depth description of what it actually does.
Chris Hedgate @ Apptus Technologies (http://www.apptus.se)
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply