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 2022 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 60,673 NOPM (new orders per minute) and 140,520 TPM (transactions per minute) compared to our BlackBox VM achieving 134,214 NOPM and 312,085 TPM.
By using BlackBox Hosting, you could halve your costs as well as benefitting from over 75% increased performance to support your data needs.
NEW ORDERS PER MINUTE
TRANSACTIONS PER MINUTE
COST ANALYSIS
