Tech Tutorials Database
GeekArticles Database SQL Server
 

Trace Messages Part V: Trace Cleanup

 
Author: novicksoftware.com
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.

Read More...




Sponsored Links




Read Next: Naming Database Objects: Part I



 

 

Comments



Post Your Comment:

Your Name:*
e-mail ID:(required for notification)*
Image Verification:�
 
 Subscribe