common issues and Alerts Configuration in Server

common issues in real time :- 

1. backup failures.

2. job failures.

3. disk space issues

4. log file growth issues.

5. data file growth issues.

6. db  offline and suspect mode issues.

7. cpu and memory  is high issues.

8. Sql server sudden start/stop.

9. performance issues like Blocking and Query slowness and Server slowness.

10. user access issues.

11. High availability issues like log shipping out of sync and cluster fail over and replication issues.

Alerts need to configured in a servers:-

1. disk space alert:- used space>80% --> warning & used space>90% is critical.

2. memory is high

3. cpu is high alerts

4. jobs failures

5. db offline or suspect alerts

6. database which doesn't have any backups.

7. sql server start and stopped.

8. blocking and deadlocks.