Featured Presentation

SQL Server 2016 Plan Guides and Query Store

David PlessSpeaker: David Pless

Summary: Query Store is a new feature in SQL Server 2016, and is also available in Azure SQL Database V12. Query Store is designed to help with query performance troubleshooting by making it easier to identify poorly performing statements and finding scenarios where performance regresses. In this session we will discuss how Query Store can help you identify the changes in query plans and figure out when performance regressions occur. We will cover how Query Store collects and presents detailed historic information and how it can be used to reduce the time it takes to diagnose and resolve issues. If a query generates different plans, you can use Query Store to analyze the plan changes, identify possible performance degradation, and even force the query processor to use a particular plan for your query. We will also cover how plan guides allows you to optimize the performance of queries when you cannot directly change the text of the actual query in SQL Server. Plan guides can be useful when a small subset of queries in a database application (example: third-party vendors) are not performing as expected.

About David: For the past eight years, David has been a Senior Premier Field Engineer (PFE) with Microsoft. As a PFE he performs health checks, conducts full training workshops, and works on reactive and proactive engagements on all supported builds of SQL Server. David mainly support the Southeast focusing on Florida, but he can be anywhere in the world. His core areas are Performance Tuning and Optimization, AlwaysOn, Reporting Services (SSRS), custom monitoring, building custom dashboards, and more.

cage-aids
cage-aids
cage-aids
cage-aids