This document describes the fields under the Advanced tab for the Cisco
Intelligent Contact Management (ICM) database size estimation tool in the ICM
Cisco recommends that you have knowledge of these topics:
Microsoft SQL Database
The information in this document is based on these software and
The information in this document was created from the devices in a
specific lab environment. All of the devices used in this document started with
a cleared (default) configuration. If your network is live, make sure that you
understand the potential impact of any command.
Technical Tips Conventions for more information on document
The ICM database size estimation tool is used to estimate the size
requirement of a Logger or Historical Data Server (HDS) database. The ICM
database must run on the Admin Workstation (AW) in order to perform the
estimation. You can enter the expected call traffic, expected configuration,
and desired data retention periods. The tool dynamically calculates the
recommended database size.
Select Start >
The ICMDBA main window appears. It is a tree hierarchy that
displays the ICM database servers in the current domain.
Drill-down to the database server. Click on the plus sign
(+) next to its name to expand the server. This displays the
ICM instances that have database on the server.
Expand the ICM instance to display specific ICM node(s),
Distributor and Logger, on machines that contain databases for that
Right-click the database and select
Figure 1—ICMIPCC - ICMDBA -- Access the Database Size
The ICM Database Size Estimation Tool appears.
Figure 2—Estimate -- ICMDBA Database Size Estimation
These are the three fields under the Advanced tab:
Figure 3—Fields under Advanced Tab
Overhead Factor—This is the value multiplied by the
estimation to get the final result. Ideally, the database should not be more
than half full. Thus, the default Overhead Factor is
Average Events Per Day—This is the estimated number
of Events, on average, expected to occur per day. The default value is 10,000.
In comparison with other tables, the space usage for this table is difficult to
estimate. Therefore, it should be calculated based on the historical
Variable Percent Used—This is used to estimate the
size of the variable-length fields in the database. It is the percentage of the
maximum length of the variable-length field used in the calculation. The
default value is 25 %. It is helpful if Peripheral Variables are used. There
are a total of ten 40-byte variables by default. This number represents a
percentage of the total 400 possible bytes that can be