SQL Server Performance Tuning and Optimization

SQW04 What's New in the 2017 Query Store

12/05/2018

9:30am - 10:45am

Level: Introductory to Intermediate

Janis Griffin

Database Performance Evangelist

SolarWinds

The Query Store houses valuable information on performance of your queries, as well as gives you great insights into your query workload and plan changes. This presentation will take a look at what's new in the 2017 Query Store, the new adaptive query processing features, and how to incorporate Query Store queries into the new SQL Operation Studio for monitoring slow running queries and analyzing waits. You'll learn how to use the Query Store to quickly find plan changes, analyze performance issues and find the waits that caused them. Both DBAs and developers can increase their performance-tuning skills by attending this session.

You will learn:

  • How to quickly find plan changes and analyze performance issues
  • How to use the new wait classifications in order to get clues on how to tune your statements
  • About the new adaptive query processing features and SQL Operation Studio