Fast growing database after activating technical monitoring

[Private_Member_19084]

Hi experts,

we have activated technical monitoring in our solman for around 10 managed systems.

Now we are facing the problem, that the database is growing very fast - around 1gb per day.

My question is, what can I do against this fat growing database?
We use the standard configuration of technical monitoring data holding.

minute = 7 days

hour = 31 days

day = 100 days

week = 52 weeks

month = 47 months

We have activated the technical monitoring a few weeks ago.

And at the beginning, I thought this is normal and the fast growing is just at the beginning.

So that after one week the growing will be constant, as I think the "minutes"-data will be the biggest amound of data.

(so at day 8 data of day 1 will be deleted).

But as it is since a few weeks no stopping to grow fast, I need help.

Thx in advance

[Former Member · Accepted solution]

Hello Christian,

What is the DB being used in the system ? Can you check which are the largest growing tables in your Database ( DB02 ) & Post it here ?

Regards,

Mudasir

[Former Member · Accepted solution]

Hello,

Can you check the below link. It shows the procedure to reduce the size of few solman tables. See if it is applicable in your case.

Link :  http://scn.sap.com/community/it-management/alm/solution-manager/blog/2012/07/17/how-to-reduce-the-si...

Mudasir.

[Private_Member_19084 · Accepted solution]

Thx for help.

However, SA* tables are not really big (500k and 1600k entries).

Kind regards

[Private_Member_19084 · Accepted solution]

we are using Sybase ASE.

[Private_Member_19084]

Thank you very much again to everyone for great support on this issue.

At the moment I think, that this growing is normal on activating the technical monitoring.

We are facing a growing of around 10gb in 2 month.

And this since a few month

I hope that the growing will get lower.

Kind regards

[Former Member]

Hi everyone,

FYI: I was also in the situation of trying to recoup some freespace following a recent SolMan 7.1 stack (10) update.  I went first to my weekly Solution Mgr EWA report and found table ALRT_NGTRACE at the top of the list in section "Top Growing Tables".  It had grown 2.6G in the last 4 weeks.  A quick OSS search found one Note, 1939567 - Table ALRT_NGTRACE shows heavy growth.  Using the Solution in the Note, which involved SE14, I was able to recoup 2.7G in a matter of minutes.  It also includes code corrections; apparently it fixes the issue of where "Traces are written in metric store though tracing is switched off".  Good luck.

http://service.sap.com/sap/support/notes/1939567

Jim Cleek

HP Enterprise Services

SAP Basis Support

[Private_Member_19084]

Hi Jim,

thx for help.

however, Table ALRT_NGTRACE is empty.

Kind regards

[Private_Member_19084]

hmmm..

I've checked the growing of the db again.

Regarding the data-settings.

minute = 7 days

hour = 31 days

day = 100 days

week = 52 weeks

month = 47 months

So for me this means, that the first 7 days the database has to grow extreme, as more than 10 000 (7days x 24 hours x 60 minutes) datasets will be created for most of the metrics.

But after 7 days the growing has decrease enormous, as no more "minutes"-records will be created, just replace.

But for me it seems,as the growing is not getting slower.

Does anyone know, if there is a possibilty to analyze what is causing this high amoungt of data-growing?

Kind regards

[roland_hennessy]

Hi Christian,

Can you confirm your SOLMAN SP level?

Can you make sure the following housekeeping jobs are running:

Job:                                                Report:

SAP_METRIC_STORE_CLEANUP    ACE_DELETE_EXPIRED_EVENTS

SAP_ALERT_HOUSEKEEPING        E2EA_HOUSEKEEPING

E2E EFWK HOUSEKEEPING          E2E_EFWK_HOUSEKEEPER

Kind regards,

Roland

[Private_Member_19084]

Hi Roland,

we use SP8.

Yes, the 3 jobs are running.

I think the first job will delete most of the data, in log I find a lot of deletions.

So it seems to work.

May it be, that this is normal?

What about your systems, what about the dayli growing in solman?

Regards

[Former Member]

Hi Chris,

Can you check this note if this is helpful?

546685 - Archiving in Solution Manager (operation)

Thanks,

Jagadish.

[Private_Member_19084]

Hi guys,

I've activated around 15 metrics per managed systems (5 system, 5 host and 5 database).

But I can't believe that this is generating this high amount of data.

Is there a kind of job which is doing reorganizing the data?

[Former Member]

Hi Chris,

Check the below link

http://scn.sap.com/docs/DOC-36375

4        General (Performance tuning)

Rg,

Karthik

[Private_Member_19084]

Hi Karthik,

this sounds very good.

I've implemented the note now.

I think, it will take a while because the job which is executed will not delete every time - right?

Btw, it is still growing around 1gb per day and only deleting around 200mb data.

Kind regards

[Former Member]

Hi Chris,

Also check the below note may be helpful

1835721  - Troubleshooting performance problems in Solution Manager

Rg,

karthik

[Private_Member_19084]

Thx, this is good.

The note 1770827 sounds as a good option.

However, I don't want to deactivate BW-Historie.

Because I would like to see the performance.

What about your system, do you also have this high amount of data-growing?

Kind regards

[Former Member]

Regarding metrics, from my experience, you should start little and then activate more and more if needed.

Like this you are more in control of what is happening in your system.

[bxiv]

What technical monitoring did you enable for your 10 servers?  If you enabled all of the metrics and your systems are triggering the thresholds or you are auto creating incidents, then this could be a reason for the growth.

I also believe your line of thinking about day 8 being a trigger to delete day 1 data is incorrect, you will loose specific values as SolMan will aggregate the values so you can review the data down the road to know when performance or issues started happening.