Go to All Forums

Alerting on Database Metrics

Hi there,

I'd like to make a feature request.

I was thinking it would be good if we can configure thresholds for alerting on database metrics.  The transaction time would be the one of primary interest as it can give a indication of a wide range of underlying issues (deadlocks, hardware constraints etc.).

Other alerts can then help to pinpoint the issue.

Thanks as always,

Anderson

 

 

Reply 1
Replies (4)

Re: Alerting on Database Metrics

Hi ,

 

Could you specify the RDBMS that you are monitoring? This would help us assist you further in configuring alerts for your database.

 

 

Regards,

Muralikrishnan

Reply 0

Re: Re: Alerting on Database Metrics

Hi Muralikrishnan,

In my instance the database is Microsoft SQL server but Oracle support in the future would be nice as well.

Thanks and best regards,

Anderson

 

 

Reply 0

Re: Re: Re: Alerting on Database Metrics

Hi Anderson,

For SQL Server monitor, we already have option to trigger alerts for Database metrics 'Transaction Time' and 'Dead locks'. 

Please follow the steps to configure the threshold for the above metrics.
1. Login to Site24x7 account.

2. Goto Server -> Microsoft SQL Server -> SQL Server monitors will be listed.

3. Goto the SQL Server monitor, where you would like to configure the alert.

4. In the SQL Server monitor detail page, user can find a Hamburger Menu. Goto the Menu and select Edit.

5. In the 'Edit Microsoft SQL Server Monitor', goto 'Threshold and Availability' and click Edit.


6. In the 'Edit Threshold Profile' page, under 'Threshold Configuration' user can Set Threshold Values for Transaction Time and Dead locks.

 Regarding Oracle Database monitoring, we have a plugin to monitor its performance. The details of the Plugin as follows.

 https://www.site24x7.com/plugins/oracle-monitoring.html

For any further clarification, please reply the post.

 

Thanks,

Muralikrishnan

Reply 0

Re: Re: Re: Re: Alerting on Database Metrics

Hi Muralikrishnan,

It works perfectly.  Thanks again for your help.

Anderson