Display information about the statement cache, including cached SQL queries.
Note: Statement cache monitoring is controlled by the two configuration options
enable stmt cache monitoring and statement cache
size. For the Statement Cache tab to appear, the statement cache must
be configured in SAP ASE and the enable stmt cache
monitoring option must be turned on in SAP ASE. Turning on the
enable stmt cache monitoring option is not
necessary to enable monitoring of a server.
- In the Perspective Resources view, select the server to monitor, click the drop-down arrow, and select Monitor.
- In the left pane, select Caches.
- Click the Statement Cache tab.
- (Optional for cluster configurations) Select a specific
cluster instance to see all the statements for that instance.
- Select a statement in the Cached Statements table.
The SQL query appears at the bottom of the screen.
- Click the tabs to display pool information or details about cached objects.
For more information on the statement cache, see System Administration Guide, Volume 2.