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 failover and replication issues.
Alerts need to configure in 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 starts and stopped.
8. Blocking and deadlocks.
Recently we moved whole on-premises resources to the cloud. In an easy word, we have moved SQL Server from on-premises…
In SQL Server sp_send_dbmail use to send emails and the SQL Server log all the status of each message processed…