Skip to content

Latest commit

 

History

History
20 lines (11 loc) · 1.18 KB

README.md

File metadata and controls

20 lines (11 loc) · 1.18 KB

SQL Statement Analyzer

This repo contains a simple IRIS BI cube sourcing its data from the SQL Statement Index, which is a treasure trove of runtime statistics on your instance's SQL usage.

Installation

After importing the contents of this repository, you can build the cube using the following command (executed automatically if you install through ZPM):

do ##class(%DeepSee.Utils).%BuildCube("SQLStats")

Data is fetched from the INFORMATION_SCHEMA.STATEMENT_DAILY_STATS view, so it makes sense to rebuild the cube on a daily schedule using the Cube Manager or a simple scheduled task.

What's in the box

The cube definition (for now) is fairly basic and exposes the runtime and execution count metrics. There is also a custom action which allows you to jump to the Statement Details page in the System Management Portal.

Happy to include pull requests with further extensions, including prebuilt dashboards, pivots and other goodness.