Query Store – Part 2

Part –1 is on how to enable Query Store, in this post we will see what happens once Query Store is enabled.

Once the Query Store is enabled, 4 Query monitor are configured which is under Query Store folder

image 

  • Regressed Queries : The Regressed Queries pane shows you the queries, and plans in the query store. The Regressed Queries has 3 parts
    • Top 25 Regressed Queries during last 1 hour for Database (Database Name).Query Plans,Used Plan Count,Query Text

       image

      image

      image

      image

      image 

    • Plan Summary for Query (Query Id)

      Chart Option:

      image

      image

      image

      Grid Option: It displays the data summary

      image 

    • Query Plan

      image 

Leave a Reply

Your email address will not be published. Required fields are marked *