SQL Server - AWE question

Asked By pardhiveswar via SQLMonster.com

25-Jan-10 07:21 PM

HI,

we have windows server 2003 enterprise edition 64-bit and sqlserver 2005 32-
bit enterprise

do we need to enable AWE for sqlserver 32-bit.

our developers are complaining about the performance is very slow compared to
dev & qa environments..

our qa & dev environments does not enable AWE..

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-security/201001/1

25-Jan-10 10:10 PM

Why are you using 32 bit sql if the OS is 64bit?  Use 64 bit and you can
access all the memory.  But with 32 bit SQL on 64bit OS you need AWE to use
more than 4GB if you set the /3GB switch.

--

Andrew J. Kelly   SQL MVP
Solid Quality Mentors

26-Jan-10 02:44 PM

BUt we have almost 64 GB RAM do we need still need AWE enable for 32-bit
sqlserver 2005.

in future we will upgrade to sql2k8 64-bit..


--
Message posted via http://www.sqlmonster.com

26-Jan-10 11:12 PM

pardhiveswar via SQLMonster.com (u8956@uwe) writes:

If you want to use all that RAM in SQL Server, yes, you need to enable
AWE.



--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

26-Jan-10 08:34 PM

Only 64 bit apps can access memory above 4GB without AWE even though the OS
can.

--

Andrew J. Kelly   SQL MVP
Solid Quality Mentors

27-Jan-10 12:32 PM

THanks  Erland & Andrew


--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-security/201001/1