SQL Server 2016 Query Store Simplifying Query Performance Troubleshooting

Sign in to queue

Description

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.

For more information, check out this course on Microsoft Virtual Academy:

Day:

1

Embed

Download

Download this episode

Download captions

For more information, check out this course on Microsoft Virtual Academy:

The Discussion

Add Your 2 Cents