Platinum Sponsor

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.
Presented by Neil Hambly at SQLBits XII
Tags (no tags)
  • Downloads
    Sorry, there are no downloads available for this session.
  • SpeakerBIO
    neil_hambly.png
    Neil Hambly is a SQL veteran with over 15 years’ expertise in SQL Server from Version 6.5 through to the very latest 2012 edition. Neil has held numerous DB roles at major organizations such as BBC, ABN AMRO, ACCENTURE, alongside a number of smaller companies, with prior roles as both a DBA ,Developer & Architect, He is now the Principle Database Engineer @ ASOS. He is a PASS UK Regional Mentor & leader of SQL London PASS Chapter, often seen speaking @ international and national SQL events
    http://sqlblogcasts.com/blogs/NeilHambly
  • Video
    The video is not available to view online.
  • Session Files Explorer
    The network name cannot be found.