Chat now with support
Chat with Support

Spotlight on SAP ASE 2.12 - User Guide

Spotlight on SAP ASE
Background Information Desktop Features Connect to SAP ASE Spotlight® on SAP ASE Drilldowns Spotlight® on SAP ASE Alarms Glossary
Spotlight Basics
Spotlight Connections Monitor Spotlight Connections Alarms Charts, Grids And Home Page Components View | Options Troubleshooting
Spotlight History Spotlight on Windows
Connect to Windows Systems Background Information Home Page Alarms Drilldowns View | Options Troubleshooting
Spotlight on Unix About us Third-party contributions Copyright

Stored Procedures in Cache grid

This list shows all the objects that have query plans currently in the Procedure Cache. An object can appear multiple times if more than one process is requesting execution simultaneously.

Problems such as developers inadvertently creating a stored procedure with the "with recompile" switch turned on can be detected. This flag means that Adaptive Server never saves a plan for this procedure; a new plan is created each time it is executed. This can impact an Adaptive Server's performance if the stored procedure is highly requested.

The following table describes the columns on this grid:



Database Name

The database name where the object was created

Procedure Name

The name of the object

Execution Time The total amount of time the ASE server spent executing the stored procedure plan or tree (on ASE 16 or later) in ms.
Execution Count The number of times the stored procedure plan or tree has been executed by the ASE server since it was cached (on ASE 16 or later).
CPU Time The total number of ms of CPU time used (on ASE 16 or later).
Logical Reads The number of read pages (on ASE 16 or later).
Physical Reads The number of physical reads (on ASE 16 or later).
Physical Writes The number of physical writes (on ASE 16 or later).
Pages Written The number of written pages (on ASE 16 or later).

Memory Used (KB)

The memory needed in cache to hold the execution plan


The stored procedure or trigger

Compile Date

The date the object was last compiled

Note: Available only in Adaptive Server versions or later


Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating