Wednesday, December 21, 2022
Alerts that should have in sql prod environments
Alert when long running qureies are found--every 2 hrs
Alert Current SQL jobs are running -daily 8am
SendJobFailureReport
AlertSendIndexFragmentationdetails
AvailabilityGroupsInfo
Check Database Status
Check For Missing Backups
CheckAlwaysonSyncStatus-Every5minutes
Collect_Database_Size_Info_Daily1am
IndexFragmentationdetails-Shop-Every1Hour
Notify when AG Replicas Disconnect
SendSpaceAlert
SQLRestart Notify
TrackAvailabilityLatenc
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment