History, configuration, and other database objects

Other than the reference tables, there are tables and associated objects that store history data as it is collected, history data after it has been compressed, discovery, and journal data.

These tables and their indexes should have enough database cache memory allocated for their use to allow the hourly Performance and Availability history compression process to complete in a reasonable time (see the History compression details table in History compression) and support user queries, such as ad hoc reports that return data in a user-acceptable time frame.

As history and journal data are data that accumulate over time, capacity planning must be routinely performed. Keeping statistics current and the frequency and type of reorganizations are dependent upon the DMBS type.

Was this page helpful? Yes No Submitting... Thank you