Home Forums SQLServerCentral.com Editorials What Do You Include in Your Database Maintenance Plans? RE: What Do You Include in Your Database Maintenance Plans?

  • I always check available disk space. Several times I have had temp db go wild, or someone/something steal it away. Rapid decrease merits further investigation.

    Performance metrics.

    Failed jobs.

    Open transactions

    Check Database Statuses and Recovery Plans - Make sure nobody has changed them.

    Occasionally I check identity columns, to see if they are close to their limit.