Skip to content

Latest commit

 

History

History
46 lines (40 loc) · 3.59 KB

File metadata and controls

46 lines (40 loc) · 3.59 KB
title Stored Procedures Event Category
description Stored Procedures Event Category
author WilliamDAssafMSFT
ms.author wiassaf
ms.date 03/14/2017
ms.service sql
ms.subservice supportability
ms.topic reference
ms.custom
ignite-2025
helpviewer_keywords
Stored Procedures event category [SQL Server]
SQL Server event classes, Stored Procedures event category
event classes [SQL Server], Stored Procedures event category
monikerRange =azuresqldb-current || >=sql-server-2016 || >=sql-server-linux-2017 || =azuresqldb-mi-current || =fabric-sqldb

Stored Procedures Event Category

[!INCLUDE SQL Server Azure SQL Database Azure SQL Managed Instance FabricSQLDB] 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 [!INCLUDEtsql] statement within a stored procedure has completed.
SP:StmtStarting Event Class Indicates that a [!INCLUDEtsql] statement within a stored procedure has started.

See Also

Extended Events
sp_trace_setevent (Transact-SQL)