Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
thaniparthi.rao
Yak Posting Veteran
96 Posts |
 Posted - 2008-05-19 : 11:42:06
|
| I have a small doubt.If we enable AWE option we can have advantage of available physical memory.we can have more memory by using max server memory property.then why this AWE option comes in to picture.I read bol but iam not able to understand what exactly happens.Could any one tell me why this AWE option if we have max server memory property. |
|
|
sqldba20
Posting Yak Master
183 Posts |
Posted - 2008-05-19 : 11:58:47
|
| An x86 server system can manage a maximum of 4 GB of memory. This limits the addressable memory space for Windows server 2003 systems to 4 GB. (This is true for all 32-bit operating systems). With 2 GB reserved for the operating system by default on 32-bit Windows, only 2 GB of memory remains for SQL 2000 or SQL Server 2005 x86. You can increase this amount to 3 GB by setting a /3GB switch in a Windows BOOT.INI. In order to use more than 4 GB of memory AWE must be enabled. AWE is a set of memory management extensions to the Microsoft Win32 API that allows SQL Server x86 to address memory beyond 4 GB. Using AWE, applications can acquire physical memory as nonpaged memory, and then dynamically map views of the nonpaged memory to the 32-bit address space. AWE enables SQL Server 2000 and 2005 x86 to address larger amounts of data. Now, this is old news, everybody knows that. |
 |
|
|
thaniparthi.rao
Yak Posting Veteran
96 Posts |
Posted - 2008-05-19 : 12:04:16
|
| Thanks for the answer.Then where this max server memeory property will be used |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-19 : 12:46:33
|
| you use it when you have other apps running in SQL server. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-05-21 : 13:48:25
|
| You'll also use the max server memory setting on each of the instances in a cluster.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-21 : 22:32:09
|
| Sql2k doesn't manage memory dynamically when awe is enabled, you have to set max memory to leave enough memory for os and other processes. |
|
|
|
|
|
|
AWE OPTION