How can we let SQL Server 2005 X86 recognize and use RAM greater than 4GB

  • 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 ?

     

     

    Attachments:
    You must be logged in to view attached files.
  • 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

    The Scary DBA
    Author of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd Edition
    Product Evangelist for Red Gate Software

  • 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/

  • Michael L John wrote:

    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

  • 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 5 (of 5 total)

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