Configure auto-purge, flush threshold, and flush batch size settings to determine how long monitoring data is retained, and set a monitoring database to configure where data is stored.
Prerequisites
Depending on the expected level of monitoring activity, ensure that the monitoring database is adequately prepared to store monitoring data.
Task- In the left navigation pane of Sybase Control Center, select Monitoring.
- In the right administration pane, select the General tab.
- Click Configuration.
- Configure auto purge settings.
Auto purge clears obsolete data from the monitoring database once it reaches the specified threshold.
- Select Enable auto purge configuration to activate auto purge functionality.
- Enter the length of time (in days) to retain monitoring data before it is purged.
- Configure flush threshold settings.
The flush threshold indicates how often data is flushed from memory to the database. This allows you to specify the size of the data saved in memory before it is cleared. Alternately, if you do not enable a flush threshold, data is automatically written to the monitoring database as it is captured.
- Select Enable flush threshold configuration to activate flush threshold functionality.
- Select one of:
-
Number of rows – monitoring data that surpasses the specified number of rows is flushed from memory. Enter the desired number of rows adjacent to Rows. The default is 100.
-
Time interval – monitoring data older than the specified time interval is flushed from memory. Enter the desired duration adjacent to Minutes. The default is 5.
-
Either rows or time interval – monitoring data is flushed from memory according to whichever value is reached first: either the specified number of rows or the specified time interval. Enter the desired rows and duration adjacent to Rows and Minutes, respectively.
- If you enabled a flush threshold, enter a Flush batch row size by specifying the size of each batch of data sent to the monitoring database. The row size must be a positive integer.
The batch size divides flushed data into smaller segments, rather than saving all data together according to the flush threshold parameters. For example, if you set the flush threshold to 100 rows and the flush batch row size to 50, once 100 rows are collected in the monitoring console, the save process executes twice; data is flushed into the database in two batches of 50 rows. If the flush threshold is not enabled, the flush batch row size is implicitly 1.
Note: By default, the monitoring database flushes data
every 5 minutes. Alternatively, you can flush data immediately by removing or decreasing the default values, but doing so impacts performance and prevents you from using captured data.
- Optional. To change the data source, select an available database from the Monitor database endpoint drop down list.
Available databases are those with a JDBC server connection type (either ASE or SQL Anywhere) created in the default domain.
To create a new monitor database, a platform administrator must set up a database by running the appropriate configuration scripts and creating a server connection for the database in the default domain. The database server connection then appears as an option in the Monitor Database Endpoint drop down list.
- Click OK.