on 12-06-2013 9:26 AM
Hi experts,
I would like to create a metric which shows the growing of a Database and also the growing of a filesystem (e.g. per hour).
Does anyone know how to create this kind of metric?
Thank you
It would also be useful info to provide with the host and DB platforms that you are working with; also a question for you, do the out of the box templates not provide the metrics that you are looking for in SolMan?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Billy,
oh yes, for sure.
We are using sybase and HP-UX.
The have a lot of metrics regarding space management.
But only about left space or used space.
But i also would like to have a check, which checks the growing.
You understand?
So maybe a file system check will create an alert by 500 mb and currently 2gb are available.
And at 3pm a colleague activates e.g. an audit-log which is creating a lot of data.
So durring the night the space would definitly not be enough.
In that case the alert regarding left space would react in the night.
But the growing-check would already react in time.
We already had some cases like this, that filesystems and db was growing unnormal.
Therefore I would like to have a check like this.
Kind regards
Hi Christian,
I agree there are many metrices available for Space Management. Using these metrices you can have the growth rate related alerts. For example there is this below metrc;
Filesystem Free Space Ratio: Free space available on all filesystems used by the SAP Sybase ASE database server measured in percent of the filesystem size.
If you set this alert (let's say 20%) then whenever the free space ratio falls below 20% then the alert would be triggered. In your case when the Audit log job fills up the DB/FS then at certain threshold (defined by you) alerting is triggered.
I suggest you to take a fresh look at all the available metrices under Sybase template.
Regards,
Vivek
Follow SAP Note 1480588 - ST: E2E Diagnostics - BI Housekeeping - Information
You can also go through the link
I'm not sure what graphic you have in mind?
Also not sure about the alert-limit; lets say you put in 50 Mb for value increases more, I'm not sure if the time frame is when you apply the alert or it bases the 50 Mb increase upon the data collection point...Off the top of my head I would lean towards 50 Mb increase upon data collection.
As a test you could set the data collection to 5 min and set 25, 50, 100 Mb values in the threshold, turn off auto incidents/notifications/etc, watch the alert inbox to see if the threshold is triggered. Then verify if it triggers again with the same 25, 50, 100 value or if it just tacks on to the original.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.