Freigeben über

March of the benchmarks continues

  • Artikel

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

  • Anonymous
    December 02, 2005
    Do any of these TPC benchmarks use .NET ?
  • Anonymous
    December 02, 2005
    "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. ;)
  • Anonymous
    December 04, 2005
    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
  • Anonymous
    December 07, 2005
    The comment has been removed
  • Anonymous
    December 07, 2005
    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.
  • Anonymous
    May 31, 2009
    PingBack from http://portablegreenhousesite.info/story.php?id=1274