Skip to content

Feature List

taskpane

Server Navigator

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.

Namespaces

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

namespaces

  • 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

Management

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

Performance

  • 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)