What DBAmon Monitors

Home | Index / DBAmon Documentation | DBAmon Change History | DBAmon Event/Error Documentation |
What DBAmon Monitors | Free Oracle Tool: orastat | Request Support

What DBAmon Monitors: MSSQL

Category Event What
DBAmon
Monitors 		Action
Taken
Backup 1. Database Backup Age
(AutoFix)
  • The number of hours since the last successful backup is measured. If the DBC-specified Backup_Age: number of hours is exceeded, then a Backup Age Event occurs.
  • At ???, the logic to record the timestamp of each backup is incorporated into each our backup tools.
    		• (AutoFix: Too much elapsed time since last successful DB backup)
  • If specified, the DBC-specified Backup_Command: Is Invoked .
    •  
    Availability 2. Instance Running
  • A DBI/ODBC connection to the DB is attempted.
  • System tables are queried.
    • Availability 3. Alerts
  • Any MSSQL Alert with a severity of 17 or higher results in a critical event.
    • Availability 4. Agent Running
  • net start is run to see if sqlserveragent is running.
    • Availability 5. Transaction Log Full
  • DBCC SQLPERF (LOGSPACE) is run.
    • Availability 6. Disk Drive Full
  • The disks which contain MSSQL DB Files are checked. If any are >= 99% full, a Critical Event occurs. If any are >= 95% full, a Warning Event occurs.

    • DBAmon.com
    This Document: http://dbamon.com/misc/monitors_mssql.shtml