<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 12pt;
font-family:Calibri
}
--></style></head>
<body class='hmmessage'><div dir='ltr'><font style="font-size:16pt;" color="#000000" face="Garamond" size="4">It's not whether or not the trace is running, it's how often you delete "old" entries and reorg it. Having said that, we have stopped using it to test for duplicate events and now check for duplicate workflows in a check function.<br id="FontBreak"></font><br><br><font style="font-size:12pt;"><strong><font color="#000000"><font style="font-size:16pt;"><font face="Tahoma"><font style="font-size:10pt;" size="2">Ed Diehl</font><br></font></font></font></strong></font><font style="font-size: 12pt;" size="3"><font face="Tahoma"><span style="color:rgb(0, 0, 0);"><em>"Success consists of going from failure to failure without loss of enthusiasm."</em> </span><br><br></font></font><br><br><div><hr id="stopSpelling">To: sap-wug@mit.edu<br>From: davidcooper06@icloud.com<br>Subject: Workflow Event Trace Leave On or Turn Off<br>Date: Wed, 5 Mar 2014 06:55:50 +0000<br><br><div>Hi All,</div><div><br></div><div>The following is more a discussion item!</div><div><br></div><div>I have read in various texts and heard from several workflow administrators that it is recommended to turn the workflow trace off in production.</div><div><br></div><div>Reasons:</div><div>1) The trace adds an overhead to the application and database servers, and</div><div>2) The trace fills up the event table(s) with data that is not needed over time.</div><div><br></div><div>My argument for leaving the trace running, is more for diagnostic reasons when problems occur in production. It becomes another source for tracking down what happened. Yes the overhead is a given, but I feel this is justified to capture the diagnostic information. As for the database table being filled, implement a deletion strategy which purges the data from the table after a period of say 3 ,6, 9, or 12 months.</div><div><pre style="font-family:'Helvetica Neue', Helvetica, sans-serif;font-size:15px;white-space:pre-wrap;word-wrap:break-word;" data-mce-style="font-family: 'Helvetica Neue', Helvetica, sans-serif; font-size: 15px; white-space: pre-wrap; word-wrap: break-word;">Kind Regards
David Cooper
Linked-In: http://www.linkedin.com/pub/david-cooper/47/616/36a
</pre></div><br>_______________________________________________
SAP-WUG mailing list
SAP-WUG@mit.edu
http://mailman.mit.edu/mailman/listinfo/sap-wug</div>                                            </div></body>
</html>