SQL 2000 64 Bit

JHampson

Member
Has anybody here tried OW Xe on Microsofts SQL 2000 64 bit server. We are looking to upgrade our main server and would like to go to 64 bit for speed but the help line just say that if you try it, it's at your own risk. Any comments or if you have tested it and how well it worked would be appriciated.
 
While 64-bit is helpful for OLAP (analytics) type activities, my reading indicates that you will get a bigger bang for you buck on OLTP (such as EnterpriseOne) with 16-way or 32-way Xeon processors.

Other things to consider:
* You cannot run JDE Logic directly on the SQL Server. This may force the addition of 32-bit JDE logic server(s).
* Third party products may not have 64-bit versions. Verify your backup software.
* DTS packages cannot run directly on a 64-bit server. However they can be executed on a 32-bit server to manipulate data on the 64-bit server.
* Other 64-bit SQL limits (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sql64/ad_clustering64_8kx3.asp)
 
Back
Top