64 bit OS-running 86 bit of SQL SERVER 2005

• arooj300

  Hall of Fame

  Points: 3433

  More actions

  November 26, 2014 at 1:08 am

  #298847

  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: 1004504

  More actions

  November 26, 2014 at 1:27 am

  #1760991

  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