By default, the Monitor performs maintenance on the metrics once a day at midnight. Maintenance affects metrics, not alerts.
As an administrator, you can:
Schedule the Monitor to back up metrics.
Control the amount of disk space that the Monitor uses.
Perform maintenance on demand.
Log in to the Monitor as an Administrator.
Select Configuration, and then click Edit.
Specify a time (24-hour clock) when the Monitor should perform maintenance. By default, it performs maintenance at midnight. The time is local to the computer where the Monitor is running. See Understanding how time is displayed.
Specify a directory where the Monitor should save the backed up data. The directory must exist on the computer where the Monitor is running.
Customize the Data Reduction settings:
Reduce Metrics To A Representative Daily Value For Metrics Older Than When you select this option, an average is taken for all numeric metrics that are older than the specified number of days, and then the numeric metrics are deleted. Non-numeric metrics are not deleted.
Delete Values Older Than When you select this option, all metrics that are older than the specified length of time are deleted.
Delete Old Metrics When The Total Disk Space Used By The SQL Anywhere Monitor Becomes Greater Than (MB) When you select this option, you specify the maximum amount of space that can be used to store the metrics. When the amount of disk space used reaches or exceeds the amount specified, the Monitor deletes metrics, starting with the oldest metrics. Metrics are deleted until enough free space exists to store new metrics.
Click Perform Maintenance Now to run the backup immediately. When prompted, click OK.
The following procedure describes how to replace the Monitor database with a backup copy.
Stop the Monitor, if it is running.
From your backup directory, copy the samonitor.db database file and samonitor.log log file.
Paste these files into the directory where the current Monitor database and log file are located. When prompted, overwrite the existing files.
The default locations of the version 12.0.0 Monitor database files are listed in the following table:
|Operating system||Monitor directory|
Windows XP (installed with SQL Anywhere)
|Windows XP (installed on a separate computer)||
|Windows Vista (installed with SQL Anywhere)||
|Windows Vista (installed on a separate computer)||
|Linux (installed with SQL Anywhere)||
|Linux (installed on a separate computer)||
Re-start the Monitor.
Discuss this page in DocCommentXchange.
|Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0|