Pay for Performance

·

There’s a new TPC-H benchmark from Microsoft; this one running on cloud infrastructure in Azure. It’s the top-performing SQL Server benchmark at the 1TB level, getting to 1,667,428 QphH (roughly queries per hour). This value exceeds the next highest on-premises setup from HPE, which has 1,531,016 QphH@1000GB. This is the 2nd-ranked TPC-H benchmark, though the top slot is from an Exasol database.

Notably, the benchmark comes in at $558.17 in the Price/QphH price performance column. The other SQL Server systems are in the $200-ish range (from $192.37 to $263.13). That’s quite a difference in price, and it might dissuade some of you from moving to the cloud instead of running a large on-premises setup. That’s a point of concern, especially as the cost of the cloud has become an issue in many organizations.

There’s a blog post from Pam Lahoud that outlines the effort to get this benchmark audited and approved. Part of the post notes that the rules for the benchmark mean that public pricing needed to be used. This is the spot, pay-as-you-go pricing, which is the most expensive rate. The storage was also configured with the maximum capabilities, which weren’t needed. She notes that the hybrid benefit for moving licenses isn’t available, which I’m not sure makes much of a difference, but it might. Pam does note that the licensing was priced at 3 years of the Pay-As-You-Go level, which is 2/3 of the cost.

There are likely ways to optimize costs, and there is the promise of a future blog that covers how you might size and price what you need for a workload. I’m sure there are savings to be had, though it remains to be seen if you could get a price lower than that of the on-premises systems. Don’t forget that the on-premises systems might have other savings from a different approach there as well.

The cloud, in many cases, is expensive. If you want to get great performance out, then the people whose computer you decide to rent will likely charge you a premium. Perhaps you can gain some savings with flexibility, shutdowns, resizing, and more, but that really depends on your being able to take advantage of the flexibility of the cloud. If you have a steady workload, or one that has to run most of the time, you’ll likely be paying quite a bit.

Steve Jones

Listen to the podcast at Libsyn, Spotify, or iTunes.

Note, podcasts are only available for a limited time online.

Comments

One response to “Pay for Performance”

  1. bluecollarcritic Avatar
    bluecollarcritic

    With each passing day/week/month/year I see my concerns about the cloud that I’ve had from the start confirmed. They marketed the cloud as the be all end all for every business users needs from the largest enterprise to the smallest business and the cloud is not really capable of doing that. This past week when my company which relies entirely on Microsoft, was w/o all forms of communication all day long. The heads in our company made this choice to save a few nickels and its day like last week that show that the cloud is not this might do it all wonder its been marketed as.

    I realize I sound like a broken record but its so frustrating to see how many so quickly forget about the down time once the systems are back up and running. If this can happen for a day it can happen for longer and how long can the business world function like that?

    My company spent thousands (probably 10s of thousands) on some custom process that was cloud based via MS Power automate and now because the other cloud vendor we use (who hosts our main accounting software and is not MS ) made changes that thing will no longer work and so its being trashed., 10s of thousands wasted where as if we had things on prem and did it locally we’d not have those kids of problems. The cloud should be treated as simply another optional tool and not the final stop for all your digital needs.

    Its going to be REAL interesting to see how things play out once one of these tech bros finally achieves general AI and it gets loose and that will happen eventually. Even those racing to be the first have raised fears/.concerns about this and yet its not slowed them down. Its like a mad rush to the end of everything. When i weas younger and read those SciFi stories about an AI taking over like Terminator I thought there’s no way humans would be stupid enough to create such a thing and yet here we are.

    Like

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.