Provides the most recent generated text plan. Specify the maximum number of messages returned with plan text pipe max messages. monSysPlanText requires the enable monitoring, plan text pipe max messages, and plan text pipe active configuration parameters to be enabled.
Name |
Datatype |
Attributes |
Description |
|---|---|---|---|
PlanID |
int |
Unique identifier for the plan |
|
SPID |
smallint |
Session process identifier |
|
KPID |
int |
Kernel process identifier |
|
BatchID |
int |
Unique identifier for the SQL batch for which the plan was created |
|
ContextID |
int |
The stack frame of the procedure, if a procedure |
|
SequenceNumber |
int |
A monotonically increasing number indicating the position of the PlanText column within the entire plan text |
|
DBID |
int |
Unique identifier for the database where the procedure is stored, if the plan is for a stored procedure |
|
ProcedureID |
int |
Unique identifier for the procedure, if the plan is for a stored procedure |
|
PlanText |
varchar(160) |
null |
Plan text output |
