Do I Need 64 Bit SQL Server

When moving to SQL 2005 from 2000, some customers are asking what real benefit 64 bit brings. The short answer is :

- 64 bit is the future - rumours are abound that future releases of SQL Server might not even have a 32 bit sku (except developer editions, etc).

- Virtually No OEM is making servers which are not 64 bit capable.

- 64 bit gives performance and headroom benefits, especially with RAM.

- 32 bit is soooo nineties, it just doesn't look nice in your server room.


Here is a great blog diving into some of the technical benefits:

I always recommend 64 bit, unless a SQL Server is a "jack of all trades" box with lots of other applications or components installed that might not play nice.