SQLServerCentral Editorial

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.

Rate

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

Share

Share

Rate

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating