Sunday, January 5, 2014

Common issues in DBA

Common Issues

1. Team Job failures - Issues related to backup and maintenance Job failure come under team Job failures.

2. Customer Job failures - Issues related to Customer Application Job failure come under Customer Job failures.

3. Long Running Jobs (Team or Customer) - Those Jobs which are running for longer than the threshold time. It can be Team or Customer Job as explained above.

4. Backup failures - Issues related to failure of all types of Backup Failures like Full, Differential & Transaction Log Backups.

5. Blocking - Issues related to an activity (or a process) being blocked by another process and is hindering its completion.

6. SQL Services stopped - SQL Services like SQL Server service, SQL Agent service, SQL OLAP service, SQL FULL Text service, SQL Reporting service etc.

7. Disk space - Issues related to low disk space or Disk Full on various drives of a server.

8. Database file full - Issues related to Data file(s) of a database reaching its threshold capacity.

9. Log file Full - Issues related to Log file(s) of a database reaching its threshold capacity.

10. Log Shipping Job failures - Log Shipping Backup, Copy or Restore Job failure issues.

11. Log Shipping out of Sync - Log Shipping Copy and Restore is out of Sync where difference of files between them is greater than 90 minutes.

12. Replication Agent Jobs - Replication agents like Distributor, log reader, snapshot, Merge agent Job failures.

13. WebSite Not available - Issues related to Customer websites not available.

14. IIS Service - Issues related to IIS Services like, World Wide Publishing Service, IIS Admin etc being in stopped state.

15. Cluster resources - Cluster resources like SQL Services, disks etc are offline or failed.

No comments:

Post a Comment