Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » Database monitoring » SQL Anywhere Monitor


List of database objects installed by the Monitor

The following table lists the objects that are installed when you add a database as a resource to be monitored.

Object name Object type Description
sa_monitor_user Database user This read-only user is added to the database to collect metrics. Because this user is added to the database being monitored, it is not necessary to store the user credentials anywhere outside the database that is being monitored. It may be necessary to allow sa_monitor_user to bypass password verification. The sa_monitor_user has a random password known only to the Monitor. This user has the following privileges in the database: CREATE EXTERNAL REFERENCE, MONITOR, MANAGE ANY DBSPACE, BACKUP DATABASE.
sa_monitor_connection_failure Table

This table contains metrics about failed connection attempts, and is used with sa_monitor_connection_failed_event. The metrics in this table are deleted as metrics are retrieved from the Monitor.

sa_monitor_connection_failed_event Event This event fires on the ConnectFailed system event (every time a connection attempt fails), and inserts a record into the sa_monitor_connection_failure table.
sa_monitor_count_unsubmitted_crash_reports Function This function calls the xp_srvmon_count_unsubmitted_crash_reports procedure to determine the number of unsubmitted crash reports.
 Deleting monitoring objects
 Reinstalling monitoring objects