Load Testing Storage Performance for SQL Server

In this session, we will delve into the fundamentals of load testing for SQL Server. We will cover everything from planning to execution and interpreting the results to enhance performance. Participants will gain valuable insights into creating a load test that accurately mirrors their specific environment, whether it's on-premises or in the cloud.

Key concepts such as understanding hardware capabilities, virtual machine configurations, cloud-specific considerations, and a detailed examination of the I/O stack and queuing mechanisms will be explored. We will then move on to discuss different load-testing strategies, comparing synthetic and real workloads, and reviewing popular tools such as DiskSpd, HammerDB, and Workload Tools. Additionally, we will learn how to utilize SQL Server's own capabilities for simulating workloads.

Collecting performance data is a critical part of the process, and we will demonstrate how to automate this using PowerShell extract performance metrics from SQL Server DMVs and PerfMon.

Finally, we will focus on interpreting the collected data, including a live demo to illustrate how to analyze queuing behavior in order to identify potential bottlenecks.

This session is designed for DBAs, system administrators, and developers who are seeking to improve their load-testing strategies and optimize SQL Server performance.

Webcast Date

Tuesday, December 3, 2024
1:00:00 PM EST (New York) | 6:00:00 PM UTC

Speaker(s)

Anthony Nocentino is an accomplished technology professional, author, and speaker with over 20 years of experience in the IT industry. He is a Senior Principal Field Solution Architect at Pure Storage.

He is a Microsoft Data Platform MVP and is recognized globally for his SQL Server, Kubernetes, and Public cloud infrastructure expertise. He is the author of "SQL Server on Kubernetes" and "Azure Arc-enabled Data Services Revealed" as well as Pluralsight courses.

Anthony has a Masters degree in Computer Science with research publications in high-performance/low-latency data access algorithms and spatial database systems.

Anthony's passion for technology and ability to deliver engaging and informative presentations make him a sought-after conference speaker internationally at leading data and cloud conferences. Attendees can expect to leave their sessions with a deep understanding of the technology and practical tips.

Sponsored by

Register for this webinar: