SQL Server Performance

64-bit SQL Server

Discussion in 'Performance Tuning for Hardware Configurations' started by sdcsql, Apr 13, 2005.

  1. sdcsql New Member

    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!
  2. Luis Martin Moderator

    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.



  3. satya Moderator

    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.
  4. sdcsql New Member

    Thanks guys! Can't wait for SQL Server 2005 then..
  5. adam12hicks New Member


    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

Share This Page