/3Gb, AWE and PAE switches

• SQL_Hunt

  SSC-Dedicated

  Points: 33518

  More actions

  May 30, 2012 at 10:30 am

  #262281

  Hi Guys

  Can anybody please explain in details with some clear ideas about the significances of the 3 switches in boot.ini file in terms how it improves performance and if there is any negative aspect?

  /3Gb, AWE and PAE switches

  Thanks.

• M&M

  SSC-Insane

  Points: 21700

  More actions

  May 30, 2012 at 10:42 am

  #1494785

  Second chapter of this book :SQL Server 2008 Internals & Troubleshooting has it all. I guess you should read that chapter.

  M&M

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738632

  More actions

  May 30, 2012 at 10:44 am

  #1494787

  Are you running x86 (32 bit)? If not, don't worry.

  If you are

  http://blogs.technet.com/b/rob/archive/2008/05/15/windows-memory-and-sql-server.aspx

  http://msdn.microsoft.com/en-us/library/ms175581(v=sql.105).aspx

• Gail Shaw

  SSC Guru

  Points: 1004514

  More actions

  May 30, 2012 at 11:11 am

  #1494797

  Chapter 4 of this: http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass