DB24 LogoDB24 Docs_

    Maintenance

    Last updated: March 4, 2026

    DB24 Maintenance Jobs

    Overview

    DB24 provides automated maintenance and housekeeping jobs to keep your SQL Server databases running optimally.

    Why Automated Maintenance Matters

    Regular database maintenance is critical for:

    • Performance: Fragmented indexes and outdated statistics lead to slow queries
    • Reliability: Proper maintenance prevents unexpected issues
    • Storage: Housekeeping prevents unnecessary storage consumption
    • Compliance: Audit and log management for regulatory requirements

    Maintenance Job Categories

    1. Index Maintenance

    DB24 intelligently manages index health based on fragmentation levels.

    Fragmentation LevelActionImpact
    < 5%No actionNone
    5% - 30%ReorganizeLow - Online operation
    > 30%RebuildHigher - May require downtime

    2. Statistics Updates

    Accurate statistics are essential for the query optimizer to create efficient execution plans.

    • Auto Update Statistics: SQL Server built-in feature
    • DB24 Enhanced Updates: More frequent and intelligent updates
    • Full Scan vs Sample: Trade-off between accuracy and speed

    3. Housekeeping Tasks

    Regular cleanup to maintain database health.

    • Transaction Log Management: Monitor and alert on log growth
    • Sync and collect data: Sync Runtime configuration and update local information

    4. Integrity Checks

    Verify database integrity to catch corruption early.

    Best Practices

    Do

    • ✅ Schedule maintenance during low-usage periods
    • ✅ Monitor job execution times
    • ✅ Review maintenance reports regularly
    • ✅ Adjust thresholds based on your environment

    Do Not

    • ❌ Disable all maintenance "to improve performance"
    • ❌ Run intensive maintenance during business hours
    • ❌ Ignore failed maintenance jobs