March 25, 2021 at 9:42 am
I have a windwos server 2003 R2(64bit) installed SQL Server 2005 X86 Standard Edition .
I have enabled AWE(as screenshot), and restarted windows server, but when I ran SQL Server (even if I ran the complicated computation). system can't use the RAM greater than 4GB. because as some reason we can't upgrade SQL server from 2005 to 2008 or other higher version ?
How can we let SQL Server 2005 X86 recognize and use RAM greater than 4GB ? thanks!
if we use a 64x to register SQL server ,can SQL server be upgraded from 32bit to 64bit ?
March 25, 2021 at 11:19 am
I'm going to be as honest as possible. I don't remember how 2005 works any more.
However, yes, you absolutely can upgrade SQL Server to 64bit on 2005. Doing so changes memory configurations and should have no trouble using all the memory. Just disable the /3GB switch, it causes problems on a 64 bit OS.
Beyond that, hopefully someone around still has active knowledge of this 16 year old software.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 25, 2021 at 3:12 pm
You can only upgrade 2 versions. So, 2005 you can do an in-place upgrade to 2008 or 2008 R2.
BUT, guess what. 2008 and 2008 r2 are also no longer supported.
I have a 2005 box that I need to keep alive. What's preventing you from upgrading?
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
March 26, 2021 at 12:29 am
You can only upgrade 2 versions. So, 2005 you can do an in-place upgrade to 2008 or 2008 R2.
BUT, guess what. 2008 and 2008 r2 are also no longer supported.
I have a 2005 box that I need to keep alive. What's preventing you from upgrading?
Dear Michael L John,
as there is an ERP system, but nobody knows how to do the configuration if we upgrade SQL Server 2008 or 2008 R2
April 2, 2021 at 6:19 pm
There is a discussion on what you can do at https://github.com/SQL-FineBuild/Common/wiki/SQL-Server-Memory-Management
The SQL db engine can be given access to more than 4gb memory via AWE even if itcannot address it directly. All other components (SSAS etc) are limited to 4gb and must share that memory with everything else that is running.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply