oPASS & MagicPASS Meeting Tonight

David Pless is presenting:

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 analyse 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.

Note that the location is Nova Southeastern University (same location we used for the joint meeting last year). Details at http://orlando.sqlpass.org/.