Insufficient data from Andrew Fryer

The place where I page to when my brain is full up of stuff about the Microsoft platform

SQL Server 2008 Performance

SQL Server 2008 Performance

  • Comments 2
  • Likes

It is already possible to get an indication of how well SQL Server 2008 will perform before it is released as there already some TPC benchmarks published for it.  The performance of Integration Services has been separately tested, as have a number of applications such as Microsoft Dynamics and SAP.  The links to all of the tests can be found here

These figures should improve slightly as all of the code is cleaned up closer to release, but this work has been possible because of the very different way that SQL Server 2008 was developed.  Each feature was only included in a given CTP when it was pretty much working. This has also made early adoption a lot less painful as by and large a feature has remained unchanged once it was included in a CTP.

Of course your applications are all different and although benchmarks try and emulate the real world, they are no more than indicators like 0-60mph times for cars

Technorati Tags: ,,

.  So try the latest SQL Server 2008 CTP on your applications and see what it does for you.

Comments
  • Over the weekend one of the many Davids I count among my friends mailed me a curious job title from his

  • I've ran some tests on SQL 2008 binary performance in comparison to SQL 2005. The outcome was that the new filesteam column type rocks! Read more here: http://blog.sallarp.com/2008/09/sql-2008-binary-data-performance/

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment