If you’re in business, then its likely you’ve got a database such as Exchange, SharePoint and SQL, and all the responsibility (and sometimes headaches) that goes along with owning one. Without proper maintenance, in time, your applications dependent on these databases will slow and employees will have difficulty completing tasks. Those frustrations lead to a loss in productivity and a greater use of resources to accomplish every day operations.
Keeping a database operating smoothly requires routine maintenance:
- Looking for signs of corruption from a hardware fault, 3rd party driver or firmware, or platform issues
- Reorganizing the database to remove old and deleted data and logs
- Managing and reviewing log files to trace odd program behavior or system access events
- Cleaning up leftover maintenance data by removing unneeded files allows your database to respond faster
- Rebuilding indexes regularly. Over time, index fragmentation can lead to gaps in data pages and logical fragmentation, which in turn leads to increased disk I/O and latency.
- Deleting historical data related to backup and restore activities to help your database to run more efficiently
- Backup your database regularly in order to recover from upgrades that don’t play nice, corrupted tables and other system problems that can lead to full-on disasters [Read more...]