About database maintenance
|Article:HOWTO64002|||||Created: 2011-12-20|||||Updated: 2011-12-20|||||Article URL http://www.symantec.com/docs/HOWTO64002|
You have control over how the data that you gather from monitoring is handled. You can create a custom configuration for the summarization and purging of Monitor Solution data. The data that you choose to store can be as granular or as broad as you require. For example you can specify to store highly detailed and granular data (typically in 5-minute intervals ) for the current day, week, or month. You can specify to then keep less-detailed data that is summarized for the previous days, weeks, or months. Ultimately, the data is purged from the database entirely when it reaches a final age. This control helps you to store the data that you require while also helping you control database growth. However, because data becomes summarized according to a schedule, it also becomes less detailed and therefore less reliable. This factor should be taken into consideration when you schedule the summarization and purging schedule.
Numeric data passes through the following four stages according to the time-periods that you define:
Non-numeric data (such as string metric, process, and NT event data) is not summarized. It is instead stored in full detail for as long as you define and then purged when the specified time period lapses.
The metric polling intervals of a metric can affect the amount of data that is collected. Monitor Plug-in settings and Remote Monitoring Server settings can also affect the amount of data that is stored. For example, you can choose to log NT Event data only when an alert raises. Changing this setting decreases the overall amount of NT Event data that is collected and therefore also decreases the amount of data that is stored.
Article URL http://www.symantec.com/docs/HOWTO64002