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 |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2011-06-03 : 06:26:11
|
| Hi Team,i saw an email from one of my team members and got confused. Enabling AWE will be disadvantage in 64Bit???can you please answer meArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-06-03 : 06:28:19
|
| The AWE setting is completely ignored on 64 bit.--Gail ShawSQL Server MVP |
 |
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2011-06-03 : 06:29:56
|
| Thanks,my question is if it is enabled, is there any disadvantage?the comment i heard is "This will cause LOTS of page file usage"is that true? and is that a disadvantage?ArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-06-03 : 06:53:54
|
| http://msdn.microsoft.com/en-us/library/ms190673.aspx>> AWE is not required and cannot be configured on 64-bit operating systems.>> This feature will be removed in the next version of Microsoft SQL Server. Do not use this feature in new development work, and modify applications that currently use this feature as soon as possible.buthttp://blogs.msdn.com/b/slavao/archive/2005/04/29/413425.aspxBut that is quite old.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-06-03 : 08:46:56
|
| AWE has absolutely NO effect whatsoever on a 64-bit instance. No effect, no behaviour changes. It's completely ignored by the engine.--Gail ShawSQL Server MVP |
|
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2011-06-03 : 09:08:43
|
| Thanks a lot :)ArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
|
|
|
|
enabling AWE in 64 bit is disadvantage???