February 11, 2010 at 1:08 am
After Reading The Folwing section of an articale
I am confused should I configure My SQL Server 32 Bit AWE option
on Windows Server 64 bit.
It Is said Specificaly :
"AWE is not required and cannot be configured on 64-bit operating systems. "
But does it sujests that the boot ini of the operating system should not be configured or
the sql server should not be configured ?
At the end of The Article it says :
"To make AWE available to an instance of SQL Server, use sp_configure to set the awe enabled option to 1, and then restart SQL Server. "
This is some of a contradiction .
Please help on this ?
Configuring Memory Options
SQL Server dynamically allocates AWE-mapped memory when running with any of the Windows Server 2003 operating system editions. In other words, the buffer pool can dynamically manage AWE-mapped memory (within the constraints of the min server memory and max server memory options) to balance SQL Server memory use with the overall system requirements.
When AWE is enabled, SQL Server always attempts to use AWE-mapped memory. This applies to all memory configurations, including computers configured to provide applications with less than 3 GB of user mode address space.
We recommend setting AWE as the default memory mode for SQL Server running under Windows Server 2003. The Hot-Add Memory feature requires AWE to be enabled during SQL Server startup. For information, see Hot Add Memory.
Note:
AWE is not required and cannot be configured on 64-bit operating systems.
Since AWE-mapped memory is supported below 3 GB, you can define the min server memory and max server memory values within the physical memory range, or use the default values for both options.
You may consider setting max server memory for SQL Server to guarantee additional memory for other applications operating on the computer. Although SQL Server can dynamically release AWE-mapped memory, the current amount of allocated AWE-mapped memory cannot be swapped out to the page file.
To make AWE available to an instance of SQL Server, use sp_configure to set the awe enabled option to 1, and then restart SQL Server.
For more information about min server memory and max server memory, see Server Memory Options.
Before enabling AWE, you must configure the Lock Pages in Memory policy. For more information, see How to: Enable the Lock Pages in Memory Option (Windows).
February 11, 2010 at 1:19 am
How much memory do you need SQL to allocate?
How much memory is installed on your server?
Which version of SQL are you running? 2005, 2008? Express, Standard, Enterprise?
Need more info please.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
February 11, 2010 at 1:43 am
I am Using An 8GB machine
SQL Server 2000 Enterprize Addition SP4 (32 bit)
SQL Is configured to use up to 7GB
February 11, 2010 at 5:04 am
64 bit SQL will automatically see and possibly use all memory on the host.
The AWE can be enabled on 64bit SQL when you need pages to be locked in memory.
32 bit sql 2000 will can use more than 2gb with AWE enabled (applicable), and the PAE switch (not applicable to you).
For your 32bit SQL to detect the additional memory, you will definitely need AWE enabled.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
February 11, 2010 at 1:12 pm
Thanks
I have Checked wth other sources and they said the same
Configuring the sql to use will be done shortly
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply