SQL Server 2008 - 64 bit or 32 bit Server?

• SQLBrady

  Ten Centuries

  Points: 1015

  More actions

  February 6, 2009 at 6:50 am

  #383885

  So, I hear rumors that SQL Server 2008 can only be installed on 64 bit servers? (2008 or 2003) However, I have SQL 2008 installed on two 32 bit servers 2003 servers. What's the deal with this and are their any limitations if it's installed on a 32 bit server

• K. Brian Kelley

  SSC Guru

  Points: 114703

  More actions

  February 6, 2009 at 7:24 am

  #939502

  It will install on 32-bit. The main limitation is the amount of memory that can be used. Therefore, with current hardware being both 32 and 64-bit capable, I'm not sure there's a compelling reason to stay 32-bit.

  K. Brian Kelley
  @kbriankelley

• Grant Fritchey

  SSC Guru

  Points: 399009

  More actions

  February 6, 2009 at 8:10 am

  #939549

  Yeah, that's pretty much my understanding too. Better & more memory management in the 64bit operating system, which benefits SQL Server.

  I don't know where you heard that it's 32-bit only because that's patently false.

  "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