Skip to Content

Hello Everyone,

I decided to create this short guide on how to analyze the EXPORT_TOO_MUCH_DATA dumps in SAP_COLLECTOR_FOR_PERFMONITOR.

We need the following in order to precisely analyze this kind of dump.

1) Full dump details (You can also find this in ST22).

2) Access to SE16 to check the entries in the SWNCMONI table.

In the dump details you can always see two important sections for this analysis.

The first one is easily found under “AGGTYPE” in the dump details as you can see below.

AGGTYPE

4

WQ <<<

This is the profile name which SAP_COLLECTOR_FOR_PERFMONITOR was doing the TOTAL calculation.

There is a strong indication that this profile is the responsible for the dumps.

The second one is found under “I_MONIKEY-PERIODSTRT” as you can see below.

N0 I_MONIKEY-PERIODSTRT

L0 16

V0 20131001 <<<

This is showing us what is the period on which the SAP_COLLECTOR_FOR_PERFMONITOR generated the dump while creating the TOTAL.

For the next steps please refer to the SAP Note 1110822.

1110822 – Workload collector: Reducing the size of aggregates

The SWNC_COLLECTOR_COMPRESSION report should be used in order to compress the data associated to the profiles with more than 15 thousand entries

in the table SWNCMONI.

Data you have collected should be entered as per the below screenshot in SE16, after this you can use the button “Number of Entries” to check how many

entries exist each of the profiles. The profile names are WD, WF, WJ, WM, WO, WP, WQ, VA, VB, VC, VD, VE, VO,VV.

/wp-content/uploads/2013/12/blogperf_348533.png

After compressing all the needed profiles run the report SWNC_COLLECTOR_RECOMPRESS one time manually as per the SAP Note 1110822.

In case the dumps are happening to the current month calculation, the effects of the compressions will only appear in the next month and the dump

will disappear in two weeks.

You check once again the number of entries in SWNCMONI table to make sure there is an expected number of entries for each profile (less than 15 thousand entries for each one).

Hope you like it,

Cheers,

Daniel

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

  1. Sean Collins

    Great Guide Daniel.

    Our SAP_COLLECTOR_PERFMON_SWNCTOTAL job suddenly started short dumping and following your guide I identified the root cause. (WQ).

    Read through the OSS Note, and all sorted now.

    Many thanks.

    Sean.

    (0) 

Leave a Reply