MONITORING SQL DATA GROWTH
Symptoms: Total database size increased and is now larger than the designated threshold. Impact: Medium Rapid increase in database size may be a sign of some pending problem, such as a loop inside some executing…
Read More
HOST: NETWORK UTILIZATION
Symptoms: Network utilization levels are above threshold Impact: Medium Slow SQL responses will degrade the user experience, resulting in poor efficiency of your organization’s operations. Expected behavior : There is no standard metric for network…
Read More
BACKUP FAILED OR RAN OUT OF TIME
Symptoms: Backup failed or ran slow Impact: Critical Where normal operations are interrupted and data needs to be restored, the…
SQL: QUERIES OPEN TRANSACTION
Symptoms: A transaction is not committed and not rolled back, remains open, idle and is using resources that could have…
SQL: LOGIN FAILED ATTEMPT
Symptoms: Access was denied to the SQL server. Impact: High In the case of multiple access attempts failing, this could…
SQL: DEADLOCK
Symptoms: SQL hangs temporarily for some users due to deadlock. Impact: Medium As well as delays experienced by users, there…
SQL: JOB FAILED
Symptoms: SQL job failed Impact: High This alert means that one (or more) of the steps in the designated SQL…
SQL: JOB CANCELLED
Symptoms: An SQL job has been canceled. Impact: High This alert means that the designated SQL job did not finish.…
