sql 2005 server has 3gb memory, do i need to enable awe

• ColinChen

  SSC-Addicted

  Points: 414

  More actions

  September 4, 2010 at 11:12 am

  #142673

  I am confused about AWE. My sql 2005 server has 3GB memory, do I still need to enable AWE.:-P

  C.G

• SQLBuddy123

  One Orange Chip

  Points: 28294

  More actions

  September 4, 2010 at 11:53 am

  #1216558

  What is the Memory size on the Windows server and is your SQL server 64-bit ?

  Thank You,

  Best Regards,

  SQLBuddy

• george sibbald

  SSC Guru

  Points: 104210

  More actions

  September 4, 2010 at 1:04 pm

  #1216562

  AWE only comes into it if you have more than 4GB memory and you are using 32 bit.

  ---------------------------------------------------------------------