SQL Server 2005 32-bit on Windows 2008 R2 x64 OS

Question

SQL Server 2005 32-bit on Windows 2008 R2 x64 OS

Viewing 4 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

george sibbald SSC Guru Points: 104210 More actions · Answer 1

you can use AWE with 32bit SQL on a 64bit OS.

http://sqlblog.com/blogs/argenis_fernandez/archive/2012/12/30/the-myth-around-32-bit-sql-server-instances-on-64-bit-operating-systems-and-awe.aspx

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

Orlando Colamatteo SSC Guru Points: 182293 More actions · Answer 2

Just in case, because the article is not very clear on this point, if you enable AWE in the SQL Server instance you should absolutely set max server memory using sp_configure:

EXEC sys.sp_configure

@configname = 'max server memory (MB)',

@configvalue = ####; -- something sensible that leaves memory for the OS to operate

GO

RECONFIGURE;

GO

There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato

SQL Show SSCertifiable Points: 6143 More actions · Answer 3

along with AWE, you have to use PAE in boot.ini to reveal physical ram more than 16gb.

Orlando Colamatteo SSC Guru Points: 182293 More actions · Answer 4

SQL Show (4/23/2013)
along with AWE, you have to use PAE in boot.ini to reveal physical ram more than 16gb.

PAE is not a valid boot.ini configuration on 64-bit OSes.

There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato