SQL Server 2016: Introduced Query Store, to monitor the performance differences between query execution plans

SQL Server 2016 introduced a Query Store concept which helps us to monitor the performance differences between the query execution plans.

It helps you to track the query plan, run time statistics and history of query plan.

You can easily find your new query with the different execution plans and you can identify un-efficient plan and force for the better execution plan.

Once you enable the Query Store, It starts to capture a history of queries, plans and other run time statistics.

You can audit the query plans and can find information like: top n queries, CPU/IO/Memory utilization of queries and query executed in a number of times.

Enable the Query Store:

You can use below query to find an information on Query Store:

Anvesh Patel

Leave a Reply

Be the First to Comment!

Notify of