Tuesday, June 21st, 2016
Taking advantage of Query Store in SQL Server 2016
Joe McTaggart - MicrosoftAbstract:
One of the toughest performance problems to troubleshoot and diagnose in SQL Server is plan instability. One minute your server is running great, and the next minute user applications can be timing out. To diagnose this issue generally requires multiple rounds of data gathering, research into the underlying data, and potentially days to get to root cause. With the new Query Store feature in SQL Server 2016, this issue can potentially be identified and resolved in minutes. Query Store simplifies performance troubleshooting and makes forcing plans stability as simple as a couple clicks. In this session we will start with some basics on how to read query plans then look specifically at some scenarios with Query Store to highlight how it can be used to make your life as a DBA much easier.
Joe McTaggart is a Premier Field Engineer with Microsoft and has been working with SQL Server since 2001. At Microsoft, Joe primarily works with customers helping to architect, review, and troubleshoot solutions using SQL Server. This work has covered the breadth of the SQL product including SSRS, SSIS, SSAS, PowerPivot, and Azure. Aside from direct customer work, he has helped write or develop many of the Microsoft Premier workshops for SQL Server since SQL Server 2012.
5:30 - Professional Networking & Food
6:00 - Announcements
6:15 - Featured Presentation
7:15 - Prize Drawings
1401 North Meridian St.
Indianapolis, IN 46202