Database Administration is very critical when it comes to monitoring the health of the database servers. Every DBA has to perform lots of activities and monitoring is one of the important task. A good DBA always tries to minimize his routine activities by automating tasks. If you are managing multiple instances and if you have third party monitoring tool then you can monitor the activities easily and keep an eye on alerts.
Below are the daily activities and responsibilities of a DBA.
1. Connect with database instance and check if all databases are online.
2. Check all databases if there is any blocking.
3. Check all scheduled maintenance jobs (eg. backups, statistics, indexes etc.) have run successfully and analyze errors for failed jobs.
4. Check if scheduled application jobs have run successfully and if any job has failed then inform the same to application team.
5. Regularly monitor SQL Server error logs.
6. Check windows server event logs and security logs and try to resolve error if any or report to system administrator or application team.
7. Verify and notedown free disk space available on database server.
8. Periodically monitor blockings, performance, cpu utilization, processor utilization, memory utilization, long running queries etc. and try to find bottlenecks.
9. Continuously monitor SQL server alerts which you have configured and act quickly to resolve issues.
10. If you find any long running query then check with database engine tuning advisor if it suggests any performance improvement.
11. Time to time monitor your team members activities and database servers with SQL Server Profiler.
12. Note down all the changes, settings, users permissions, logins etc. whatever changes you make on database server and keep it documented.
13. Verify database Standard Reports to understand health of database and components.
14. Communicate with your application/development team members and confirm if they have any database or performance related issues, it also helps in team building.
15. Try to learn something new every day for future growth and technical expertise.
Click here to see: SQL Server Database Migration Checklist
If you found any of the information on this page helpful in anyway then please consider sharing this content with your favorite social network or by leaving your thoughts in the comment section. Thanks!