Returns a list of all procedures being executed by processes..
You need not enable any configuration parameters for this monitoring table to collect data.
Name |
Datatype |
Attributes |
Description |
---|---|---|---|
SPID |
smallint |
Session process identifier |
|
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 |
|
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) |