Cache Monitor 0.51

Cache Monitor 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. Cache-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.
Main features:
Advanced SQL Query Editor
- Cache-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
Cache Monitor can be used from any platform with an JAVA-JRE 5.0 (Linux, Windows,...).
- Cache Monitor helps you to organize your Server; to classify Cache 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

System requirements:
-

Enhancements
- Global Viewer is now working. Please attention about the global size, currently there is no limit!
- The Table-Viewer have now more filter functions from the context menu (look at the Data Panel and use right click on table).
- Faster startup.