Query Store and Automatic Tuning in SQL Server [DBA]
Duration: 75 minutes
One of the most highly anticipated new features in the SQL Server 2016 release was Query Store. It's referred to as the "flight recorder" for SQL Server because it tracks query information – including the text, the plan, and execution statistics. The addition of wait statistics information in SQL Server 2017 makes Query Store a tool that every data professional needs to know how to use – regardless of prior experience with troubleshooting. When you include the new Automatic Tuning feature in SQL Server 2017, suddenly it seems like you might spend less time fighting fires and more time enjoying a lunch break that’s not at your desk.
In this session, we'll walk through Query Store with a series of demos designed to help you understand how you can immediately start to use it once you’ve upgraded to SQL Server 2016 or 2017. We'll review the different options for Query Store, look at the data collected (including wait stats!), dig through the included reports, check out how to force a plan, and dive into how you can leverage Automatic Tuning in to reduce the time you spend on Severity 1 calls fighting fires. Get ready to make troubleshooting easier with these new features that are available in all editions of SQL Server!