Provides information about the statement currently executing. Enable the enable monitoring configuration parameter 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 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 |
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. |