July 18, 2011 at 1:16 pm
Two DBA's are talking and one says that since SQL is running using a service account it is not necessary to enable AWE or Lock Pages in Memory on a 32 bit system. The other DBA says "What!! of course you do" who is correct?
July 18, 2011 at 1:18 pm
July 18, 2011 at 1:44 pm
4 Gig is the cut-off that 32-bit can address without help. AWE is necessary beyond that. Or go 64-bit and ignore the whole thing. The first DBA is wrong.
Details here: http://technet.microsoft.com/en-us/library/ms175581.aspx
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
July 18, 2011 at 2:26 pm
The first DBA is wrong - you cannot even enable AWE on a 32-bit machine without setting the lock pages in memory right for a service account. Unless you also are not following best practices and including the service account in the local Administrator's group.
If you are doing that, then no - you do not have to set the lock pages is memory right to enable AWE. But, you still have to enable it to get access to anything over 4GB of memory.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 19, 2011 at 12:44 am
The actual limit is 2 GB. the 4 GB is split into parts with a 2GB shared kernel and the remaining 2 GB dedicated to the application.
By enabling the PAE switch in boot.ini file we can reduce the shared kernel to 1 GB and allocate up to 3Gb to the application.
July 19, 2011 at 1:10 am
This has always been my ref concerning AWE ...
AWE Memory by Brad McGehee[/url]
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
July 20, 2011 at 6:36 am
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply