:::: MENU ::::

Scenarios when SQL Server 2000/2005 64-bit is recommended

  • Oct 27 / 2008
  • 0
DBA Interview questions, dbDigger, Hardware and Platform, Performance Tunning and Optimization

Scenarios when SQL Server 2000/2005 64-bit is recommended

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

Consult us to explore the Databases. Contact us