Benchmarking SQL Server BlackBox Hosting vs AWS

SQL Server performance benchmarking illustration

WHY AND HOW WE TESTED

Organisations are more data driven than ever. When it comes to analysing data in the cloud, speed, performance and cost are all major factors when choosing your cloud provider.

We used the publicly available TPROC-C HammerDB benchmark tool to conduct performance analysis for Microsoft SQL workloads on a c5.xlarge AWS EC2 instance against a comparable BlackBox Hosting Standard Single Server.

BlackBox Hosting vs AWS benchmark comparison

TEST PARAMETERS AND RESULTS

We created two new virtual machines with only HammerDB and SQL Server 2019 Standard installed. We tested using 4 warehouses and 16 virtual users.

The BlackBox Hosting standard VM achieved a higher transactional throughput than its AWS counterpart. The AWS VM achieved 83,426 NOPM (new orders per minute) and 191,825 TPM (transactions per minute) compared to our BlackBox VM achieving 120,332 NOPM and 277,012 TPM.

By using BlackBox Hosting, you could save over 76% in costs as well as benefitting from almost 45% increased performance to support your data needs.


NEW ORDERS PER MINUTE
BlackBox Hosting vs AWS new orders per minute benchmark
TRANSACTIONS PER MINUTE
BlackBox Hosting vs AWS transactions per minute benchmark
NEW ORDERS PER MINUTE
AWS new orders per minute benchmark
TRANSACTIONS PER MINUTE
AWS transactions per minute benchmark
COST ANALYSIS
BlackBox Hosting and AWS cost comparison

Want to find out more about what BlackBox Hosting could do for you?

Give us a call on +44 02037 407840 to talk through your requirements or email us by clicking here.