Cache Monitor 0.36

Cache Monitor 0.36 is considered as a very convenient as well as effective SQL development tool for InterSystems database Cache.

Major Features:

1. 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
2. DDL Code generation (CREATE TABLE)
3. MetaData-Browser for
   • Namespaces
   • Tables
   • Views
   • Routines
   • Classes
   • CachedQueries
   • Stored Procedures
   • Indexes
4. It can be used from any platform with an Java Runtime Environment 6 (Linux, Windows,...)
5. Caché Monitor helps you to organize your Server; to classify Caché Servers into groups, divide groups into subgroups etc.
6. You can see Cache Version infos from connected Server
7. Shows Executionplan from an SQL Statement: You can view the selectivity from the used columns in the execution plan
8. Shows CachedQueries with their costs and the underlying SQL (AddHoc from Intersystems needed!)
9. Select2Table Function
10. Fast open Query Analyzer with CTRL+Q on selected Server
11. Fast open Query Analyzer with CTRL+O
12. CopyTable Function
13. Execute TuneTable for selected Tables or the whole Namespace
14. Shows PID (ProcessID) from each Query Analyzer connection
15. Shows Processlist
16. Shows SELECT-Statements from SQL Views
17. Show Routines

Enhancements:

• Query Analyzer: Work now with the current driver for Version 2007.1 AND with the Version for 2008.1