Trace Messages Part V: Trace Cleanup

Completing the sequence of articles on application level tracing, this article shows how to clean up the data in the AppSession, AppSessionTrace, and AppSessionMeasurement tables with the udf_AppSession_Purge stored procedure. The first four articles in this series have been about writing trace information to the AppSession, AppSessionTrace and AppSession. I've found this a useful technique for developing and using non-trivial stored procedures. If I keep the traces turned on in production, all those rows tend to add up after a while. Usp_AppSession_Purge has the task of cleaning up the AppSession* tables.

Read More...

---