SQL Server 2016 introduced Query Store, a new feature which tracks query metrics and can be used for troubleshooting, testing, and proactively monitoring a workload. Query Store also provides the ability to force a plan for particular query, which means you may no longer need to use those tricky plan guides. In the upcoming SQL Server 2017 release, not only is wait statistics information included in Query Store, but the Automatic Tuning feature has been added to help further stabilize your system and reduce the amount of time database professionals spend addressing poorly-performing queries.
In this session, we'll examine plan forcing in depth, including why a forced plan will fail and how plan forcing compares to using plan guides. Then we'll dig into the new wait statistics information in Query Store and look at how Automatic Tuning can be deployed. Expect a lot of demos as we investigate how Query Store can help you do more than just troubleshoot issues, but also manage query performance.
Erin Stellato is a SQL Server MVP and lives in Cleveland, OH. She has over 15 years of technology experience and has worked with SQL Server since 2003. Her areas of interest include statistics, performance tuning, Extended Events, and helping accidental/involuntary DBAs figure out how SQL Server works. Erin is an active member of the SQL Server community, has volunteered for PASS at the local and national level, and is a regular speaker at conferences like SQLintersection and the PASS Summit. Outside of time with family and friends, she enjoys running, spinning, movies, and all things chocolate.
Full Bio: http://www.sqlskills.com/about/erin-stellato/
Data Platform MVP since 2012