Database performance is much a bit like a major sport, there's a governing body, the Transaction Processing and Performance Council (confusingly abbreviated to TPC) and they set the competition rules and judge the results. Unlike most sports there's no season and entrants can compete at any time, using the latest combination of hardware and software. There are four main benchmarks in use but only three apply to comparisons of the back-end database:
The only ray of sunshine for SQL Server here is the newer TPC-H benchmark, but does any of this matter in the real world. Apparently not because everyone seems to want to virtualise SQL Server and other database to make them more manageable and this is always going to be at the expense of performance. So perhaps TPC will introduce TPC-V to measure this!
PingBack from http://geeklectures.info/2007/12/27/on-the-third-day-of-christmas-an-it-pro-sent-to-me/
Each morning since Christmas I've enjoyed reading Andrew's blog to see his latest nth day of Christmas