Caché Monitor is running! What next? This doc describes first steps with Caché Monitor.

• • Execute addhoc queries
Register your Server

After Caché Monitor starts, you must register one ore more Caché Server. Do that by by right-clicking the Caché Server Group node in the Server Navigator and selecting Add Server. Enter the needed information and press OK.
If you have many Servers you can group Server within Server Groups. By right-clicking the Caché Server Group node (this is the main Server Group) you can add more Groups to structure your Servers. Try Drag and Drop to move Server between Groups.

Executing SQL Statements is done with Caché Monitors Query Analyzer. You find this tool at many places for example by right-clicking one Caché Server node and select the menu item "Open Query Analyzer on selected Server" after that you must choose your namespace. Now a Query Analyzer.is open and ready to execute your SQL statements.

Pressing CTRL+O open also a new Query Analyzer but you must choose server and namespace.


Find Cached Queries that are expensive to execute

 

Check your database model