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-21 : 13:26:54
|
| I have a basic doubtI have sql server 2005 enterprise edition on windows server 2003.I have 32 gb of memory.by default how much memory will be taken by sql serverI think we need to enable AWE switch. Is it correct |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-05-21 : 13:35:46
|
| 64-bit or 32-bit? By default, SQL will use as much memory as it needs.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 |
 |
|
|
thaniparthi.rao
Yak Posting Veteran
96 Posts |
Posted - 2008-05-21 : 13:53:36
|
| 32 bit |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-05-21 : 13:57:02
|
| You've been given the 32-bit answer in your other post. For 64-bit, the AWE option does not need to be enabled.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 |
|
|
|
thaniparthi.rao
Yak Posting Veteran
96 Posts |
Posted - 2008-05-21 : 13:58:30
|
| Thanks for the reply.If it uses as much memory as it needs then why these AWE option and 3gb ,PAE switches. Is there any need to enable these options |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-21 : 14:37:28
|
| you have to enable lock pages in memory and enable AWE ,so you can get more memory in 32-bit system. Remember if you have other instance running or other applications are running then you have to set max memory for SQL server so other can get memory as they want. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-21 : 22:20:48
|
| >> why these AWE option and 3gb ,PAE switches. Is there any need to enable these optionsYes because 32-bit OS can only address 4gb directly. PAE let 32-bit os address more than 4gb by address mapping, and awe let sql uses memory above 4gb range. By default, user mode apps can only use lower 2gb memory. Switch 3gb let certain user mode apps like sql server to use 1gb memory in upper 2gb range. |
|
|
|
|
|
|
memory