Returns a list of all procedures that are being executed by processes. monProcessProcedures does not require any configuration options.
Name |
Datatype |
Attributes |
Description |
|---|---|---|---|
SPID |
smallint |
Session process identifier |
|
KPID |
int |
Kernel process identifier |
|
DBID |
int |
Unique identifier for the 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 |
Number of kilobytes of memory used by the procedure |
|
CompileDate |
datetime |
Compile date of the procedure |
|
ContextID |
int |
Stack frame of the procedure |
|
DBName |
varchar(30) |
null |
Name of the database that contains the procedure |
OwnerName |
varchar(30) |
null |
Name of the object owner |
ObjectName |
varchar(30) |
null |
Name of the procedure |
ObjectType |
varchar(32) |
null |
Type of procedure (stored procedure, trigger procedure, and so on) |
