DBA 일간 체크리스트

1. Make sure each of your production databases are available and accessible

to their users.

2. Check all processes - such as clustering, replication, service

broker, log shipping, database mirroring - to verify that they are running correctly.

3. Check OS, SQL Server, Security, and other logs for unusual events.

4. Verify that all scheduled jobs have run successfully, including checking for long running or "hung" jobs.

5. Confirm that backups have been made and successfully saved to a secure

location.

6. Monitor disk space to ensure your SQL Servers won't run out of disk space. For best performance, all disks should have 15% or more of free space.

7. Throughout the day, periodically monitor SQL Server performance using Performance Monitor, Profiler/SQL Trace, or other performance monitoring

tools.

8. Regularly monitor and identify blocking issues.

9. Keep a log of any changes you make to servers, including documentation

of any performance issues you identify and correct.

10. Regularly restore backups to a test server in order to verify that you can restore them. You don't need to restore all backups every day, but do so often to ensure that you are confident you have good backups.

11. Take some time to learn something new as a DBA to further your professional development.

12. Automate as many of these day-to-day tasks as possible.

This list of best practices is not intended to be complete, but to get you started on your way to becoming an exceptional DBA. Always keep in mind that these suggestions are generic, and may or may not apply to your specific situation.

Brad McGehee's

Day-to-Day DBA Best Practices

출처: RedGate