1 out of 1 rated this helpful - Rate this topic

Stored Procedures Event Category

SQL Server 2005

The Stored Procedures event category contains general stored procedure events.

Topic	Description
RPC:Completed Event Class	Indicates that a remote procedure call (RPC) has been completed.
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.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions