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

SQL Anywhere 11.0.1 » SQL Anywhere Server - Database Administration » Monitoring Your Database » SQL Anywhere Monitor » Monitoring resources


Delete old Monitor metrics

You can customize how long the Monitor keeps historical metrics. You can choose to use any or all of the settings. By default, the Monitor performs maintenance on itself once a day at midnight. Maintenance affects metrics, not alerts.

To configure the deletion of historical metrics
  1. Click Administration.

  2. Click the Configuration tab.

  3. Click Edit.

  4. Click Maintenance.

  5. Specify a time 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.

  6. Customize the Data Reduction settings:

    • Take A Daily Average Of Values 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 Values When The Total Disk Space Used By The SQL Anywhere Monitor Becomes Greater Than X (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, preventing the Monitor from using more disk space for its metrics. Metrics are deleted until a sufficient amount of free space exists to store new metrics.

  7. Click Save.