SQL Server 2019 Query Store And SSMS

While not specific to SQL Server 2019 (I was using this version to do some testing) I was struggling to find how to change the time period of analysis for the Query Store reports within SSMS.

This is not a ground breaking post but hopefully a helpful one! So, I load up the “Top 25 resource consumers” report and by default it will show data for the past hour. So what do you do, or should I say what do you click to change the time interval for the report?


You click the blue box above to give you the “configure” option.





1 thought on “SQL Server 2019 Query Store And SSMS

  1. Pingback: Changing Query Store Report Interval – Curated SQL

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.