March of the benchmarks continues


Just because we have shipped and launched (well in some of the world) SQL Server 2005 RTM does not mean we stop improving the system and working on benchmarks. The SP1 benchmark window has opened up so the first of the new marks have been published.


First up is a TPC-C with 64 way Itanium 2 on HP Superdome


Next we have TPC-C with 16 way x64 on IBM eServer XSeries


Its truly amazing how far the software and hardware has come in the last few years, the first SQL Server benchmark I remember was a scale out (clustered) using SQL Server 2000 and achieved 225,000 as a transaction count ( I still have the plaque we all got after the result), and using 96 procs. Assuming linear scale(which is not really valid for anything except a blog entry) that number could be achieved with just over 7 procs from the IBM box, a little over 5 years later.


More to come in the next few months.


 


Updates: The number of procs was 96, not 92 (they were Xeon 550s if you are interested), also turned into english the sentence about the plaque, from whatever language I originally wrote it in.

Comments (6)

  1. Matt says:

    Do any of these TPC benchmarks use .NET ?

  2. chris says:

    "I still have the plaque we all got after the result, on my desk."

    I had to think about that statement for a bit, before it made sense. It’s too early in the morning, I guess. 😉

  3. euanga says:

    Matt,

    I had a quick look at the disclosure doc and it appears not.

    If your question is about the code inside the sever that performs the transactions, then TPC-C is pretty much a worst case scenario for SQLCLR. The operations are purely data related, there is no leverage of the .NetFX in any of the transactions, no security/sandbox advantages etc. So in the current release of SQLCLR we would not advise anyone build this in SQLCLR code.

    -Euan

  4. Matt says:

    Hi,

    Thanks for the reply, sorry about the inital "brief" question.

    As to a follow-on question, will we ever see a TPC-C benchmark that uses .NET with the server source code? Reason for the question is that essentially Microsoft is pushing .NET, and hence from an investment bank perspective, it would be helpful to have .NET benchmarks, since Microsoft wants CSFB, JP Morgan, etc to write their trading systems in C# or any other CLR language, and most front office trading systems deal with a high volumn of transactions per hour per day.

    Later

  5. euanga says:

    Matt,

    Again I’m not sure exactly what you mean about "server source code", if you mean SQLCLR ie SPs written in CLR languages then per my previous response, not soon. If you mean for the client code or the TP Monitor piece then yes at some point we will likely do this.