Performance evaluation of SQL 2008 katmai vs SQL Server 2005

Hi All,

We have conducted a performance test on SQL 2008 katmai CTP, comparing the same test results with SQL Server 2005. The details of test conducted are:

• We had created a database and populated data (DB size is 4 GB)
• We were retrieving a resultset based on a perticular filters. The output is three result sets (total of above 500-600 records)
• The environment was windows2003 server and only SQL Server 2008 was running. We did profiling from other machine.
• Ran a small application that simulates the concurrent testing ranging from 1 to 250 users (for the same amount of data) from the same machine where SQL Server 2008 is running.

Surprised to see the results with katmai are not all good. We collected duration, CPU and IO for both 2005 and 2008. 2005 was 50% less on these statistics. (2008 is supposed to perform better right with same system resources.)

Did anybody face this kind of situation? Are the results not good because of it being CTP?

Your inputs are highly appreciated.

Thanks,

Siva

[1172 byte] By [Sivakumarchillara] at [2008-1-10]