SQL
Server Database Administrator Daily/ Weekly Activities
Here
are normal database routine activities and some DMV for DBA maintenance
1.
Procedures
- DBA ensure that scheduled jobs have run successfully.
- DBA must confirm that backups have been made and successfully saved to a secure location periodically from operation dept.
- DBA periodically check OS Event Logs and SQL Server Logs for unusual events.
- 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.
- DBA periodically monitor performance using both System Monitor and Profiler/SQL Trace.
- DBA regularly monitor and identify blocking issues
- DBA must log any changes you make to servers, including documentation of any performance issues you identify and correct.
- DBA must prepare document for all Logins and access rights.
- Regularly restore backups to another test server in order to verify that you can restore them.
- Take some time to learn something new as a DBA to further your professional development.
2.
Performance
Tunning
- Look for harmful growth rates (DB Files Space, Object Spaces, OS Space, Log File Space, Temp Database Space)
- Review tuning opportunities (DB Reindexing, Update Stats)
- Look for I/O contention (Look for Performance Monitor)
- Review fragmentation (Defragmentation)
- Project performance into the future
- Perform tuning and maintenance (sp_who2, DMV…)
