What Are The Effects Of Not Maintaining Your Data Environment?

Preventative Maintenance

Ensure your DR, Performance, and Data Integrity

Failure to backup properly will negatively affect:

  • Recovery Point Objectives (RPO)
  • Recovery Time Objectives (RTO)
  • Could prevent the ability to recover at all!

Maintenance

Why perform Index Maintenance?

Balancing indexes improves seek and update time. Unbalanced indexes, especially when updating, can cause locking, deadlocking, and IO bottlenecks.

The most missed step by non DBAs is… Internal Consistency checks!

This refers to page linkages and internal object allocation maps which assign unused pages to a chain. If these are out of sync data corruption occurs, which can lead to data loss.

How can you manage your environment better?

SOARING EAGLE FLIGHT CENTER

Flight Center gives you a portal to immediately find if your environment has been maintained, what has been skipped, and allows you to automate some of this maintenance.

    Comments