Automated maintenance package

Automated Maintenance Package

The Automated Maintenance Package is an additional package for dbWatch Control Center, designed to streamline routine database maintenance tasks. By automating essential upkeep, this package helps ensure optimal database performance and stability with minimal manual intervention.

Package Overview

The Automated Maintenance Package includes a suite of maintenance jobs tailored to simplify database management by automating repetitive and resource-intensive tasks. This package is ideal for database administrators seeking to improve operational efficiency and reduce the likelihood of performance degradation over time.

Benefits

Consistency: Ensures that maintenance routines are executed consistently across all databases.

Resource Optimization: Reduces manual workload for DBAs, allowing them to focus on more critical tasks.

Performance Stability: Regular maintenance helps prevent common performance issues, keeping databases running smoothly.

Jobs Included

Below is an overview of the jobs included in the Automated Maintenance Package. For more details on each job, refer to the Maintenance Jobs documentation.

• Index Optimization: Regularly defragments and rebuilds indexes to maintain optimal query performance.
• Statistics Update: Automatically updates database statistics to ensure accurate query execution plans.
• Log Cleanup: Manages and purges log files based on configurable retention policies.
• Data Consistency Checks: Runs consistency checks on database objects to detect and resolve corruption issues.
• Backup Verification: Validates the integrity of backup files to ensure they are usable in case of disaster recovery.

Configuration Options

Each job in the Automated Maintenance Package can be customized to meet your specific operational needs. Configurable options include:

• Frequency: Set the job execution frequency (daily, weekly, monthly).
• Resource Thresholds: Define thresholds to control resource usage during maintenance jobs.
• Notification Settings: Configure alert options for job failures or other significant events.

Licensing

The Automated Maintenance Package is an add-on available with the dbWatch Control Center Enterprise license. Please contact dbWatch Sales for more details on licensing and pricing.