SQL Server 2005 and AWE

• MaxDD

  Old Hand

  Points: 380

  More actions

  November 1, 2011 at 12:13 pm

  #262186

  Hello,

  I have Windows 2003 R2 Enterprise Edition 32-bit and Windows SQL2005 Standard Edition 32-bit with 8 GB RAM on Server in VMWare. Which the OS see the 8 GB without having to add Switch to the boot.ini.

  [boot loader]

  timeout=30

  default=multi(0)disk(0)rdisk(0)partition(1)\WINDOWS

  [operating systems]

  multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="WindowsServer 2003, Enterprise"/noexecute=optout /fastdetect

  My question is do I need to add /AWE to the boot.ini for me to use AWE in SQL Server 2005 and also do I need to Enable the Lock Page in Memory Option.

  For me to run the following script.

  sp_configure 'show advanced options', 1

  RECONFIGURE

  GO

  sp_configure 'awe enabled', 1

  RECONFIGURE

  GO

  sp_configure 'max server memory', 6144

  RECONFIGURE

  GO

  Thank you

• Sean Lange

  SSC Guru

  Points: 286590

  More actions

  November 1, 2011 at 12:41 pm

  #1401787

  Please don't cross post. Direct all replies here. http://www.sqlservercentral.com/Forums/Topic1198847-146-1.aspx

  _______________________________________________________________

  Need help? Help us help you.

  Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

  Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

  Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
  Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
  Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
  Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/