SQL Server Performance Forum – Threads Archive

64-bit SQL Server

Hi, We have just received some IBM xSeries 346 Wintel servers with dual Xeon EM64 processors. Can anyone confirm if SQL Server 2000 would be able to run 64-bit? What about SQL Server 2005? I’m suspicious for the 2000 version but couldn’t find the information yet. Any reference site would be great. Thanks!

Check: http://www.sql-server-performance.com/sql_server_64_bit.asp
Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided â€œAS ISâ€ with no warranties for accuracy.

http://www.microsoft.com/sql/64bit/default.asp for complete information on 64 bit product. I don’t see any issues for SQL server 2005 and you need to wait until its full release. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Thanks guys! Can’t wait for SQL Server 2005 then..

The EM64 procs are nice, but certainly do not have the cache and bandwidth of the true Itanium chips. Plus it doesn’t do the same level of on-die ECC checking. Of course, if the price is right, then it’s a good introduction into 64-bit. It at least gives you the benefit of memory addressability without the penalty of AWE and the corruption risks of PAE. We’re going to be supporting 64-way EM64 machines as well as 64-way Itaniums over the next year. 2Tb of RAM will not be unusual! You cannot use the current build of SQL2k 64-bit with the EM64 chipsets, and I’ve been told that there will be separate codesets for each. Good luck with the new toy!
Adam —————–
Adam Hicks
Windows Datacenter Certified Professional
Unisys Corporation
Dallas, TX

]]>