Installed objects

The following table lists the objects that are installed when you monitor a SQL Anywhere database.

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 DBA 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 and it does not have administrator privileges.
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 gather a count of the number of unsubmitted crash reports.

Because the database objects are owned by a single owner, you can delete all of them by executing the following statement:

DROP USER sa_monitor_user;

To reinstall the database objects, see Repair database resources.

Discuss this page in DocCommentXchange.
Send feedback about this page using email.