Skip to content

Tools for management of SQL Server's Query Store data

License

Notifications You must be signed in to change notification settings

rwestMSFT/qdstoolbox

 
 

Repository files navigation

QDS Toolbox

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)

About

Tools for management of SQL Server's Query Store data

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages

  • TSQL 89.5%
  • PLpgSQL 7.2%
  • PowerShell 3.3%