Whitepaper : Be Proactive: A Good DBA Goes Looking For Signs of Trouble
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.