แก้ไข

แชร์ผ่าน


Stored Procedures Event Category

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance

The Stored Procedures event category contains general stored procedure events.

In This Section

Topic 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.

See Also

Extended Events
sp_trace_setevent (Transact-SQL)