Stored Procedures Event Category

The

event category contains general stored procedure events.

Description

RPC:Completed Event Class

Indicates that a remote procedure call (RPC) has been completed.

PreConnect:Completed Event

Class

Indicates when the Resource Governor classifier function finishes

execution.

PreConnect:Starting Event Class

Indicates when the Resource Governor classifier function starts

execution.

RPC Output Parameter Event

Class

Traces the output parameter values of remote procedure calls after

execution.

RPC:Starting Event Class

Indicates that a remote procedure call is starting.

SP:CacheHit Event Class

Indicates that the stored procedure is in the cache.

SP:CacheInsert Event Class

Indicates that the stored procedure has been brought into the cache.

SP:CacheMiss Event Class

Indicates that the stored procedure was not found in the cache.

SP:CacheRemove Event Class

Indicates that the stored procedure has been removed from the

cache.

SP:Completed Event Class

Indicates that execution of the stored procedure has completed.

SP:Recompile Event Class

Indicates that the stored procedure has been recompiled.

SP:Starting Event Class

Indicates that execution of the stored procedure is starting.

SP:StmtCompleted Event Class

Indicates that a Transact-SQL statement within a stored procedure has

completed.

SP:StmtStarting Event Class

Indicates that a Transact-SQL statement within a stored procedure has

started.

ﾉ

Expand table