The metrics in this category provide the most recent SQL text that has been executed, or is currently being executed. The maximum number of rows returned can be tuned with SQL text pipe max messages.
Collection Frequency - 12 hours
Table 3-42 Recently Executed SQL Text Metrics
| Metric | Description |
|---|---|
|
For Release 7 SQL Batch ID |
For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 7 (1.1.1.0.0) Batch ID of the currently being executed SQL text. |
|
For Release 7 SQL Text position in bat |
For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 7 (1.1.1.0.0) Position of the currently being executed SQL test. |
|
For Release 7 Server UID |
For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 7 (1.1.1.0.0) UIS of the server. |
|
For Release 7 Server UID |
For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 7 (1.1.1.0.0) UIS of the server. |
|
For Release 6 SQL Text |
For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0) SQL Text |
|
SPID |
Session process identifier. |
|
KPID |
Kernel process identifier. |
|
Login Name |
Login user name. |
|
Server User ID - Batch ID - SQL Text Position in Batch |
Server User identifer / Batch identifier of the currently being executed SQL test / Position of the currently being executed SQL test. |