Tech Tutorials Database
GeekArticles Database SQL Server

Trace Messages Part V: Trace Cleanup

Category: SQL Server
Comments (0)

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.


Sponsored Links

Read Next: Naming Database Objects: Part I