Compare 2000 with 2005 Performance - 32/64 Decide to buy?

I need to show my boss that 2005 will on average be faster than 2000.

Are there any performance benchmark results available to show this?

Also I need similar benchmarks to show 64 bit will be faster than 32 bit SQL 2005.

Ian

Try:

http://download.microsoft.com/download/a/4/7/a47b7b0e-976d-4f49-b15d-f02ade638ebe/SQLServer2005_WhyUpgrade.doc

|||I'm looking specifically for the answer to," Why move to 64 bit from 32 bit"

The document is good, but only addresses moving from 2000 to 2005 and not justification of moving hardware to 64 bit.

Ian

|||The main reason to go 64bit is better memory performance for large amounts of memory (ie 16gb+), and better CPU performance for 64bit applications. The other reason is, everything will be 64bit at some time. It is the future.

Now the problems. The main problem you will have with 64bit is with ODBC drivers and other 3rd party drivers not supporting 64bit.

Before you even entertain the idea of changing, check to make sure everything you run on the server is compatable and SUPPORTED in Windows 2003 64bit.

|||

FYI

I have a few 2005 (SS2k5 x64) installs and many 2000 (SS2K x32) installs.

Last evening a developer emailed and said her select was taking to long to run, 22 minutes on the SS2K x32. I cut\pasted her select and executed it on a new X64 Sql Server 2005 SP2 (3050). The databases are identical as the X64 will be her new Sql server.

The sql ran in 36 seconds.

I look good

|||

See if this helps:

http://www.microsoft.com/sql/editions/64bit/default.mspx