Help for Foxhound 1.3738b

Table of Contents    [RisingRoad]


6. The Alerts Criteria Page

An alert is a message automatically displayed and/or sent via email whenever one or more target database conditions match user-defined criteria. The Alerts Criteria page lets you specify these criteria for a particular target database. Individual criteria may include a threshold amount and/or a duration or waiting period.

An alert may be issued as soon as a condition is met (e.g. Alert #9), when a threshold has been reached (e.g. Alert #5) or it may include a waiting period such as "for 10 or more recent samples" (e.g. Alert #2).

An all clear is issued when the alert criteria is no longer met. If a waiting period is specified, Foxhound waits for approximately half that time before issuing the all clear.

A cancelled message is issued as soon as some alert criteria is changed or disabled using this page. At that point the alert testing process "starts over"; it doesn't matter what the change is. For example, even if the new alert condition is already met when the change is made, if there is a waiting period it is honored before a new alert is issued.

The Database Monitor must be running for a target database in order for the alerts to be produced for that database.

The Alerts Criteria Menu

Save and restore Alerts Criteria defaults.

Send alert emails.

Display alerts.

Alert #1. Foxhound has been unable to gather samples for [1m] or longer.
Alert #2. The heartbeat time has been [1.0s] or longer for [10] or more recent samples.
Alert #3. The sample time has been [10s] or longer for [10] or more recent samples.
Alert #4. The CPU time has been [90]% or more for [10] or more recent samples.
Alert #5. The free disk space on the drive holding the main database file has fallen below [1GB].

Alert #6. The free disk space on the drive holding the temporary file has fallen below [1GB].
Alert #7. The free disk space on the drive holding the transaction log file has fallen below [1GB].
Alert #8. The free disk space on one or more drives holding other database files has fallen below [1GB].
Alert #9. The high availability target database has become disconnected from the arbiter server.
Alert #10. The high availability target database has become disconnected from the partner database.

Alert #11. The high availability target database server has switched over to [server2].
Alert #12. The high availability target database has changed from [read only] to [updatable].
Alert #13. There are [1000] or more fragments in the main database file.
Alert #14. The number of requests waiting to be processed has reached [5] or more for [10] or more recent samples.
Alert #15. The current number of incomplete file I/O operations has reached [256] or more for [10] or more recent samples.

Alert #16. There have been [1000] or more disk and log I/O operations per second for [10] or more recent samples.
Alert #17. The Checkpoint Urgency has been [100] % or more for [10] or more recent samples.
Alert #18. The Recovery Urgency has been [1000] % or more for [10] or more recent samples.
Alert #19. The cache has reached [100] % of its maximum size for [10] or more recent samples.
Alert #20. The cache satisfaction (hits/reads) has fallen to [50] % or lower for [10] or more recent samples.

Alert #21. The total temporary file space used by all connections has been [1G] or larger for [10] or more recent samples.
Alert #22. At least one single connection has used [500M] or more of temporary file space during [10] or more recent samples.
Alert #23. The number of blocked connections has reached [10] or more during [10] or more recent samples.
Alert #24. At least one single connection has blocked [5] or more other connections during [10] or more recent samples.
Alert #25. The number of locks has reached [1,000,000] or more during [10] or more recent samples.

Alert #26. The number of connections has reached [1000] or more for [10] or more recent samples.
Alert #27. The approximate CPU time has reached [25] % of elapsed time or more for at least one connection during [10] or more recent samples.
Alert #28. The transaction running time has reached [1m] or more for at least one connection during [10] or more recent samples.
Alert #29. There have been [1] or more cache panics in [10] or more recent samples.


The Alerts Criteria Menu    [Top]

The DSN: / Connection String: title shows the name of the DSN or Connection String of the target database to which these Alerts Criteria apply.

If the target database GlobalDBId property is set to a non-default value, that value will be shown in (parentheses) after the DSN: or Connection String: title. This makes it easier to tell different remote databases apart in a replicating or synchronizing environment.

The New Menu link opens the Foxhound Menu page in a new browser window or tab.

The Foxhound Options link opens the Foxhound Options page in a new browser window or tab, where you can fill in the email server settings for sending Alert emails.

The Help link is a context-sensitive link to this Help topic.

The About link opens the About Foxhound page in a new browser window or tab.

The button hides this Help frame from view, and brings it back.


Save and restore Alerts Criteria defaults.    [Top]

The button does two things:

The button does two things:

The button does two things:

The button does two things:


Send alert emails.    [Top]

The Send alert emails checkbox specifies whether or not you want Alert and All Clear emails to be sent.

Use the Email address(es) for Alerts: field to specify one or more email addresses, separated by semicolons, that are to receive the Alert and All Clear alerts.

Click on the Use HTML in emails: checkbox if you want the email alerts to be formatted using HTML.

The Host[:port] for URLs in emails: field may be used to specify where the Foxhound web server is located relative to the computer receiving the emails, so that HTML links pointing to Foxhound History pages from inside the email alerts can find the right web pages. The default is localhost which works if the emails are being received on the same computer that's running Foxhound. If you start Foxhound on some port other than 80, you can specify a value like localhost:12345. If Foxhound is running on a different computer you'll have to change localhost to that computer's domain name or IP address; e.g., xyz.com:12345.

Note: You must click on one of the buttons if you want the your changes to be saved.


Display alerts.    [Top]

The Display alerts checkbox specifies whether or not you want the following messages to appear on the Monitor Database and History pages:

Note: You must click on one of the buttons if you want the your changes to be saved.


Alert #1. Foxhound has been unable to gather samples for [1m] or longer.    [Top]

The Alert #1 enabled checkbox specifies whether or not you want Foxhound to check for this condition.

The "unable to gather samples for xxx" duration uses the "d h m s" input format; e.g., 1m for one minute, 10s for ten seconds, 3d for three days, 1h 30m for one hour and 30 minutes.

This alert is based on measurements made by Foxhound itself.

Note: You must click on one of the buttons if you want the your changes to be saved.


Alert #2. The heartbeat time has been [1.0s] or longer for [10] or more recent samples.    [Top]

The Alert #2 enabled checkbox specifies whether or not you want Foxhound to check for this condition.

The "heartbeat time has been xxx" duration uses the "d h m s" input format; e.g., 10s for 10 seconds, 3d for 3 days, 1h 30m for 1 hour and 30 minutes.

This alert is based on measurements made by Foxhound itself.

The "for xxx or more recent samples" text box contains a count of samples taken by the Foxhound Database Monitor.

Note: You must click on one of the buttons if you want the your changes to be saved.


Alert #3. The sample time has been [10.0s] or longer for [10] or more recent samples.    [Top]

The Alert #3 enabled checkbox specifies whether or not you want Foxhound to check for this condition.

This alert is based on measurements made by Foxhound itself.

Note: You must click on one of the buttons if you want the your changes to be saved.


Alert #4. The CPU time has been [90]% or more for [10] or more recent samples.    [Top]

The Alert #4 enabled checkbox specifies whether or not you want Foxhound to check for this condition.

This alert is based on the following properties: NumLogicalProcessorsUsed, NumProcessorsAvail, NumProcessorsMax and ProcessCPU.

Note: You must click on one of the buttons if you want the your changes to be saved.


Alert #5. The free disk space on the drive holding the main database file has fallen below [1GB].    [Top]

The Alert #5 enabled checkbox specifies whether or not you want Foxhound to check for this condition.

This alert is based on the sa_disk_free_space system procedure. This alert is not produced if the free disk space drops to exactly zero because that is most likely a problem with the sampling process itself.

Note: You must click on one of the buttons if you want the your changes to be saved.


Alert #6. The free disk space on the drive holding the temporary file has fallen below [1GB].    [Top]

The Alert #6 enabled checkbox specifies whether or not you want Foxhound to check for this condition.

This alert is based on the sa_disk_free_space system procedure. This alert is not produced if the free disk space drops to exactly zero because that is most likely a problem with the sampling process itself.

Note: You must click on one of the buttons if you want the your changes to be saved.


Alert #7. The free disk space on the drive holding the transaction log file has fallen below [1GB].    [Top]

The Alert #7 enabled checkbox specifies whether or not you want Foxhound to check for this condition.

This alert is based on the sa_disk_free_space system procedure. This alert is not produced if the free disk space drops to exactly zero because that is most likely a problem with the sampling process itself.

Note: You must click on one of the buttons if you want the your changes to be saved.


Alert #8. The free disk space on one or more drives holding other database files has fallen below [1GB].    [Top]

The Alert #8 enabled checkbox specifies whether or not you want Foxhound to check for this condition.

This alert is based on the sa_disk_free_space system procedure. This alert is not produced if the free disk space drops to exactly zero because that is most likely a problem with the sampling process itself.

Note: You must click on one of the buttons if you want the your changes to be saved.


Alert #9. The high availability target database has become disconnected from the arbiter server.    [Top]

The Alert #9 enabled checkbox specifies whether or not you want Foxhound to check for this condition.

This alert is based on the ArbiterState property.

Note: You must click on one of the buttons if you want the your changes to be saved.


Alert #10. The high availability target database has become disconnected from the partner database.    [Top]

The Alert #10 enabled checkbox specifies whether or not you want Foxhound to check for this condition.

This alert is based on the PartnerState property.

Note: You must click on one of the buttons if you want the your changes to be saved.


Alert #11. The high availability target database server has switched over to [server2].    [Top]

The Alert #11 enabled checkbox specifies whether or not you want Foxhound to check for this condition.

This alert is based on the ServerName property.

Note: You must click on one of the buttons if you want the your changes to be saved.


Alert #12. The high availability target database has changed from [read only] to [updatable].    [Top]

The Alert #12 enabled checkbox specifies whether or not you want Foxhound to check for this condition.

This alert is usually raised when Foxhound is monitoring the read-only secondary HA database and a failover occurs. Foxhound remains connected to the same database, which is now the primary database, and the mode has changed from read-only to updatable. This alert is cleared as soon as all three HA servers become operational. Foxhound does not wait for the mode to change back to its original value.

This alert is based on the ReadOnly property.

Note: You must click on one of the buttons if you want the your changes to be saved.


Alert #13. There are [1000] or more fragments in the main database file.    [Top]

The Alert #13 enabled checkbox specifies whether or not you want Foxhound to check for this condition.

This alert is based on the DBFileFragments property.

Note: You must click on one of the buttons if you want the your changes to be saved.


Alert #14. The number of requests waiting to be processed has reached [5] or more for [10] or more recent samples.    [Top]

The Alert #14 enabled checkbox specifies whether or not you want Foxhound to check for this condition.

This alert is based on the UnschReq property.

Note: You must click on one of the buttons if you want the your changes to be saved.


Alert #15. The current number of incomplete file I/O operations has reached [256] or more for [10] or more recent samples.    [Top]

The Alert #15 enabled checkbox specifies whether or not you want Foxhound to check for this condition.

This alert is based on the CurrIO property.

Note: You must click on one of the buttons if you want the your changes to be saved.


Alert #16. There have been [1000] or more disk and log I/O operations per second for [10] or more recent samples.    [Top]

The Alert #16 enabled checkbox specifies whether or not you want Foxhound to check for this condition.

This alert is based on the DiskRead, DiskWrite and LogWrite properties.

Note: You must click on one of the buttons if you want the your changes to be saved.


Alert #17. The Checkpoint Urgency has been [100] % or more for [10] or more recent samples.    [Top]

The Alert #17 enabled checkbox specifies whether or not you want Foxhound to check for this condition.

This alert is based on the CheckpointUrgency property.

Note: You must click on one of the buttons if you want the your changes to be saved.


Alert #18. The Recovery Urgency has been [1000] % or more for [10] or more recent samples.    [Top]

The Alert #18 enabled checkbox specifies whether or not you want Foxhound to check for this condition.

This alert is based on the RecoveryUrgency property.

Note: You must click on one of the buttons if you want the your changes to be saved.


Alert #19. The cache has reached [100] % of its maximum size for [10] or more recent samples.    [Top]

The Alert #19 enabled checkbox specifies whether or not you want Foxhound to check for this condition.

This alert is based on the CurrentCacheSize and MaxCacheSize properties.

Note: You must click on one of the buttons if you want the your changes to be saved.


Alert #20. The cache satisfaction (hits/reads) has fallen to [50] % or lower for [10] or more recent samples.    [Top]

The Alert #20 enabled checkbox specifies whether or not you want Foxhound to check for this condition.

This alert is based on the CacheHits and CacheRead properties.

Note: You must click on one of the buttons if you want the your changes to be saved.


Alert #21. The total temporary file space used by all connections has been [1G] or larger for [10] or more recent samples.    [Top]

The Alert #21 enabled checkbox specifies whether or not you want Foxhound to check for this condition.

This alert is based on the TempFilePages property.

Note: You must click on one of the buttons if you want the your changes to be saved.


Alert #22. At least one single connection has used [500M] or more of temporary file space during [10] or more recent samples.    [Top]

The Alert #22 enabled checkbox specifies whether or not you want Foxhound to check for this condition.

This alert is based on the TempFilePages property.

Note: You must click on one of the buttons if you want the your changes to be saved.


Alert #23. The number of blocked connections has reached [10] or more during [10] or more recent samples.    [Top]

The Alert #23 enabled checkbox specifies whether or not you want Foxhound to check for this condition.

This alert is based on the BlockedOn property.

Note: You must click on one of the buttons if you want the your changes to be saved.


Alert #24. At least one single connection has blocked [5] or more other connections during [10] or more recent samples.    [Top]

The Alert #24 enabled checkbox specifies whether or not you want Foxhound to check for this condition.

This alert is based on the BlockedOn property.

Note: You must click on one of the buttons if you want the your changes to be saved.


Alert #25. The number of locks has reached [1,000,000] or more during [10] or more recent samples.    [Top]

The Alert #25 enabled checkbox specifies whether or not you want Foxhound to check for this condition.

This alert is based on the LockCount property.

Note: You must click on one of the buttons if you want the your changes to be saved.


Alert #26. The number of connections has reached [1000] or more for [10] or more recent samples.    [Top]

The Alert #26 enabled checkbox specifies whether or not you want Foxhound to check for this condition.

This alert is based on the ConnCount property.

Note: You must click on one of the buttons if you want the your changes to be saved.


Alert #27. The approximate CPU time has reached [25] % of elapsed time or more for at least one connection during [10] or more recent samples.    [Top]

The Alert #27 enabled checkbox specifies whether or not you want Foxhound to check for this condition.

This alert is based on the ApproximateCPUTime property.

Note: You must click on one of the buttons if you want the your changes to be saved.


Alert #28. The transaction running time has reached [1m] or more for at least one connection during [10] or more recent samples.    [Top]

The Alert #28 enabled checkbox specifies whether or not you want Foxhound to check for this condition.

This alert is based on the TransactionStartTime property.

Note: You must click on one of the buttons if you want the your changes to be saved.


Alert #29. There have been [1] or more cache panics in [10] or more recent samples.    [Top]

The Alert #29 enabled checkbox specifies whether or not you want Foxhound to check for this condition.

This alert is based on the CachePanics property.

Note: You must click on one of the buttons if you want the your changes to be saved.

[Top]



























































[Top]