Cisco Headend System Release 2.7 Installation Guide
Monitor and Eliminate Database Fragmentation
740020 Rev H
59
Monitor and Eliminate Database Fragmentation
Introduction
Over time, the database on the DNCS becomes fragmented as related data is divided
into pieces and stored at various locations throughout the hard drive. Database
fragmentation occurs normally as the system is continually creating, deleting, and
modifying records. A badly fragmented database slows down system performance
as the system must search the entire hard drive to build or retrieve a record.
into pieces and stored at various locations throughout the hard drive. Database
fragmentation occurs normally as the system is continually creating, deleting, and
modifying records. A badly fragmented database slows down system performance
as the system must search the entire hard drive to build or retrieve a record.
Several of the utilities contained in the DNCS Utilities are designed to help system
operators minimize the effects of database fragmentation. System operators who
want to avoid a fragmented database should follow the recommendations set forth
in the remainder of this section.
operators minimize the effects of database fragmentation. System operators who
want to avoid a fragmented database should follow the recommendations set forth
in the remainder of this section.
Run and Analyze the Doctor Report
Run and analyze the output of the Doctor Report on a regular basis. Pay attention to
the headings in the report called Database Table Extents for dncsdb and Database
Table Extents for appdb. The number of extents associated with a few specific tables
provides the operator with some warning that the database is becoming fragmented.
the headings in the report called Database Table Extents for dncsdb and Database
Table Extents for appdb. The number of extents associated with a few specific tables
provides the operator with some warning that the database is becoming fragmented.
Note: The number of table extents refers to the number of times a specific table is
fragmented across the hard drive.
fragmented across the hard drive.
System operators should monitor the Doctor Report for the number of extents
associated with the following DNCS database tables:
associated with the following DNCS database tables:
emm
secure_micro
hct_profile
sm_auth_profile
pdkeycertificate
sm_pkg_auth
pdsernummap
Additionally, system operators should monitor the Doctor Report for the number of
extents associated with the prvdrneutraldata table in the Application Server
database.
extents associated with the prvdrneutraldata table in the Application Server
database.
If the Doctor Report indicates that the number of extents for any of these tables has
reached 10, system operators should plan to run specific utilities designed to
defragment the database. Once the number of extents has reached 30, system
performance is negatively affected.
reached 10, system operators should plan to run specific utilities designed to
defragment the database. Once the number of extents has reached 30, system
performance is negatively affected.