Explanation: By default, monitoring data is preserved in the database for seven days. After that period, the data is removed.
Solution: Change the auto purge setting value in Sybase Control Center. Auto purge clears obsolete data from the monitoring database once it reaches the specified threshold.
- In the left navigation pane, select Monitoring.
- In the right administration pane, select the General tab.
- Click Configuration.
- In the auto purge section, ensure that Enable auto purge configuration is selected.
- Enter the length of time (in days) to retain monitoring data before it is purged.
- Restart the server.
- Retrieve the results list using the Sybase Control Center monitoring node.