Monitoring Application Progress
The 10 SQL Server Profiler user-configurable events can be used in a variety of ways, including for tracking the progress of an application or procedure. For instance, perhaps you have a complex procedure that is subject to lengthy execution. You can add debugging logic in this procedure to allow for real-time benchmarking via SQL Server Profiler.
The key to this type of profiling is the use of the sp_trace_generateevent
stored procedure, which enables you to launch the User configurable
event. The procedure needs to reference one of the User configurable
event IDs (82
to 91
) that correspond to the User configurable
event 0
to 9
. If you execute the procedure with eventid= 82
, then User configurable
event 0
catches ...
Get Microsoft SQL Server 2014 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.