<br><font size=2 face="sans-serif">Hi Ritapac,</font>
<br><font size=2 face="sans-serif">Mike could not have said it any betters.
I agree with him, by far the most likely source of performance degradation
will be seen from outstanding workitems. I am curious how many workitems
by age are outstanding on that system?</font>
<br><font size=2 face="sans-serif">Also you will probably find that an
analysis by workflow process might yield some clues, i.e what is
the breakdown of outstanding work items by workflow? You could also then
look at the frequency of any workflows that jump out of your analysis.</font>
<br>
<br><font size=2 face="sans-serif">By the way in our environment we are
archiving and have satisfied the requirement of record retention since
you are still able to retrieve the wf log via GOS. Are you saying
that 15million entries represents 6 months worth of workflow activity?.</font>
<br>
<br><font size=2 face="sans-serif">good luck,</font>
<br>
<br><font size=2 face="sans-serif">Edwin.</font>
<br>
<br>
<br>
<br>
<table width=100%>
<tr valign=top>
<td width=40%><font size=1 face="sans-serif"><b>Mike Pokraka <asap@workflowconnections.com></b>
</font>
<br><font size=1 face="sans-serif">Sent by: sap-wug-bounces@mit.edu</font>
<p><font size=1 face="sans-serif">07/07/2006 11:24 AM</font>
<table border>
<tr valign=top>
<td bgcolor=white>
<div align=center><font size=1 face="sans-serif">Please respond to<br>
"SAP Workflow Users' Group" <sap-wug@mit.edu></font></div></table>
<br>
<td width=59%>
<table width=100%>
<tr valign=top>
<td>
<div align=right><font size=1 face="sans-serif">To</font></div>
<td><font size=1 face="sans-serif">"SAP Workflow Users' Group"
<sap-wug@mit.edu></font>
<tr valign=top>
<td>
<div align=right><font size=1 face="sans-serif">cc</font></div>
<td>
<tr valign=top>
<td>
<div align=right><font size=1 face="sans-serif">Subject</font></div>
<td><font size=1 face="sans-serif">Re: Performance problem on SWWCNTP0
tables</font></table>
<br>
<table>
<tr valign=top>
<td>
<td></table>
<br></table>
<br>
<br>
<br><tt><font size=2>Hi,<br>
RSWIWADO has been removed from the menu path a couple of versions ago <br>
since the actual number is meaningless without knowing your system size
<br>
and a number of other factors. However 15 mill is a lot but not that <br>
huge that it should cause major headaches unless you have a small SAP <br>
system.<br>
<br>
I've also found that more important than the absolute number of entries
<br>
is the number of open items. The status is part of most indexes and <br>
selections. So if your flows do not complete, that's going to cause <br>
performance bottlenecks. Do some snapshot analyses using SE16 of old <br>
items - e.g. how many WI's (select from SWWWIHEAD) in January this year,
<br>
and how many of these are NOT in status COMPLETED/CANCELLED. This number
<br>
should be minimal - in an ideal world everything that old should be <br>
complete unless you really have flows that run that long. If not, <br>
consider cancelling old flows.<br>
<br>
Basis should be able to check out any bottlenecks from indexes.<br>
<br>
Also, consider archiving workitems - tx SARA, object WORKITEM.<br>
<br>
Cheers,<br>
Mike<br>
<br>
<br>
Rita Paciucci wrote:<br>
> Hi Edwin, <br>
> SWWCNTP0 table has many entries (about 15.000.000) and the report
RSWIWADO shows red symbol on it.<br>
> We have deleted all obsolete workitem, but we can't delete every item
because we need to save at least six months before.<br>
> I've searched on OSS and I've found 2 notes (#702356 and #706478)
but they don't solve my problem.<br>
> Any idea to help me?<br>
> Thanks a lot.<br>
> Ritapac.<br>
> <br>
> <br>
> ---------- Initial Header -----------<br>
> <br>
>>From : sap-wug-bounces@mit.edu<br>
> To : "SAP Workflow Users' Group"
sap-wug@mit.edu<br>
> Cc : <br>
> Date : Thu, 6 Jul 2006 11:32:32 -0500<br>
> Subject : Re: Performance problem on SWWCNTP0 tables<br>
> <br>
> <br>
> <br>
> <br>
> <br>
> <br>
> <br>
>> Hi Ritapac,<br>
>><br>
>> How table entries are we talking about here? Have you talked
to your <br>
>> Basis/Database folks? Have you checked on OSS? There is a general
<br>
>> consolidated OSS note (#706478) on large tables that mentions
table (<br>
>> SWWCNTP0). <br>
>><br>
>> If you run the report RSWIWADO how many workflow runtime tables
are <br>
>> showing up in green, yellow or red? (By the way you might
choose to run <br>
>> this report during an off-peak time just in case it takes a long
time!)<br>
>><br>
>> I hope this helps.<br>
>><br>
>><br>
>> --------------------------------------------------------------------------<br>
>> Edwin Mukusha<br>
>> Administrative Systems Group<br>
>> University of Nebraska<br>
>> Phone: (402) 472-7756 Fax: (402) 472-7390 <br>
>> Email: emukusha@nebraska.edu <br>
>> --------------------------------------------------------------------------<br>
>><br>
>><br>
>><br>
>><br>
>> "Ritapac" <ritapac2004@libero.it> <br>
>> Sent by: sap-wug-bounces@mit.edu<br>
>> 07/06/2006 09:13 AM<br>
>> Please respond to<br>
>> "SAP Workflow Users' Group" <sap-wug@mit.edu><br>
>><br>
>><br>
>> To<br>
>> "sap-wug" <sap-wug@mit.edu><br>
>> cc<br>
>><br>
>> Subject<br>
>> Performance problem on SWWCNTP0 tables<br>
>><br>
>><br>
>><br>
>><br>
>><br>
>><br>
>> Hello everybody,<br>
>> my system is 4.7 (620 - SP lev. 0050).<br>
>> Each activity on Workitems (log, execution,..) takes long long
time, so <br>
>> the system performance are devastated; the performance trace (ST05)
get a <br>
>> very long time on select in SWWCNTP0 table, but we have done all
the <br>
>> activity to delete completed WI, reorg WF tables, upgrade kernel,
and so <br>
>> on.<br>
>> It seems that the select on this table is not optimized, but we
haven't <br>
>> found any solution for this problem.<br>
>> Do you have any idea about that?<br>
>><br>
>> Thanks in advance for your help.<br>
>> Ritapac<br>
>><br>
>><br>
>><br>
>><br>
>><br>
>> _______________________________________________<br>
>> SAP-WUG mailing list<br>
>> SAP-WUG@mit.edu<br>
>> http://mailman.mit.edu/mailman/listinfo/sap-wug<br>
>><br>
>><br>
> <br>
> <br>
> _______________________________________________<br>
> SAP-WUG mailing list<br>
> SAP-WUG@mit.edu<br>
> http://mailman.mit.edu/mailman/listinfo/sap-wug<br>
<br>
_______________________________________________<br>
SAP-WUG mailing list<br>
SAP-WUG@mit.edu<br>
http://mailman.mit.edu/mailman/listinfo/sap-wug<br>
</font></tt>
<br>