SQL Server DBA Daily Activities
Daily Basis...
---Check any client mail regarding any issue.
---Check health check of databases.
---Monitoring Connectivity Failures/Availability
---Monitoring of error logs
---Responding to database error alerts like Disk space, Scheduled job failed
Backups( Have they all succeeded?)
Disk Space( Do we have plenty of space available for normal operations during business hours?)
Database Size( Have we seen a major increase in size (I monitor this because we manage client DB's
Scheduled Jobs( Have any failed? Or do any of the steps have warnings?)
Event Viewer (application, security, server)
Any errors at all relating to Security, SQL Server, the OS, hardware etc
SQL Error Log (Check the logs to ensure there are no errors, events raised which may be of concern
Cluster Log(Are there any errors, warnings?--if you are working in cluster environmental)
Replication Logs(Are all subscriptions in sync?)
Maintenance Reports (Automated rebuilds/reorganization of indexes and updating of stats. What was
done? What wasn't done?)
Monitoring System emails( Any alerts over night from any of the database servers, web servers,
application servers?)
Overnight processing emails ( Did all batch jobs run as expected?)
---Database Refresh (Depend upon user request)
---Install/Upgrade/Remove RDBMS Database Software-----depend upon the client request
---Create/Upgrade/Remove Database-----depend upon the client request
---Detection of dead lock and resolution
---Initial Troubleshooting and re-starting broken database jobs
---Initial Investigation of Database Internal Errors/SQL Server errors
---Working on issues with application team,Middlewire team and wintel team depending upon the issue .
WEEKLY PROCEDURES
---Service pack and installation in sql server.
---Database healthcheck after server reboot.
-- Review fragmentation job , optimization job rebuild index job are failed.
No comments:
Post a Comment