This is a collection of tools (comprising a combination of views, procedures, functions...) developed using the Query Store functionality as a base to facilitate its usage and generating reports. These include but are not limited to:
-
Implementations of SSMS GUI reports that can be invoked using T-SQL code, with added functionality (parameterization, saving results to tables) so they can be programmatically executed and used to send out mails.
-
Quick analysis of a server's overall activity to identify bottlenecks and points of high pressure on the SQL instance at any given time, both in real time or in the past.
-
Cleanup of the QDS cache with a smaller footprint than the internal one generates, with added parameters to enable a customizable cleanup (such as removing information regarding dropped objects, and cleaning details of ad-hoc or internal queries executed on the server as index maintenance operations).
-
Analysis of execution plans, both from Query Store, SQL cache and files.
All these tools have been tested on SQL Server 2016, 2017 and 2019 instances, both with Case Sensitive and Case Insensitive collations, and running on both Windows and Linux.
Since Query Store did not capture all the information in SQL Server 2016 as it does in later versions, some functionality may be restricted.
(Original icon art by https://www.smashicons.com)