performance 2k vs 2005 1

[SQLScholar]

Hey all,

I have been looking on the net to try and find some information on comparison of speed between 2k and 2k5

Basically on similar spec servers - lets say

3ghz
1.5gb RAM

Which would run quicker?

I would have thought 2k but i have just installed 2k5 onto a test server, and am amazed at the speed our testing suite connects against it.

Is there any comparisons out there?

Dan

----------------------------------------
Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Dr. Seuss

Computer Science is no more about computers than astronomy is about telescopes - EW Dijkstra
----------------------------------------

 

[ptheriault]

Dan,

SQL 2005 has been completely re-written. The query optimizer is more efficiant than the 2000 version. 2005 should be faster than 2000. If you are interested check "Inside Micorsoft SQL Server 2005: The Storage Engine" It's a great book that goes into detail the new query engine.

- Paul

- If at first you don't succeed, find out if the loser gets anything.

 

[Glasgow]

http://www.microsoft.com/sql/prodinfo/compare/tpcc.mspx

contains the words of Microsoft themselves while

http://www.lakesidesql.com/articles/?p=3

suggests that all in the garden may not always be rosey.

 

[mrdenny]

There are no official stats other than what Microsoft has released as it's officially against the NDA to release performance stats.

That said, unofficially I did a little testing, and I saw a 20-30% performance increase when running test code against SQL 2000 and SQL 2005 on like hardware.

This thread thread183-1170932 has some other unofficial info.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com