Trace Messages Part V: Trace Cleanup

Author: novicksoftware.com | Published: 10th Aug 2005 | Visited: 543 times | Add Comment
Filed in: SQL Server

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 Article

Sponsored Links

• More Texas Holdem Analysis in C#: Part 1 Using C# to do sophisticated analysis of Texas Ho ...

• More Texas Holdem Analysis in C#: Part 2 Using C# to do sophisticated analysis of Texas Ho ...

• Article :: Getting Your Disaster Recovery Plan Funded - with an Awesome Business Impact Analysis, Pa... Why won't management fund your disaster recovery plan? It's time to revise your think ...

• Agochar Keypad : Part 2 - A draggable and customizable Hindi Keypad - like popup A draggable and customizable keypad to input hindi (official language of India) characters in text box using mo ...

• Article :: One Leet Pwning Child: Give One, Get Owned, Part 1 Seth Fogie takes an exploratory look at the XO to see what?s inside and provides a few pointers for preparing it for "enhanceme ...

• Taking a Fireworks comp to a CSS-based layout in Dreamweaver ? Part 1: Initial design Create your web design in Fireworks before moving it to Dreamwea ...

• Utilizing your .NET Projects Automated Acceptance Tests on Crystal Reports - Part 1 In this first part of the series, Eric shows how to use automated acceptance testing against Crystal Reports using the object model. After providing the requirements, he examines how to utilize automated acceptance tests with reports along with sample code to validate the report. He concludes the ar ...

• Office Web Component v11.0 Spreadsheet And AJAX Interoperatibility Part 1 This article demonstrate, how OWC and AJAX can be used to store spreadsheet content as XML data into database.This XML in turns rendered as spreadsheet in OWC control from database sou ...

• Beginners Guide To Threading In .NET Part 1 of n Beginners Guide To Threading In ...

• Create Secure Java Applications Productively, Part 1: Use Rational Application Developer and Data St... This is the first in a two-part tutorial series creating secure Java-based Web applications using Rational Application Developer, Data Studio and Rational AppScan. This first tutorial begins by showcasing how Data Studio with pureQuery can increase the efficiency of your database-driven Web developm ...

Next: Naming Database Objects: Part II