SQL Server 2016 Query Store

How are we working with the SQL Server 2016 Query Store? Query store gives you the ability to get a better view of the performance of SQL Server and get it broken down to individual queries and you can get a view of how queries perform over time. I will guide you through what you can see in Query store and how we use the information available. I will talk both about the Graphs in Management Studio and about the tables in the database. Will give some real life examples when Query store saved the day and gave us time to fix the query later instead of having to do it when it was slow.

Speakers

headshot for Jonathan Jonsson

Jonathan Jonsson

Location

Lustikulla Konferens & Event
Liljeholmsvägen 18
Stockholm, 117 61
An unhandled error has occurred. Reload 🗙