Types of metrics and alerts

The following list describes the metrics that are available for your resource in the Configure Resource window: Metrics tab.

  • CPU Usage (High Collection Interval)   Select this option to collect metrics about the database CPU usage. You can view these metrics on the CPU tab. See Monitoring tab: CPU tab.

    • Alert When CPU Use Reaches X% For Two Collection Intervals In A Row   Issue an alert when the CPU use reaches the specified percentage. The default is 95 percent.

  • Memory Usage (High Collection Interval)   Select this option to collect metrics about the cache. You can view these metrics on the Memory tab. See Monitoring tab: Memory tab.

    • Alert When Memory Usage Reaches X%   Issue an alert when the memory usage of the resource reaches the specified percentage. The default is 85 percent.

  • Disk Usage (High Collection Interval)   Select this option to collect metrics about the database's dbspaces, as well as disk reads and writes. You can view these metrics on the Disk tab. See Monitoring tab: Disk tab.

    • Alert When Free Disk Space Per Dbspace Is Less Than X Megabytes   Issue an alert when the free disk space per dbspace is less than the specified amount. The default is 100 MB.

  • Connections (High Collection Interval)   Select this option to collect metrics about connections. You can view these metrics on the Connections tab. See Monitoring tab: Connections tab.

    • Alert When A Connection Has Been Blocked For Longer Than X Seconds   Issue an alert when a connection has been blocked for longer than the specified time. The default is 10 seconds.

  • Connection Count (Medium Collection Interval)   Select this option to collect metrics about the number of connections. You can view these metrics on the Connections tab. See Monitoring tab: Connections tab.

    • Alert When The Number Of Connections In Use Reaches X % Of The License Limit   Issue an alert when the number of connections in use reaches the specified percentage of the license limit. The default is 85 percent.

  • Queries Processed (High Collection Interval)   Select this option to collect metrics on the rate that queries are processed. You can view these metrics on the Queries tab. See Monitoring tab: Queries tab.

  • Long Running Query (Medium Collection Interval)   Select this option to collect metrics on the long running queries. You can view these metrics on the Queries tab. See Monitoring tab: Queries tab.

    • Alert When A Query Has Run For Longer Than X Seconds   Issue an alert when a query has run for longer than the specified time. The default is 10 seconds.

  • Failed Connections (Medium Collection Interval)   Select this option to collect metrics about failed connections. You can view these metrics on the Failed Connections tab. See Monitoring tab: Failed Connections tab.

  • HTTP Server Usage (Medium Collection Interval)   Select this option to collect metrics about the HTTP server usage. You can view these metrics on the HTTP tab. See Monitoring tab: HTTP tab.

  • Mirror Information (Medium Collection Interval)   Select this option to collect metrics about database mirroring. You can view these metrics on the Mirror tab. See Monitoring tab: Mirror tab.

  • Unscheduled Requests (High Collection Interval)   Select this option to collect metrics about unscheduled requests. You can view these metrics on the Unscheduled Requests tab. See Monitoring tab: Unscheduled Requests tab, and Troubleshooting the Monitor.

    • Alert When The Number Of Unscheduled Requests Reaches X   Issue an alert when the number of unscheduled requests reaches the specified amount. The default is 5.

  • Suppress Alerts For The Same Condition That Occur Within X Minutes   Select this option to prevent receiving duplicate alerts within a specified time. The default is 30 minutes.