Provides information about the statement currently executing.
Enable the enable monitoring, statement statistics active, per object statistics active, and wait event timing configuration parameters for this monitoring table to collect data.
The columns for monProcessStatement are:
Name |
Datatype |
Attributes |
Description |
|---|---|---|---|
SPID |
smallint |
Session process identifier. |
|
InstanceID |
int |
(Cluster environments only) ID of an instance in a shared-disk cluster. |
|
KPID |
int |
Kernel process identifier. |
|
DBID |
int |
Unique identifier for the database currently being used by the process. |
|
ProcedureID |
int |
Unique identifier for the stored procedure. |
|
PlanID |
int |
Unique identifier for the plan the process is executing. |
|
BatchID |
int |
The batch number for the process in which the statement is executed. |
|
ContextID |
int |
The stack frame of the procedure, if a procedure. |
|
LineNumber |
int |
Line number of the statement within the SQL batch. |
|
CPUTime |
int |
Counter |
CPU time, in milliseconds, used by the statement. |
WaitTime |
int |
Counter |
Amount of time, in milliseconds, the task has waited while the statement executes. |
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. |
PacketsSent |
int |
Counter |
Number of network packets sent by the SAP ASE server. |
PacketsReceived |
int |
Counter |
Number of network packets received by the SAP ASE server. |
NetworkPacketSize |
int |
Size, in bytes, of the network packet currently configured for the session. |
|
PlansAltered |
int |
Counter |
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. |
|
DBName |
varchar(30) |
Name of the database in which this process is executing. If the process is executing a stored procedure or other compiled object, the database name is the name of the database for that object. |
|
StartTime |
datetime |
Null |
Date when the statement began executing. |