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.
Join the conversationComment
Share
Comments
Results
Contribute to the conversation