Step 5: Take advantage of 64-bit

If you can afford it, purchase a server that supports 64-bit architecture. SQL Server 2000 tests have shown at least a 20% improvement in 64-bit SQL Server performance over a 32-bit architecture, although your results may vary depending on your workload.

Keep in mind that SQL Server 2000 64-bit version does not offer the same functionality as SQL Server 2005 64-bit. For instance, there is no 64-bit DTS (Data Transformation Services), no DOS support and no sp_OA procedure support. In addition, some third-party vendors have not provided 64-bit OLE-DB drives and there are no 64-bit iFilters for SQL FTS (full-text search). It is clear that 32-bit architecture is swiftly moving to obsolescence with the performance improvements of the 64-bit architecture.

Spec your SQL Server hardware needs

 Home: Introduction
 Step 1: Invest in good application design
 Step 2: Understand your workload
 Step 3: Know your memory support limitations
 Step 4: Choose a reliable hardware brand
 Step 5: Take advantage of 64-bit
 Step 6: Take advantage of storage area networks
 Step 7: Properly configure your RAID arrays
 Step 8: Use separate disk controllers
 Step 9: Choose and optimize your disks wisely
 Step 10: Optimize CPU activity and speed