Thursday, 18 July 2019

SQL Server DBA Daily Activities

Daily Activities
----------------
Ensure server Availability. Check any of the SQL servers are down
Check any of the disks running on out of space
Monitor the maintenance plans - Backup, Rebuild/Reorganize the index, update stats, Clean up the history
Monitoring TempDB database files and their Sizes
Regular Jobs (If any errors follow up with leads)
Sql Services Monitoring
Monitoring Event Logs and Error Logs when ever required
Activity Monitor to check the performance of server
Long Running Jobs.
Check for Blocking sessions
Check for any deadlocks
Check the Monitoring tool (SpotLight) for any job failures and work with associate team
Review the Incident/Change/Request tickets
Attend team meeting every day
Fill the daily status report ( How many tickets are completed, in-progress, active/open)

Weekly Activities
-----------------
Check if any tables are created in system database and drop them
Check if the space availability in the servers. Delete the unnecessary files from C:, D:, E: drives. Raise a request to add more storage if any drive running out of space
Check the growth of databases in all the servers
Fill the timesheets on time

No comments:

Post a Comment