Using SQL Server 2016 Tools For Query Tuning

  • Monday, 10/23/2017: 8:00 AM - 4:00 PM
  • Room: Franciscan C

Description

Query tuning within SQL Server can be a tough skill to master. The new tooling released with SQL Server 2016 changes how you identify poorly performing queries, troubleshoot their behavior, and tune the queries, all a little easier. This workshop teaches new techniques for tuning queries using all the new tools introduced in SQL Server 2016. You'll be able to put this knowledge to work immediately, not only in your 2016 instances, but also in your Azure SQL Database databases. You will be tuning your queries faster and more accurately using the new tools available.

Learning Objectives

Gain a general query tuning methodology applicable to almost every system.
Learn about all the new query tuning tooling introduced with SQL Server 2016.
Be able to better apply these tools to their own systems in order to tune queries faster and more accurately.

Speaker

Grant Fritchey

Product Evangelist
Redgate Software
Speaker