
Chapter 5. Optimizing performance within an IBM Tivoli Monitoring environment 175
AWE enabled
Enable this parameter to take advantage of memory above 4 GB. This is
applicable only for 32-bit operating systems.
In Microsoft SQL Server 2005, you can use the Address Windowing
Extensions (AWE) API to provide access to physical memory in excess of the
limits set on configured virtual memory.
The default value is 0 (Disabled).
To enable AWE, set awe enabled to 1.
Max server memory
This specifies the maximum and minimum memory, respectively, in
megabytes allocated to an SQL Server instance.
The default values are 2147483647 and 0, respectively.
Max server ...