Sunday, February 19, 2012

64 bit

Hello,
I was wondering what kind of performance increase can I expect if i change
to a 64 bit system running sql server? What kind of problems can i run into
changing to sql 64 bit or only advantages... Are there benchmark tables
available on the internet?
thanks,
Tune-a
That's an interesting question. The advantages and disadvantages exist only
in the light of the context of use.
Since the release of SQL Server 7.0 in 1998, SQL Server has been on the
enterprise fast track, easily clearing the hurdles that hindered the
adoption of earlier SQL Server versions in the enterprise. Support for a
new scale-out technology called distributed partitioned views boosted SQL
Server to the top of the TPC-C rankings for clustered database systems.
(TPC-C is a standard benchmark for database systems, designed by the
Transaction Performance Processing Councilor TPCwhich consists of all the
major database vendors. The TPC-C test measures transactions per minuteor
tpmC.). The new SQL Server 2000 64-bit Enterprise Edition (formerly
code-named Liberty) moves SQL Server even closer to the peaks of enterprise
scalability.
Obviously, the primary requirements for running the 64-bit edition of SQL
Server are 64-bit hardware and a 64-bit OS. For the OS, SQL Server 2000
64-bit Enterprise Edition requires the Windows Server 2003 64-bit Edition,
which runs only on systems built on the new 64-bit Intel Itanium CPU.
Start your reading with this article on MSDN:
Microsoft SQL Server 2000 (64-bit): Intel Itanium Processor Touchstone
http://msdn.microsoft.com/library/de...us/dnsecure/ht
ml/intelitanium.asp?frame=true
Also, visit this external article
http://www.winnetmag.com/Articles/Ar...79/pg/2/2.html
and view Figure 1 which shows performance of SQL 64 bit on different
hardware platforms.
Hope this helps.
Sanchan [MSFT]
sanchans@.online.microsoft.com
This posting is provided "AS IS" with no warranties, and confers no rights.

No comments:

Post a Comment