Returns a list of all procedures being executed by processes.
Enable the enable monitoring and statement statistics active configuration parameters for this monitoring table to collect data.
The columns for monProcessProcedures 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 object’s database |
|
OwnerUID |
int |
Unique identifier for the object owner |
|
ObjectID |
int |
Unique identifier for the procedure |
|
PlanID |
int |
Unique identifier for the query plan |
|
MemUsageKB |
int |
Amount of memory, in KB, used by the procedure |
|
CompileDate |
datetime |
Date that the procedure was compiled |
|
ContextID |
int |
A unique identifier generated each time an executing query causes a stored procedure, trigger, execute immediate, deferred compilation, or other compiled object execution to occur |
|
LineNumber |
int |
The line in the procedure currently being executed |
|
StmtNumber |
int |
The currently executing statement |
|
DBName |
varchar(30) |
Null |
Name of the database that contains the procedure |
OwnerName |
varchar(30) |
Null |
Name of the owner of the object |
ObjectName |
varchar(30) |
Null |
Name of the procedure |
ObjectType |
varchar(32) |
Null |
The type of procedure (for example, stored procedure or trigger) |
ExecutionCount |
int |
Counter |
Number of times Adaptive Server executed this instance of the stored procedure held in the procedure cache |
CPUTime |
int |
Counter |
Amount of CPU time, in milliseconds, Adaptive Server spent executing the instance of this stored procedure held in the procedure cache |
ExecutionTime |
int |
Counter |
Total amount of time, in milliseconds, Adaptive Server spent executing the instance of this stored procedure held in the procedure cache |
PhysicalReads |
int |
Counter |
Number of physical reads performed by the instance of this stored procedure held in the procedure cache |
LogicalReads |
int |
Counter |
Number of logical reads performed by the instance of this stored procedure held in the procedure cache |
PhysicalWrites |
int |
Counter |
Number of physical writes performed by the instance of this stored procedure held in the procedure cache |
PagesWritten |
int |
Counter |
Number of pages read by the instance of this stored procedure held in the procedure cache |
