Extractor for EWA

[tomtomb]

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

[JaredS · Accepted solution]

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

[tomtomb]

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 ...

[JaredS]

Hi Thomas,

I would suggest you refer to the note below to help optimize the BI infocubes on Solution Manager

https://launchpad.support.sap.com/#/notes/1480588

[patelyogesh]

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

[tomtomb]

Hi

Sorry, I answered to my post instead of your answer.

Thomas