Skip to Content

Extractor for EWA

Hello,

We've been through the configuration of all our managed systems on our Solution Manager 7.2. Since we have many customers system configured, it appears that the extractors are collecting a huge amount of data and the DB keeps growing of 50Gb a month. This is a problem for us.

In our SOlMan system we only intend to run the EWA and no other solution.

Would it be possible to deactivate all the extractors or some of them or all the extractors are necessary for the EWA ?

Thanks for your help

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    Aug 27, 2018 at 02:51 PM

    Hi Thomas,

    The EWA process itself doesn't collect performance data but rather reads data already existing such as those coming from the SMD Agent to the extractor framework on Solution Manager. Those are stored in the BW database in infocubes.

    The EWA process does store EWA session data in certain tables but those are not extractor data.

    If you have the name of the table that is growing, then I would suggest you let us know here so we can be of more help.

    To also confirm the prior reply, the EWA requires performance / workload data either from ST03 / ST06 or preferably from BW (SMD extractor). So in summary the best approach is not to disable the collection of data but rather to maintain the database so that it is growing at an optimal rate.

    Jared

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 27, 2018 at 02:03 PM

    Hello Thomas Bouaissier,

    I do not think you can pick and choose.

    I would suggest you mail out earylwatch alerts via email and keep cleaning data in SAP solution manager system

    SAP note below will provide you more details

    894279 - Background processing in SAP Solution Manager

    Look for all the cleanup processes and run them according to your requirnments.

    Thank you

    Yogesh

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 28, 2018 at 07:48 AM

    Hello

    Thanks guys for your answer, then I won't deactivate any extractor and I will have a look to this long OSS Note.

    By the meantime the fastest growing tables are:

    /BI0/ASMD_PEH00 - about 260Mo a month

    /BI0/ASMD_PED00 - about 125Mo a month

    all those tables and more - about 10 to 60Mo a month

    /BI0/ACCMDAWWD00 /BI0/ACCMDAWDH00 /BI0/ACCMDAWMD00 /BI0/ACCMDAWDD00 /BI0/ACCMRSDH00 /BI0/ACCMRSMD00 /BI0/ACCMRSWD00 /BI0/ACCMRSDD00 /BI0/ACCMRCDH00 /BI0/ACCMRCDD00 /BI0/ACCMRCMD00 /BI0/ACCMRCWD00 /BI0/ACCMRDDH00 /BI0/ACCMWSMD00 /BI0/ACCMWSDH00 /BI0/ACCMWSDD00 /BI0/ACCMWSWD00 /BI0/ACCMRTMD00 /BI0/ACCMRDWD00 /BI0/ACCMRTDH00 /BI0/ACCMRTDD00 /BI0/ACCMRTWD00 /BI0/ACCMRDDD00 /BI0/ACCMRDMD00 /BI0/ACCMEXDH00 /BI0/F0CCMEXDH2 /BI0/ACCMEXMD00 /BI0/F0CCMAWDH2 /BI0/F0CCMAWWD1 /BI0/ACCMEXDD00 /BI0/ACCMEXWD00 ...


    Add comment
    10|10000 characters needed characters exceeded