Cache Monitor is the SQL development tool designed for InterSystems database Caché. It supports developers with features, like: Advanced SQL Query Editor, Cache-SQL Syntax highlighting, SQL Code completion, SQL History buffer for executed SQL commands, SQL Code formatting,Graphical SQL execution plan and more.

You see the process ID (PID) from your connection on the Tabpane on every Query Analyzer. Code completion will let you type a few characters and then display a list of context-sensitive possibilities to complete the text you are typing. Editor code completion brings up a list of Tables or Columns (also known as Intellisense).

Code completion can be triggered by pressing [CTRL+SPACE] or by typing a hotchar or keyword, such as '.' or ',' in an SELECT list. Caché-SQL formatting can executed from context menu to make your code, or the code of others, much easier to read ('Format SQL'). Also supports, of course: Undo/Redo and Search and Replace.

Since version 0.18 the Hyperlink navigation has been added. Hyperlink navigation is a means for simple navigation from the editor to Tables metadata. When you presses the CTRL key and hover the mouse cursor over a certain code element, the element is changed to a hyperlink. When you hold the CTRL key and click on the hyperlink, the go to Tables metadata action is performed.

Since 0.20, Cache Monitor contains features to tune the database.

Here are some key features of "Cache Monitor":

Advanced SQL Query Editor
· Caché-SQL Syntax highlighting
· SQL Code completion for Tables,Views,Columns and Indexes (also known as Intellisense)
· SQL History buffer for executed SQL commands
· SQL Code formatting
· Parallel (multi-threaded) queries
· The Graphical SQL execution plan supplies index and selectivity information from every used index in the plan
· SQL abbreviations, Type: se to complete to "SELECT * FROM "
· TuneTable for selected Tables or whole Namespaces
· Select2Table Function

DDL Code generation (CREATE TABLE)
MetaData-Browser for
· Namespaces
· Tables
· Views
· Routines
· Classes
· CachedQueries
· Stored Procedures
· Indexes
It can be used from any platform with an JAVA-JRE 5.0 (Linux, Windows,...)

· Caché Monitor helps you to organize your Server; to classify Caché Servers into groups, divide groups into subgroups etc.
· You can see Cache Version infos from connected Server
· Shows Executionplan from an SQL Statement.
· You can view the selectivity from the used columns in the execution plan
· Shows CachedQueries with their costs and the underlying SQL (AddHoc from Intersystems needed!)
· Select2Table Function
· Fast open Query Analyzer with CTRL+Q on selected Server
· Fast open Query Analyzer with CTRL+O
· CopyTable Function
· Execute TuneTable for selected Tables or the whole Namespace
· Shows PID (ProcessID) from each Query Analyzer connection
· Shows Processlist
· Shows SELECT-Statements from SQL Views
· Show Routines


Requirements:

· Java-JRE 5.0.