 |
The implementation of the Virtual-DBA remote database administration service begins with an on-site system review. This is an
optional one to five day consulting engagement to review the current configuration, analyze performance metrics, and understand
the user environment, type of applications and business.
The Xtivia DBA will look at performance measurements such as memory caching rates, checkpoint frequency and duration, and database
write activity. Disk utilization will be analyzed for I/O balancing as well as to detect table and index fragmentation. A review of
logical log backup and archive procedures will be performed to ensure recoverability in the event of a system failure. The
performance parameters analyzed will be specific to your database vendor, be it Oracle, IBM DB2 or Informix.
If necessary, the Xtivia DBA will modify or recommend changes to the database platform configuration to optimize performance, and
to establish a baseline for future tuning.
|
|
