Database administrators (DBAs) 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 prevent minor problems from turning into full-blown emergencies.

This whitepaper discusses:

• routine database maintenance including backups, recovery, and integrity check
• the process for setting up SQL Server agent alerts for corruption, resource issues, and fatal errors
• query performance including index analysis and slow queries

Attending these issues will help keep your databases running smoothly.