Database Reference
In-Depth Information
tor has the primary responsibility during this continuous period of maintenance and
growth.
Within a few short weeks after deployment, you will note an increase in the usage
of the database system. In an operational environment, growth does not material-
ize in just more transactions in the initial applications. Newer applications get devel-
oped to take advantage of the database system. The project team, especially the
DBA, must be able to provide for the growth.
After deployment, the database system must be closely monitored. Although the
usage pattern and frequency of usage could mostly be anticipated, you will see vari-
ations very soon after deployment. You will understand that the project team could
not foresee every aspect of the usage. So the DBA must carefully monitor usage on
an ongoing basis.
In a typical database environment, new users will need authorizations to access
the database. Access privileges may have to be changed for the current authorized
users. As and when users leave an organization, their access privileges must be
revoked immediately. Security administration becomes an important ongoing
responsibility of the DBA.
As soon as a database system is deployed and made ready for use, the system is
open to potential failures. Safeguarding against failures is an essential ongoing activ-
ity. Proper backup and recovery procedures constitute a basic responsibility in the
postdeployment period.
Figure 17-1 provides a comprehensive overview of the ongoing maintenance
activities in a database environment.
In the previous chapters, we have touched on these activities. Now in this chapter,
we will get into more details on the significant activities. One such activity is ongoing
tuning of the database for performance. We will consider how various components
are tuned so that the database system may perform at optimal performance.
Routine
Maintenance
Monitoring &
Review
Growth &
Enhancements
Tuning for
Performance
Backup &
Recovery
Security
Maintenance
Space
Management
Concurrency
Control
Problem
Resolution
Statistics
Gathering
Review of
Operations
Use of
Benchmarks
Application
Enhancements
Schema
Revisions
DBMS Version
Upgrades
Tuning
Indexes
Tuning
Queries
Tuning
Transactions
Tuning the
Schema
DATA
BASE
DBMS
DBA
Figure 17-1
Overview of ongoing maintenance.
Search WWH ::




Custom Search