SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


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


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

Author
Message
chrishuffman5
chrishuffman5
SSC Rookie
SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)

Group: General Forum Members
Points: 31 Visits: 72
Before I get started, I'm well aware that this type of setup is bizarre and I definitely did not recommend. I work in a corporation where the application vendor demanded 32-bit SQL 2005 and now they are paying for their decision because the instance is only able to use 2GB of address space on a physical server that has 120GB of RAM. The instance is now constantly swapping pages of memory every 200 seconds.

This was one of many sql installs that we had to do for a large project on a strict deadline, so we didn't have as much time to look into this install. I had assumed the the Windows team and Application team had the correct server configuration when we did the install. I knew that the AWE switch was available for 32-bit SQL, but overlooked that we were installing on a x64 OS.

With that said, I've done some research and found that you can allow SQL to use up to 4GB RAM by setting the \LARGEADDRESSAWARE:YES flag. This makes sense because I've done this with video editing applications years back, but what I've not been able to find is where I set this flag for sql server. I've also read somewhere else that sql server already has the flag built into the application, so this search has gotten pretty confusing.

Is this an option that needs to be setup on the service as a startup parameter or is this a boot.ini configuration? I've researched both options and neither seem to be the answer for setting the \LARGEADDRESSAWARE:YES flag. I understand it's an odd setup so many of us SQL DBA's are going to have limited to no experience with this configuration, but I'm hoping someone out there can shed some light on this issue.
george sibbald
george sibbald
SSC-Insane
SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)

Group: General Forum Members
Points: 24924 Visits: 13698
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
Orlando Colamatteo
SSC-Forever
SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)

Group: General Forum Members
Points: 40192 Visits: 14413
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
SQL Show
SSCommitted
SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)

Group: General Forum Members
Points: 1529 Visits: 1078
along with AWE, you have to use PAE in boot.ini to reveal physical ram more than 16gb.
Orlando Colamatteo
Orlando Colamatteo
SSC-Forever
SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)

Group: General Forum Members
Points: 40192 Visits: 14413
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search