Episode
SQL Server 2016 Query Store Simplifying Query Performance Troubleshooting
with Mike Weiner
On this Data Driven session, you'll learn why database query performance is a mission critical aspect of any solution. Introduced in SQL Server 2016, the Query Store gives database administrators and developers a simple tool to help troubleshoot, understand and rectify poor performing queries. The Query Store can also be used to analyse query performance and workload patterns across an extended period of time (from weeks to years) and to de-risk upgrades by allowing for before and after query plans, saving and reverting characteristics to be saved and reverted back to even after a system upgrade.
On this Data Driven session, you'll learn why database query performance is a mission critical aspect of any solution. Introduced in SQL Server 2016, the Query Store gives database administrators and developers a simple tool to help troubleshoot, understand and rectify poor performing queries. The Query Store can also be used to analyse query performance and workload patterns across an extended period of time (from weeks to years) and to de-risk upgrades by allowing for before and after query plans, saving and reverting characteristics to be saved and reverted back to even after a system upgrade.