Load Testing Storage Performance for SQL Server

Anthony Nocentino

You’re a DBA whose infrastructure team just deployed your new SQL Server on a new storage platform, either in the cloud or on-premises.

Now, you need the confidence that this new SQL Server can keep up with the demands of your unique database workload.

In this session, you will learn how to design and execute effective load testing for your disk subsystem. We will introduce commonly used load testing tools and dive deep into the core disk performance counters and how to interpret them.

Learning Objectives

* Designing and executing a load test

* Comparing and contrasting existing load testing tools for SQL Server

* Interpreting performance data