Monitoring the SAP ASE Statement Cache

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.
  1. In the Perspective Resources view, select the server to monitor, click the drop-down arrow, and select Monitor.
  2. In the left pane, select Caches.
  3. Click the Statement Cache tab.
  4. (Optional for cluster configurations) Select a specific cluster instance to see all the statements for that instance.
  5. Select a statement in the Cached Statements table.
    The SQL query appears at the bottom of the screen.
  6. 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.
Related tasks
Monitoring SAP ASE Data Caches
Monitoring the SAP ASE Procedure Cache
Monitoring SAP ASE In-memory Storage
Related reference
Data Cache Statistics and Details
Procedure Cache Statistics and Details
Statement Cache Statistics and Details
In-memory Storage Statistics and Details