Stored Procedures Data Columns
The following table lists the data columns for each event class in the Stored Procedure event category.
| Event class | Data column | Description |
|---|---|---|
| RPC Output Parameter | Event Class | Type of event recorded = 100. |
| Object Name | Name of the output parameter from the RPC event (for example, handle). | |
| Text Data | Value of the parameter named in object name that was returned by the remote procedure call (RPC). | |
| RPC:Completed | Event Class | Type of event recorded = 10. |
| End Time | End time of the RPC. | |
| Duration | Duration of the RPC. | |
| CPU | Amount of CPU used by the RPC. | |
| Reads | Number of page reads issued by the RPC. | |
| Writes | Number of page writes issued by the RPC. | |
| Text Data | Text of the RPC. | |
| RPC:Starting | Event Class | Type of event recorded = 11. |
| Text Data | Text of the RPC. | |
| SP:CacheHit | Event Data | Type of event recorded = 38. |
| Object ID | Object ID of the stored procedure found in the cache. | |
| Object Name | Name of the stored procedure found in the cache. | |
| Text Data | Text of the SQL statement that was found in the cache. | |
| SP:CacheInsert | Event Class | Type of event recorded = 35. |
| Object ID | Object ID of the stored procedure. | |
| Object Name | Name of the stored procedure found in the cache. | |
| Text Data | Text of the SQL statement that is being cached. | |
| SP:CacheMiss | Event Class | Type of event recorded = 34. |
| Event Sub Class | Nesting level of the stored procedure. | |
| Object Name | The name of the stored procedure found in the cache. | |
| SP:CacheRemove | Event Class | Type of event recorded = 36. |
| Object ID | Object ID of the stored procedure. | |
| Object Name | Name of the stored procedure found in the cache. | |
| Text Data | Text of the SQL statement being removed from the cache. | |
| SP:Completed | Event Class | Type of event recorded = 43. |
| Nest Level | Nesting level of the stored procedure. | |
| End Time | End time of the event. | |
| Duration | Length of time the stored procedure ran. | |
| Object ID | Object ID of the stored procedure. | |
| Object Name | Name of the stored procedure found in the cache. | |
| Object Type | Type of stored procedure that was called. | |
| Text Data | Text of the stored procedure call. | |
| SP:ExecContextHit | Event Class | Type of event recorded = 39. |
| Object ID | Object ID of the stored procedure. | |
| Object Name | The name of the stored procedure found in the cache. | |
| Text Data | The text of the stored procedure call found in the cache. | |
| SP:Recompile | Event Class | Type of event recorded = 37. |
| Nest Level | Nesting level of the stored procedure. | |
| Object ID | The object ID of the stored procedure. | |
| Object Name | The name of the stored procedure found in the cache. | |
| Text Data | The text of the stored procedure call that triggered the recompile. | |
| SP:Starting | Event Class | Type of event recorded = 42. |
| Nest Level | Nesting level of the stored procedure. | |
| Object ID | The object ID of the stored procedure. | |
| Object Name | The name of the stored procedure found in the cache. | |
| Object Type | The type of stored procedure being started. | |
| Text Data | The text of the stored procedure call. | |
| SP:StmtCompleted | Event Class | Type of event recorded = 45. |
| Event Sub Class | Nesting level of the stored procedure. | |
| Integer Data | Actual rows returned by the statement. | |
| Object ID | System-assigned ID of the stored procedure. | |
| Text Data | Text of the statement in the stored procedure. | |
| SP:StmtStarting | Event Class | Type of event recorded = 44. |
| Event Sub Class | Nesting level of the stored procedure. | |
| Object ID | System-assigned ID of the stored procedure. | |
| Text Data | Text of the statement in the stored procedure. |