Provides a history of the most recently executed statements on the server. Use statement pipe max messages to tune the maximum number of statement statistics returned.
Enable the enable monitoring, per object statistics active, statement pipe active, statement pipe max messages, and statement statistics active configuration parameters for this monitoring table to collect data.
monSysStatement is a historical monitoring table. See “Stateful historical monitoring tables”.
Name |
Datatype |
Attributes |
Description |
---|---|---|---|
SPID |
smallint |
Session process identifier. |
|
KPID |
int |
Kernel process identifier. |
|
DBID |
int |
Unique identifier for the database. |
|
ProcedureID |
int |
Unique identifier for the procedure. |
|
PlanID |
int |
Unique identifier for the stored plan for the procedure. |
|
BatchID |
int |
Unique identifier for the SQL batch containing the statement. |
|
ContextID |
int |
The stack frame of the procedure, if a procedure. |
|
ErrorStatus |
int |
The error return status of the statement. |
|
LineNumber |
int |
Line number of the statement within the SQL batch. |
|
CPUTime |
int |
Counter |
Number of milliseconds of CPU used by the statement. |
WaitTime |
int |
Counter |
Number of milliseconds the task has waited during execution of the statement. |
MemUsageKB |
int |
Number of kilobytes of memory used for execution of the statement. |
|
PhysicalReads |
int |
Counter |
Number of buffers read from disk. |
LogicalReads |
int |
Counter |
Number of buffers read from cache. |
PagesModified |
int |
Counter |
Number of pages modified by the statement. |
PacketSent |
int |
Counter |
Number of network packets sent by Adaptive Server. |
PacketsReceived |
int |
Counter |
Number of network packets received by Adaptive Server. |
NetworkPacketSize |
int |
Size (in bytes) of the network packet currently configured for the session. |
|
PlansAltered |
int |
Counter |
The number of plans altered at execution time. |
RowsAffected |
int |
Number of rows affected by the current statement. Queries using an inefficient query plan likely show a high number of logical I/Os per returned row. |
|
StartTime |
datetime |
Null |
Date the statement began execution. |
EndTime |
datetime |
Null |
Date the statement finished execution. |
ProcNestLevel |
int |
Nesting level of the stored procedure in which this statement executed. The value for ProcNestLevel is 0 (zero) for statements within SQL batches. |
|
StatementNumber |
int |
Number indicating the order in which this statement was executed within the SQL batch for the process. |