Load Testing with SQL Server Tools
It’s often difficult to know how your SQL Servers will perform under different loads. By performing load testing, we can gain these key insights, perform modifications to existing configurations, and understand the impact on performance levels.
Come learn about the native tools at our disposal for performing these important load tests and how we can identify when performance levels begin to drop. Using demos of these native tools – including Distributed Replay Utility (DRU), Database Tuning Adviser (DTA), Perfmon, Extended Events, and Profiler – we’ll see how to plan and perform a load test project, gain an understanding of SQL Server’s performance under varying load scenarios, and discover which tell-tale indicators can help alert us to performance degradation.
PASS Summit Charlotte (Nov 2013)
This will be my 3rd consecutive year attending a PASS Summit, this one is a little different as we are in a different city, this year we are on the east coast in the lovely city of Charlotte (North Carolina) the home of NASCAR and we have some friends there as well, as it is also home to SQL Sentry
PDF Presentation PASS 2013_NeilHambly_LoadTestingSQLServer
Aside from the Summit I have presented this Load Testing with SQL Server Tools session @ these other events
- SQL Relay 2013R2 Norwich (Nov 2013)
- PASS DBA Virtual Chapter Virtual (Dec 2013)