Database capacity planning

The data traffic pattern and data volume varies for each installation, because each customer has different monitoring requirements. The following table should be subjected to trend analysis to establish storage needs because they can potentially contain a large volume of data.

Table name

Data stored

Growth potential

Growth limita

auditendevent

audit

high

no

auditstartevent

audit

high

no

qp_btm_hdlr

compressed history

medium

no

qp_es_jnl_inputs

journal

high

no

qp_es_jnl_insts

journal

high

no

qp_es_jnl_ndflw

journal

high

no

qp_hdalmjnl

journal

high

no

qp_hdhr

collected history

high

yes

qp_hdlr

compressed history

high

yes

qp_hosts

discovery and registration

medium

no

qp_nodes

discovery and registration

mediumb

no

qp_obj_info

discovery and registration

medium

no

qp_tthr_00 - 07

collected history

very high

yes

    1. See History compression.
    2. For a very large monitored environment, growth potential can be high.

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

Comments