Submit a ticketCall us

Announcing NCM 7.7
With NCM 7.7, you can examine the rules that make up an access control list for a Cisco ASA device. Then you can apply filters to display only rules that meet the specified criteria, order the rules by line number or by the hit count, and much more.
See new features and improvements.

Home > Success Center > Database Performance Analyzer (DPA) > DPA 11.0 Administrator Guide > Alerts > Alert categories

Alert categories

Created by Anthony.Rinaldi_ret, last modified by Anthony.Rinaldi_ret on Sep 15, 2016

Views: 74 Votes: 0 Revisions: 6

You can use the out-of-the-box alerts in DPA, or customize them to meet your needs. There are four preconfigured DPA alert categories.

Wait Time

Wait Time alerts are based on the amount of time users or applications waited on the database. For example, the Average SQL Wait Time alert fires when a SQL statement causes wait time that exceeds a threshold. These alerts are critical because they ensure that you are only alerted when users and applications are affected.

Resources

These alerts are based on the alarm thresholds of resource metrics, such as CPU utilization and memory usage. For example, the Single Resource Metric alert notifies you when the values of the specified resource metric exceed the thresholds.

Administrative

Administrative alerts are typical alerts surrounding the health of the database system. For example, the Database Parameter Changes alert notifies you when any database parameter has changed. The Database Availability alert notifies you when the database instance is no longer accessible.

Custom

Custom alerts are user-specified queries that are run against the monitored database or the DPA repository. The query returns a number (or set of numbers) that may trigger an alert depending on user-defined threshold settings.

For example, you can enter a query to detect the number of canceled orders in the last 10 minutes:

select count(*) from orders where status='CANCELLED' and date > sysdate - 10/1440;

You can write a SQL query to set alerts on SQL Server health metrics.

You can see which type of orders have high cancellation rates:

select order_type, count(*) from orders where status='CANCELLED' and date > sysdate - 10/1440 group by order_type;

You may want to use complex logic to determine if an order has truly been canceled. In this case, you can write a function or procedure on the monitored database instance.

  • Oracle: select mycustomfunction(param1) from dual
  • SQL Server: select mycustomfunction(param1)
  • Sybase: mycustomprocedure(param1)
  • DB2: select dbo.mycustomfunction(param1) from SYSIBM.SYSDUMMY1
  • MySQL: mycustomprocedure(param1)
  • Azure SQL: select mycustomfunction(param1)

These functions or procedures are written in the native programming language of the database.

Last modified
13:58, 15 Sep 2016

Tags

Classifications

Public