SQL Server Performance

Setting up a new server - 32 or 64 bit?

Discussion in 'Performance Tuning for Hardware Configurations' started by kenp2600, May 29, 2007.

  1. kenp2600 New Member

    I am setting up a new server with SQL 2000 and Windows Server 2003 R2. It is an Intel dual quad-core processor system with 8 gig of RAM.

    Should I install the 64 bit version of the OS or stick with the 32 bit version that I use on my old servers. Will I see any difference in performance? Will I see any functional differences?

    Thank you!
  2. satya Moderator

    I don't see any specific reason to go for 64 bit in this case, having the sensible database optimization and physical resources on the server 32 bit performs very well.

    Also you may need tothink about having Enterprise edition of SQL to take advantage of more than 2gb memory in this case.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

Share This Page