Monitoring Application Progress
The 10 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 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 these events.
Get Microsoft® SQL Server 2008 R2 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.