Thursday, November 26, 2009

AWE SQL Server 2005 

To turn on AWE, there are three steps:
  1. Add the /pae switch to boot.ini to allow Windows 2000/2003 to access more than 4 GB of memory
  2. Grant “Lock Pages in Memory” to the user account that runs the SQL Server process
  3. Set the configuration setting “AWE Enabled” to 1.


sp_configure 'show advanced options', 1 RECONFIGURE GO  sp_configure 'awe enabled', 1 RECONFIGURE GO


sp_configure 'min server memory', 1024 RECONFIGURE GO  sp_configure 'max server memory', 6144 RECONFIGURE GO
Posted by at

1 comment:

  1. AnonymousAugust 4, 2010 at 4:31 AM

    you can quickly reproduce the repair database mdf process with another utility for data recovery

    ReplyDelete

Subscribe to: Post Comments (Atom)