DB24 LogoDB24 Docs_

    Maintenance

    Last updated: March 30, 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 maintains index health by monitoring fragmentation levels and automatically selecting the most appropriate maintenance operation. We use MS default thresholds to determine index maintenance operation (>=5% Reorg | >=30% Rebuild).

    Fragmentation Level DB24 Action Impact
    Low No action required No performance impact
    Medium Index Reorganization Lightweight online operation with minimal impact
    High Index Rebuild More intensive maintenance that fully optimizes the index

    Small Index Exclusion

    To avoid unnecessary maintenance overhead, DB24 automatically excludes very small indexes from fragmentation maintenance.
    Indexes with a low number of pages or rows typically provide little performance benefit from reorganization or rebuild operations, so these are skipped to ensure maintenance focuses on indexes where it provides real value.

    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