AWE Memory
April 28th, 2006 :By Brad McGehee
If you are using SQL Server 2000 Standard Edition
under Windows NT 4.0, Windows 2000 (any version), or Windows 2003 (any
version), or are running SQL Server 2000 Enterprise Edition under the
Standard Edition Windows NT 4.0, Windows 2000, or Windows 2003, or if
your server has 4GB or less of RAM, the “awe enabled
” option should always be left to the default value of 0, which means that AWE memory is not being used.
The AWE (Advanced Windowing Extensions) API allows
applications (that are written to use the AWE API) to run under Windows
2000 Advanced Server or Windows 2000 Datacenter Server (or Windows 2003
Enterprise and Datacenter Editions) to access more than 4GB of RAM.
SQL Server 2000 and SQL Server 2005 Enterprise Edition
(not SQL Server 2000 or 2005 Standard Edition) are AWE-enabled and can
take advantage of RAM in a server of 4GB or more.
If the operating system is Windows 2000 Advanced
Server, SQL Server 2000 Enterprise Edition can us up to 8GB of RAM. If
the operating system is Windows 2000 Datacenter Server, SQL Server 2000 Enterprise can use up to 64GB of RAM.
SQL Server 2005 Enterprise Edition supports AWE
memory, allowing the use of physical memory over 4 gigabytes (GB) on
32-bit versions of Microsoft Windows operating systems. Up to 64 GB of
physical memory is supported.
In order for the operating system and SQL Server 2000
or SQL Server 2005 Enterprise Edition to take advantage of the
additional RAM, two steps must be completed.
Exactly how you configure AWE memory support depends
on how much RAM your server has. To configure Windows 2000 or 2003, you
must enter one of the following switches in the boot line of the
boot.ini file, and reboot the server:
·
4GB RAM: /3GB (AWE support is not used)
·
8GB RAM: /3GB /PAE
·
16GB RAM: /3GB /PAE
·
16GB + RAM: /PAE
The /3GB switch is used to tell SQL Server to take
advantage of 3GB out of the base 4GB of RAM that Windows 2000 supports
natively. If you don’t specify this option, then SQL Server will only
take advantage of 2GB of the first 4GB of RAM in the server, essentially
wasting 1GB of RAM.
AWE memory technology is used only for the RAM that
exceeds the base 4GB of RAM, that’s why the /3GB switch is needed to use
as much of the RAM in your server as possible. If your server has 16GB
or less of RAM, then using the /3GB switch is important. But if your
server has more than 16GB of RAM, then you must not use the /3GB switch.
The reason for this is because the 1GB of additional RAM provided by
adding the /3GB switch is needed by the operating system in order to
take advantage of all of the extra AWE memory. In other words, the
operating system needs 2GB of RAM itself to mange the AWE memory if your
server has more than 16GB of RAM. If 16GB or less of RAM is in a
server, then the operating system only needs 1GB of RAM, allowing the
other 1GB of RAM for use by SQL Server.
Once this step is done, the next step is to set the
“awe enabled” option to 1 within SQL Server 2000 or 2005 Enterprise
Edition, and then restart the SQL Server service. Only at this point
will SQL Server be able to use the additional RAM in the server.
One caution about using the “awe enabled” setting is
that after turning it on, SQL Server no longer dynamically manages
memory. Instead, it takes all of the available RAM (except about 128MB
which is left for the operating system). If you want to prevent SQL
Server from taking all of the RAM, you must set the “max server memory”
option (described in more detail later in this article) to a figure that
limits SQL Server to the amount or RAM you specify. (7.0, 2000, 2005) Updated 1-2-2004
*****
If you find that you are running into a memory bottleneck, and assuming you have the money to spend, SQL Server 2000 and SQL Server 2005 Enterprise Edition can support up to 64GB of RAM
.
How much RAM SQL Server 2000 or SQL Server 2005 Enterprise Edition can
use depends on which version of Windows 2000 or Windows 2003 you are
using and how much RAM your server can support. Assuming your server can
handle it, SQL Server 2000 Enterprise Edition supports up to 8GB under
Windows Advanced Server 2000 and Windows 2003 Enterprise, and up to 64GB
under Windows Data Center for both Windows 2000 and Windows 2003.
Normally, 32-bit CPUs, such as the Pentium family of
processors, can only support up to 4GB of RAM because of its limited
address space. To get around this limitation, SQL Server 2000 and SQL
Server 2005 Enterprise Edition supports a feature called AWE (Address
更多:电脑怎么锁定密码忘了AWE Memory
https://www.002pc.com/diannaojichu/359.html
你可能感兴趣的AWE,Memory