Skip to content

Feature List


Server Navigator



Query Analyzer
The Query Analyzer (query editor) is used to edit SQL scripts. Caché Monitor can work with multiple editors open at the same time, execute scripts and process the results.query_editor_folding

Caché Monitor list registered Caché Database Server in Server Navigator.


For each Caché Namespace you can navigate to database objects of types:


  • Tables
  • Views
  • Stored Procedures
  • Indexes
  • Routines (not for all Caché versions available)
  • Classes
  • Cached Queries
  • Globals

On each typ many functions are available, like data editing in grid, quick data filtering, export\import large results direct to\from file


  • Databases
  • Log File Viewer
  • Processlist Viewer to terminate process, show process details (vars, routine), show routine source code
  • Locktable Viewer
  • Tasks


  • SQL Profiling
  • Cached Queries on Caché Server
  • SQL Scanner (SQL Tuning)
    Analyze performance by identifying slowly executing queries, Find unindexed foreign keysScan cached queriesDROP INDEX on selected index (redundant index finder), CREATE INDEX on selected querie (Cached Queries Scanner)