February 14, 2009 at 8:52 am
Can some one provide step by step process to enable the AWE in sql 2005 please? Thanks
Those three steps which needs to be able to use AWE on your SQL Server.
Add the /PAE switch to boot.ini to allow Windows 2000/2003 to access more than 4 GB of memory
Grant "Lock Pages in Memory" to the user account that runs the SQL Server process
Check the checkbox in the SQL Instance properties to allow AWE.
February 14, 2009 at 9:03 am
what is your system configuration?
Check this out:
http://msdn.microsoft.com/en-us/library/ms190731.aspx
February 14, 2009 at 1:58 pm
This is part of my particular checklist for that...
enable /3GB switch if x32 and RAM >= 4GB and <= 8GB
enable /PAE if x32 with > 4GB RAM
enable sql svr AWE if x32 with > 4GB RAM
Ensure boot.ini parameter /USEPMTIMER is present on AMD64 systems (http://support.microsoft.com/kb/895980)
Set Advanced Performance Option->Processor scheduling: Best Performance of Background Services
Set Advanced Performance Option->Memory usage: Best Performance of Programs
Disable Hyperthreading
February 16, 2009 at 2:10 am
Most modern servers with a default install of w2k3 R2 do not require the /pae switch as DEP allows full access to the memory. set your max memory and set awe = on in sql - either with t-sql or gui and the memory will be being used.
I'd keep clear of the 3GB switch. awe memory can be used with >2gb of memory, the 3GB / pae is a sort of incorrect myth; and the switches do totally different things.
Hyperthreading has nothing to do with memory settings.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply