Database administrators are busier than ever these days, so fighting fires is the last thing they want to spend their time doing. A proactive approach to database performance and maintenance helps keep them ahead of trouble and prevents minor problems from turning into full-blown emergencies. This post discusses routine database maintenance and the process for setting up SQL Server Agent alerts for corruption, resource issues, and fatal errors. It also covers additional issues such as index analysis and slow queries that will help keep your databases running.
Read the whitepaper “Be proactive: A good database administrator goes looking for signs of trouble” to learn more about how to provide routine database maintenance. Discover how to set up backup and recovery, integrity checks, alerts, and query performance monitoring.