Microsoft had provided 64-bit support since SQL Srever 2000. So for SQL Server 2000 and SQL Server 2005 DBA always have a choice to choose the 32-bit version and 64-bit version. 64-bit supported hardware is primary requirement. As 32-bit SQL Server can be used on 64-bit architecture machine, so it becomes a matter of choice to choose between the two SQL Server architectures. There are some very specific scenarios in which it becomes highly recommended to use SQL Server 64-bit
- When number of concurrent users and sessions are in thousands
- Database is over 100 GB
- Database is heavily growing
- If going to buy new system, its better to migrate on 64-bit platform rather to adopt it later with more changes required.
Click here to read all posts related to Hardware and OS related to SQL Server