SQL Server Performance Tuning and Optimization

SQTH05 SQTH05 Tales from the Field HammerDB vs. Azure SQL

11/18/2021

1:00pm - 2:15pm

Level: Intermediate to Advanced

Bradley Ball

Sr. Azure Engineer for the Azure FastTrack CXP PG

Microsoft

Josh Luedeman

Sr. FastTrack Engineer, Azure Engineering – CXP

Microsoft

As members of the Azure FastTrack CXP Product Group we work with onboarding customers to Azure, and directly with Azure Data Product Groups to deliver feedback & develop messaging to customers. HammerDB is a universally recognized tool for creating TPC-C & TPC-H workloads for performance testing. More than a few customers have come to Azure looking to baseline environments with HammerDB. We will review how to set it up, how to run it, and how to get results.

You will learn:

  • Understand how to install and utilize HammerDB to run SQL Server workloads
  • Understand how to interpret results from HammerDB for SQL DB, SQL Hyperscale, SQL MI, and SQL Virtual Machines in Azure
  • Understand how Memory, CPU, and Networking IOPs are tied to performance in Azure