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

 

 

Like (3) Reply
Replies (6)

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

Like (0) Reply

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

 

 

Like (0) Reply

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

Like (0) Reply

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

Hi Muralikrishnan,

It works perfectly.  Thanks again for your help.

Anderson

 

 

Like (0) Edit Delete Reply

Re:

Hello,

We have a specific client that has oracle 11g, but I would like to collect specific metrics as we can see oracle-base.com/dba/scripts

Would it be possible to develop in the python plugin to obtain these metrics? It would be interesting to just create a directory of .sql files where the python script runs.

 

Regards,

Fernando Oliveira

Like (0) Reply

Re: Re:

Hi Fernando,

We support Oracle Monitoring using our Python plugin. Refer our documentation to know the metrics and steps to install the plugin.  

 

If you want to monitor the result of a specific query, you can customize the existing plugin to include the metrics you are looking for.

If you need our assistance in this process, please share with us the list of metrics that you would like to monitor and the corresponding query output for the same.

Hope this helps. 

 

Regards,

Sriram

Like (0) Reply

Was this post helpful?