| Control Center Jobs | Description |
|---|---|
| Availability | |
| Database backup | Checks backup status of all databases. |
| Database status | Checks status of all databases defined on the system. The following incidents triggers a warning or an alarm: Offline, offline until recovery complete, recovered, suspect pages, in the process of being upgraded |
| DBMS uptime | Collects database uptime statistics. |
| Capacity | |
| Database space check | Checks the amount of free space in all databases. |
| Database space check | Checks the amount of free space in all databases. |
| Database growth rate | Collects database growth rates statistics. |
| Transaction log space check | Checks the amount of free space in all transaction logs. |
| Performance | |
| Blocking detector | This check helps identify processes that are blocking other processes. The ‘time_blocked’ column in system table master..sysprocesses is checked for processes with status ‘lock sleep’. |
| Data cache monitor | Collects data cache statistics based on the dbWatch tasks ‘System monitor collector’ which runs the ‘dbcc monitor’ utility continuously. |
| Data cache statistics | Collects data cache statistics. |
| Disk activity monitor | Collects statistics created by the ‘System monitor collector’ task. |
| Test DML-DDL performance | Runs performance test on database.The procedure executes SELECT, INSERT, UPDATE and DELETE statements on dbwatch engine schema test tables. |
| Engine CPU monitor | Collects counter values for busy io and busy cpu, and are based on the dbWatch tasks ‘System monitor collector’ which runs the ‘dbcc monitor’ utility continuously. |
| Memory statistics | Collects memory statistics based on the dbWatch tasks ‘System monitor collector’ which runs the ‘dbcc monitor’ utility continuously. |
| Procedure cache check | Checks the procedure cache. |
| Procedure cache check | Checks the procedure cache. |
| Session load | Shows session statistics. |
| System monitor collector | This task collects statistics by running the ‘dbcc monitor’ utility which is also a part of the stored procedure sp_sysmon. It is important that the ‘System monitor collector’ is not used while the sp_sysmon procedure is executed from some where else, as this will clear all the counters, resulting in incorrect statistics. After successful execution of this procedure, the statistics are extracted from the master.dbo.sysmonitors table and stored in a local table (dbw_sysmon_stat) where they can be analyzed by other dbWatch performance tasks. |
| Temp cache statistics | Collects temp cache statistics. |
| User connections check | Checks the configuration setting of the ‘number of user connections’ from the master.dbo.syscurconfigs table against the number of connections on the instance (processes with suid != 0 in from the master.dbo.sysprocesses table). |
| User connections check | Checks the configuration setting of the ‘number of user connections’ from the master.dbo.syscurconfigs table against the number of connections on the instance (processes with suid != 0 in from the master.dbo.sysprocesses table). |
Post your comment on this topic.