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 Microsoft Azure Standard F4s v2 VM against a comparable BlackBox Hosting Standard Single Server.
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 Azure counterpart. Microsoft Azure’s VM achieved 76,058 NOPM (new orders per minute) and 174,990 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 60% in costs as well as benefitting from almost 60% increased performance to support your data needs.
NEW ORDERS PER MINUTE
TRANSACTIONS PER MINUTE
COST ANALYSIS
