Archive for Month: August 2013


Executing SQL Stored Procedures

This article gives an overview of how to use Caché Stored Procedures in Caché Monitors Query Analyzer. Although executing a stored procedure can be as easy as listing it on a line by itself in a Caché-SQL command batch, you should make a habit of prefixing all stored procedure calls […]


SQL Tuning: Scanning Cached Queries to find unindexed JOINs

Caché Monitors SQL Scanner find automatic potential database performance bottlenecks. The cached queries are scanned and on each Query the JOINs are checked. To understand how the SQL Scanner are working it is required to understand the Caché SQL cache, called Cached Queries. What are Cached Queries? Each time the […]


SQL Tuning: Find unindexed foreign keys

SQL Tuning: Find Unindexed Foreign Keys Foreign key (FK) constraints without supporting indexes can cause severe performance problems during SQL statements. Caché Monitor can detect unindexed foreign key constraints for you. Reasons for Foreign Key Constraints Creating foreign key constraints on tables increases the integrity of data by preventing rows […]


Data export from InterSystems Caché

Caché Monitor provides the ability to export data to a variety of formats Text files (CSV) XML HTML SQL (INSERT, UPDATE or DELETE, INSERT) JSON Excel (XLS and XLSX) In order to export the data there exists two options in Caché Monitor: Save Results and Export Table Save Results This […]


SQL analysis and profiling

A main feature in Cache Monitor is profiling of sql statements. Specifically for SQL analysis InterSystems added in Caché 2008.1 the %SYSTEM.PTools.SQLStats class and measures lines of code,global references, times run and duration of run e.g. These information are used in Caché Monitor to implement the Profiling feature. Here are […]


Caché Locktable Viewer

To display or delete locks, click on the Lock Table in the Server Navigator. Now you can see details information about Caché lock table, this is Caché internal table where all LOCK commands issued by processes are stored. Lock Modes Mode Description Exclusive Exclusive lock mode. Shared Share lock mode. LockZA ZALLOCATE […]


The SQL execution plan in Query Analyzer

Cachè Monitor provides a visual display of an execution plan for SQL Queries. With this information it is more easily to tune SQL Statements. An SQL statement expresses what you want but does not tell Caché how to do it. It will decide the best way to compute the results. […]


SQL History

The SQL history feature displays information about all SQL Statements that are executed from the current Caché Monitor installation. You can recall any history entry for new execution in the Query Analyzer. The “Copy content” behavior can be configured with: “Replace”, “Copy at cursor pos” and “Copy at end”  


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.   Some features in short: Handles multiple open connections Asynchronous database communication Support for parameterized SQL scripts Code completion (Intelli Sense) […]

Server Navigator organize database connections

The Server Navigator is the central tool in Caché Monitor and allows to browse connections to InterSystems Caché and to many other databases as well. Organize all this connections into groups and sub groups in any way you like to fit your business needs. From the server Navigator you can […]