64 bit OS-running 86 bit of SQL SERVER 2005

  • arooj300

    Hall of Fame

    Points: 3433

    Hi All,

    I have bit confusion. In the Windows Server 2003 SP2 64 Bit , SQL Server running 86 bit.

    Is there any impact on application performance or any disadvantage to have two different version . Or I need to install same bit in the Server.

    Please clarify me.

    Thanks in advance

  • Gail Shaw

    SSC Guru

    Points: 1004446

    It'll work. It's not ideal. You have all the limitations of the 32-bit SQL Server with regard to memory. You really should be using 64 bit these days (where 'these days' means the last about 10 years)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 2 (of 2 total)

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