The new main feature in Cache Monitor 0.54 is the profiling of sql statements. Specifically for SQL analysis InterSystems added in Caché 2008.1 the %SYSTEM.PTools.SQLStats class and measures lines of code,global references, times run and duration of run e.g.

Caché Monitor provides the ability to export user data to a variety of formats

SQL Tuning: Find Unindexed Foreign Keys

Foreign key (FK) constraints without supporting indexes can cause severe performance problems during SQL statements. Caché Monitor can detect unindexed foreign key constraints for you.

Reasons for Foreign Key Constraints

Caché Monitors SQL Scanner find automatic potential database performance bottlenecks. The cached queries are scanned and on each Query the JOINs are checked.

This article gives an overview of how to use Caché Stored Procedures in Caché Monitors Query Analyzer.

The SQL Editor (Query Analyzer)

Caché Monitor supports multiple editors and result sets, bookmark feature, formatting, script execution and extensive customization. Result sets can be edited, viewed in text or table format.