How do I setup threshold on sp_monitorconfig metadata in ASE 16.x?

[Former Member]

Greetings,

     How do I setup threshold on sp_monitorconfig metadata in ASE 16.x? So I have alerts on the event.

Thanks,

Sid.

[former_member89972]

Sid

For storage space management SAP/Sybase has provided sp_thresholdaction mechanism.

This allows you to customize space usage/free thresholds and corresponding action as your site may need.

Unfortunately for metadata usage / over-usage there is no such mechanism for you to customize.

So you can pretty much write your own script(s) for the logic and schedule your job(s) accordingly.

Unlike space issue, metadata over usage in most cases is NOT a show stopper.  Server will survive with some messages in ASE error log.

HTH

Avinash

[former_member188958]

I don't think there is any way you can set a direct threshold.

You could use a cron job / Job Scheduler task to check the values on a regular basis.

Some of the values do put warning messages in the errorlog when scavenging starts to happen and these can be picked up by an errorlog monitor.

[Former Member]

Thanks Bret.

Thinking that ASE has worked on such feature already I Was trying to replace our existing cron job with similar logic you suggested.

Thank You,

Sid.