Jobs by Artifact ID


Control Center Jobs Platform Description
Aborted clients Mysql Checks the number of clients not closing the connection properly.
Aborted clients Mysql Checks the number of clients not closing the connection properly.
Aborted connections Mysql Checks the number of aborted client connections.
Aborted connections Mysql Checks the number of aborted client connections.
DBMS uptime Mysql Collects uptime statistics for the MySQL instance.
DBMS uptime Mysql Collects uptime statistics for the MySQL instance.
DBMS uptime Mysql Collects uptime statistics for the MySQL instance.
Aborted connects alert Mysql Collects uptime statistics for the MySQL instance.
Maximum connections alert Mysql Collects uptime statistics for the MySQL instance.
MySQLd process alert Mysql Collects uptime statistics for the MySQL instance.
Database growth rate Mysql Collects database size and visualizes the growth rate of the server.
Database growth rate Mysql Collects detailed growth rate information.
Query cache hitrate Mysql Shows the query cache hit rate.
NDB data memory usage check Mysql NDB data memory usage check
NDB data node status Mysql NDB data node status
InnoDB cluster status Mysql NDB data node status
InnoDB cluster switch Mysql NDB data node status
Replica count Mysql NDB data node status
Replica delay Mysql NDB data node status
Replica state Mysql NDB data node status
Framework Mysql dbWatch engine framework job (for internal use only). Used for patching or upgrading of dbWatch engine framework.
Binlog cache check Mysql Checks the number of transactions that used the temporary binary log cache but that exceeded the value of binlog_cache_size and used a temporary file to store statements from the transaction.
Binlog cache check Mysql Checks the number of transactions that used the temporary binary log cache but that exceeded the value of binlog_cache_size and used a temporary file to store statements from the transaction. Statistics collected from information_schema.global_status.
InnoDB buffer pool check Mysql Checks the hit rate of the innodb buffer pool using performance_schema.global_status.
InnoDB buffer pool check Mysql Checks the hit rate of the innodb buffer pool using information_schema.global_status.
Instance memory statistics Mysql Collects instance memory statistics.
Instance memory statistics Mysql Collects instance memory statistics.
Lock statistics Mysql Collects lock statistics
Lock statistics Mysql Collects lock statistics
MyISAM key cache check Mysql Checks the hit rate of the MyISAM key cache.
MyISAM key cache check Mysql Checks the hit rate of the MyISAM key cache.
Network statistics Mysql This job collects the number of bytes received and sent from all clients.
Network statistics Mysql This job collects the number of bytes received and sent from all clients.
Session load Mysql Records the number of active and inactive sessions over time.
Session load Mysql Records the number of active and inactive sessions over time.
Statement load Mysql This job collects the number of statements executed by the server. Including statements executed within stored programs and statements sent to the server by clients. Values from status variables Queries and Questions (from global_status table) are used.
Statement load Mysql This job collects the number of statements executed by the server. Including statements executed within stored programs and statements sent to the server by clients. Values from status variables Queries and Questions (from global_status table) are used.
Threads statistics Mysql Checks the number of threads created per minute.
Threads statistics Mysql Checks the number of threads created per minute.
Temporary table check Mysql Shows percentage of temporary tables written to disk
Temporary table check Mysql Shows percentage of temporary tables written to disk
SQL statistics Mysql Collects performance statistics for SQL statements.
Aborted clients Mariadb Checks the number of clients not closing the connection properly.
Aborted clients Mariadb Checks the number of clients not closing the connection properly.
Aborted connections Mariadb Checks the number of aborted client connections.
Aborted connections Mariadb Checks the number of aborted client connections.
DBMS uptime Mariadb Collects uptime statistics for the MariaDB instance.
Aborted connects alert Mariadb Collects uptime statistics for the MariaDB instance.
Maximum connections alert Mariadb Collects uptime statistics for the MariaDB instance.
Database growth rate Mariadb Collects database size and visualizes the growth rate of the server.
Database growth rate Mariadb Collects detailed growth rate information.
Galera Cluster node count Mariadb Checks the number of nodes currently in the cluster.
Galera Cluster node receive queue Mariadb Checks current length of the receive queue, which is the number of writesets waiting to be applied.
Galera Cluster node send queue Mariadb Checks current length of the send queue, which is the number of writesets waiting to be sent.
Galera Cluster node state Mariadb Checks then cluster node state value. When a node is part of the Primary Component, the following states can be returned; Joining, Waiting on SST, Joined, Synced or Donor.
Gelera Cluster network statistics Mariadb This job collects the number of bytes received and sent from from other Galera Cluster nodes.
Replica count Mariadb This job collects the number of bytes received and sent from from other Galera Cluster nodes.
Replica delay Mariadb This job collects the number of bytes received and sent from from other Galera Cluster nodes.
Replica state Mariadb This job collects the number of bytes received and sent from from other Galera Cluster nodes.
Framework Mariadb dbWatch engine framework job (for internal use only). Used for patching or upgrading of dbWatch engine framework.
Binlog cache check Mariadb Checks the number of transactions that used the temporary binary log cache but that exceeded the value of binlog_cache_size and used a temporary file to store statements from the transaction.
Binlog cache check Mariadb Checks the number of transactions that used the temporary binary log cache but that exceeded the value of binlog_cache_size and used a temporary file to store statements from the transaction. Statistics collected from information_schema.global_status.
InnoDB buffer pool check Mariadb Checks the hit rate of the innodb buffer pool using performance_schema.global_status. MariaDB Enterprise Server uses the InnoDB storage engine by default.
Instance memory statistics Mariadb Collects instance memory statistics.
Instance memory statistics Mariadb Collects instance memory statistics.
Lock statistics Mariadb Collects lock statistics
Lock statistics Mariadb Collects lock statistics
MyISAM key cache check Mariadb Checks the hit rate of the MyISAM key cache.
MyISAM key cache check Mariadb Checks the hit rate of the MyISAM key cache.
Network statistics Mariadb This job collects the number of bytes received and sent from all clients.
Network statistics Mariadb This job collects the number of bytes received and sent from all clients.
Session load Mariadb Records the number of active and inactive sessions over time.
Session load Mariadb Records the number of active and inactive sessions over time.
Threads statistics Mariadb Checks the number of threads created per minute.
Temporary table check Mariadb Shows percentage of temporary tables written to disk
SQL statistics Mariadb Collects performance statistics for SQL statements.
SQL statistics Mariadb Collects performance statistics for SQL statements.
Agresso reports queue Oracle Monitors and checks pending or running reports. Returns warning or alarm if the elapsed time exceeds defined threshold.
Agresso CON$ system table Oracle Checks the size of all indexes defined on SYS.CON$ system table.
Agresso help and temp tables Oracle Collects information about objects (temporary tables and help tables) created in the agresso application schema.
AUDIT TABLE Oracle Checks the AUD$ trail table for CREATE TABLE, DROP TABLE and TRUNCATE TABLE audit records for audited users (DCL used: ‘AUDIT TABLE BY username’)
Audit basic login anomalies detector Oracle Check that looks for anomalies in new sessions logging on the database
Audit local repository framework Oracle Task that installs and upgrades the procedure for retrieving audit data in an audit repository when repository and source is on same schema(For test).
Audit login anomalies detector Oracle Check that looks for anomalies in new sessions logging on the database
Audit remote repository framework Oracle Task that installs and upgrades the procedure for retrieving audit data in an audit repository.
Audit source framework Oracle Task that installs and upgrades the procedure for retrieving audit data in a audit source.
Alert log check Oracle This check reads and looks for errors in the database alert log.
Alert log check Oracle This check reads and looks for errors in the database alert log.
Alert log check Oracle This check reads and looks for errors in the database alert log.
Alert log check Oracle This check reads and looks for errors in the database alert log.
Alert log check Oracle This check reads and looks for errors in the database alert log. Uses embedded java to read files.
Alert log check Oracle This check reads and looks for errors in the database alert log. Uses embedded java to read files.
Archive status Check Oracle Checks how many redolog files that are not archived.
Backup log Check 10g Oracle Checks for errors in a log file (e.i. backup log). For backups not using RMAN.
Backup log Check 8i Oracle Checks for errors in a log file (e.i. backup log). For backups not using RMAN.
Backup log Check 9i Oracle Checks for errors in a log file (e.i. backup log). For backups not using RMAN.
Data Guard Archive Status Oracle Checks that the standby database is receiving archive files from master database.
Data Guard Archive Status Check Oracle Checks that the standby database is receiving archive files from master database.
Database link check Oracle Checks database links.
Instance alert log Oracle Reads and checks errors in the V$DIAG_ALERT_EXT performance view contained in the XML decoded version of the XML version of Alert log file.
Database uptime Oracle Collects database uptime statistics for all instances mounted on the database.
Dba Jobs check Oracle Detecting failed scheduled jobs in old style dba_jobs.
DBMS uptime Oracle Collects uptime statistics in database.
Export log Check Oracle Checks for errors in a log file (i.e. export log).
File status check Oracle Reacts on any changes in status of data files and/or temporary files.
Job scheduling check Oracle Detecting failed scheduled jobs. The STATUS column in the Oracle dictionary view DBA_SCHEDULER_JOB_RUN_DETAILS is used to detect scheduled jobs that have failed.
Listener log check Oracle This checks and reads errors from the database listener log. Using Oracle native code to read.
Listener log check Oracle This checks and reads errors from the database listener log. Using Oracle native code to read.
Listener log check Oracle This checks and reads errors from the database listener log. Using Oracle native code to read.
Listener log check Oracle This checks and reads errors from the database listener log. Using Oracle native code to read.
Listener log check Oracle This checks and reads errors from the database listener log. Using Oracle native code to read.
Listener log check Oracle This checks and reads errors in database listener log. Using embedded java to read.
Listener log check Oracle This checks and reads errors in database listener log. Using embedded java to read.
Listener status check Oracle Checks listener status to verify if up and running, requires java support in the database.
Max datafiles check Oracle Checks the ‘soft limit’ and the ‘hard limit’ of the maximum number of physical OS files, that can be mapped to an Oracle instance.
Database mount state Oracle Checks the ‘soft limit’ and the ‘hard limit’ of the maximum number of physical OS files, that can be mapped to an Oracle instance.
Datafile status Oracle Checks the ‘soft limit’ and the ‘hard limit’ of the maximum number of physical OS files, that can be mapped to an Oracle instance.
Max datafiles Oracle Checks the ‘soft limit’ and the ‘hard limit’ of the maximum number of physical OS files, that can be mapped to an Oracle instance.
RMAN ARCHIVELOG backup status alert Oracle Checks the ‘soft limit’ and the ‘hard limit’ of the maximum number of physical OS files, that can be mapped to an Oracle instance.
RMAN backup status alert Oracle Checks the ‘soft limit’ and the ‘hard limit’ of the maximum number of physical OS files, that can be mapped to an Oracle instance.
Password expire Oracle Checks for users whose password will soon expire.
PDB status Oracle Alerts if PDB is not in correct state
RMAN backup status Oracle Checks the status of RMAN backup from V$RMAN_BACKUP_JOB_DETAILS performance view.
RMAN backup status Oracle Checks the status of RMAN backup from V$RMAN_BACKUP_JOB_DETAILS performance view.
RMAN backup status Oracle Checks the status of RMAN backup from V$RMAN_BACKUP_JOB_DETAILS performance view.
RMAN backup status Oracle Checks status of RMAN backup from V$RMAN_BACKUP_JOB_DETAILS performance view.
RMAN backup status Oracle Checks the status of RMAN backup from V$RMAN_BACKUP_JOB_DETAILS performance view.
RMAN archivelog backup status Oracle Checks the status of RMAN archivelog backup from V$RMAN_BACKUP_JOB_DETAILS performance view.
RMAN backup status Oracle Checks the status of RMAN full backup from V$RMAN_BACKUP_JOB_DETAILS performance view for input_type ‘DB FULL‘. The procedure can also check incremental (input_type ‘DB INCR‘) level 0 backup (equivalent to full backup) by checking V$BACKUP_DATAFILE performance view (column INCREMENTAL_LEVEL=0).
RMAN incremental backup status Oracle Checks the status of RMAN incremental backup (input_type ‘DB INCR‘) from V$RMAN_BACKUP_JOB_DETAILS performance view.
RMAN recovery area backup status Oracle Checks the status of RMAN recovery area backup (input_type ‘RECVR AREA‘) from V$RMAN_BACKUP_JOB_DETAILS performance view.
Tablespace in BEGIN BACKUP mode Oracle Checks if any of the tablespaces are in ‘BEGIN BACKUP‘ mode (caused by DDL ‘alter tablespace
Test alert db Oracle Test alert that alerts every ‘X’ minutes.
Test alert Oracle Test alert that alerts every ‘X’ minutes.
TNSping check Oracle Checks TNSping connectivity on listed targets. Task requires ‘java’ support. Supports Linux/Unix and Windows, will react with an alarm if host is unreachable.
ASM disk statistics Oracle Checks ASM disks for status and statistics.
ASM diskgroup space Oracle Checks ASM diskgroups space statistics.
Monitor SYS.AUD$ table size Oracle Checks size of the AUD$ trail table.
Autoextensible data files Oracle Checks all tablespaces for total disk space usage (autoextensible data files).
Disk space check Oracle Disk space check requiring java support database. (Supports Linux, Solaris, AIX, HPUX and Windows).
Flash Recovery Area Usage Oracle Checks space usage in the flash recovery area.
Flash Recovery Area Usage Oracle Checks space usage in the flash recovery area.
Free extents Oracle Checks for free extents in all tablespaces. A warning or an alarm is returned if segments storage value is higher than the largest free extent chunk.
Max processes Oracle Checks the maximum number of processes.
ASM diskgroup space Oracle Checks the maximum number of processes.
Flash recovery space usage Oracle Checks the maximum number of processes.
Max processes Oracle Checks the maximum number of processes.
SYS.AUD size Oracle Checks the maximum number of processes.
Tablespace free space Oracle Checks the maximum number of processes.
Segment size collector Oracle Collects size and number totals on all segment types per segment-owner and tablespace_name.
Segment size collector Oracle Collects size and number totals on all segment types per segment-owner and tablespace_name.
Segment size collector Oracle Collects size and extent number info for larger segments in the database.
Segment size status for old style tablespaces Oracle Checks segment storage definitions in tablespaces where extent management is not set to local.
Temporary tablespace free space check Oracle Checks level of free space for temporary tablespaces.
Tablespace free space check Oracle Checks level of free space for all tablespaces.
Tablespace free space Oracle Checks level of free space for all tablespaces.
Applied archive log gap status Oracle Reacts on applied archived log gaps and errors.
Blocking detector for RAC Oracle Checks if a session is waiting on a TX (transaction) lock. (RAC only)
Memory session load for RAC Oracle Records the load memory of RAC active sessions over time.
MV Refresh Group Oracle Checks refresh date of scheduled jobs in refresh group(s).
Dataguard apply time Oracle Checks refresh date of scheduled jobs in refresh group(s).
Dataguard archive sequence apply lag Oracle Checks refresh date of scheduled jobs in refresh group(s).
Dataguard standby archivelog gap Oracle Checks refresh date of scheduled jobs in refresh group(s).
Dataguard startup time Oracle Checks refresh date of scheduled jobs in refresh group(s).
Dataguard transport time Oracle Checks refresh date of scheduled jobs in refresh group(s).
RAC instances status Oracle Reacts if one or more RAC instances are not available.
Session load Rac Oracle Records the number of active sessions over time (RAC only).
Snapshot Log(s) rows count Oracle Checks row count on all snapshot logs for given schema.
Snapshot Log(s) size Oracle Checks size of all snapshot logs.
Data Guard role switch Oracle Checks size of all snapshot logs.
Restore uptodate status Oracle Checks size of all snapshot logs.
Framework Oracle Engine framework is used when upgrading earlier versions of dbWatch. Ensures the dbWatch Engine and dbWatch Server run compatible codes.
Framework Oracle Engine framework is used when upgrading earlier versions of dbWatch. Ensures the dbWatch Engine and dbWatch Server run compatible codes.
Index status check Oracle Detecting indexes in status UNUSABLE
Index status check Oracle Detecting indexes in status UNUSABLE
Invalid objects check Oracle Detecting invalid objects in the database.
Extent fragmentation Oracle Detecting invalid objects in the database.
Table statistics check Oracle Reacts on old (or missing) statistics in DBA_TABLES dictionary table (column LAST_ANALYZED).
Analyze tables Oracle Analyse tables automatically.
Delete SYS.AUD$ data Oracle Deletes old rows from the SYS.AUD$ trail table.
Index fragmentation Oracle Checks the index fragmentation in all database schemas. If DELETED LEAF ROWS is high, you will get low block density.
Rebuild indexes Oracle Rebuild indexes automatically.
Table fragmentation Oracle Checks the Table fragmentation in all database schemas.
Table fragmentation Oracle Checks the Table fragmentation in all database schemas.
Statistics migration Oracle Migrates statistics from a number of tasks from dbWatch version 12 to dbWatch CC.
Blocking detector Oracle Checks if a session is waiting on a TX (transaction) lock.
Buffer cache statistics Oracle Gets data cache statistics for buffer cache in SGA.
CPU load Oracle Checks CPU load using Oracle performance view v$osstat.
Database network statistics Oracle Checks database network SQL*NET statistics.
Test DML performance Oracle Runs performance test. Procedure executes SELECT, INSERT, UPDATE, DELETE and TRUNCATE statements on schema test tables.
File IO statistics Oracle Collects I/O statistics for data files.
Instance memory statistics Oracle Collects statistics on instance memory.
Latch statistics Oracle Collects latch status statistics.
Long running queries Oracle Checks for long running queries.
Open cursors Oracle Checks and collects the amount of open cursors per session.
Disk read statistics Oracle Collects disk read statistics from v$system_event performance view for db file sequential and dbfile scattered read event.
Disk read statistics Oracle Collects disk read statistics from v$system_event performance view for db file sequential and dbfile scattered read event.
Redo statistics Oracle Gets redolog files statistics. Based on Oracle dictionary and performance views.
Redo statistics Oracle Gets redolog files statistics. Based on Oracle dictionary and performance views.
Session load Oracle Records the number of active and inactive sessions over time.
Session load Oracle Records the number of active sessions over time.
SQL statement statistics Oracle Collects SQL statement statistics from v$sqlarea performance view (Oracle 10g only).
SQL statement statistics Oracle Collects SQL statement statistics from v$sqlarea performance view (Oracle 11g only).
SQL statement statistics Oracle Collects SQL statement statistics from v$sqlarea performance view (Oracle 12c only).
SQL waits Oracle Collects SQL wait statistics.
Top user memory usage Oracle Check can be used to trace memory usage per server-process (session).
Undo statistics Oracle Collects rollback segment statistics.
User memory statistics Oracle Collects user memory statistics.
Wait statistics Oracle Collects waits statistics encountered by threads that executed. This task is based on the v$system_event dynamic performance view.
SQL statistics Oracle Collects SQL statements statistics from V$SQLAREA and V$SQL_PLAN dynamic performance views..
SQL statistics Oracle Collects SQL statements statistics (for container database) from V$SQLAREA and V$SQL_PLAN dynamic performance views.
SQL statistics Oracle Collects SQL statements statistics (for pluggable database) from V$SQLAREA and V$SQL_PLAN dynamic performance views.
SQL statistics Oracle Collects SQL statements statistics from V$SQLAREA and V$SQL_PLAN dynamic performance views..
Backup check – pg_dump Postgres Checks that there exists an up to date backup file.
Backup check – WAL Postgres Checks that the WAL files have been backed up.
DBMS uptime Postgres Collects database uptime statistics.
dbWatch engine alert Postgres Collects database uptime statistics.
Database growth rate and info Postgres Collects detailed growth rate information.
Log size statistics Postgres Checks the size of the log file.
Max connections Postgres Checks the size of the log file.
Schema growth collector Postgres Checks the size of the log file.
Vacuum alert Postgres Checks the size of the log file.
Schema growth statistics Postgres Collects and analyzes schema growth statistics from data collected by
Tablespace growth and information Postgres Shows an overview of tablespace growth and statistics.
BDR Replication lag Postgres Checks for BDR replication lag
Replication delay alert Postgres Checks for BDR replication lag
Replication slave client alert Postgres Checks for BDR replication lag
Replication slave client alert Postgres Checks for BDR replication lag
Backup job – pg_dump_all Postgres Runs a backup of all the postgres databases on an instance using pg_dumpall through an ssh connection.
framework Postgres dbWatch engine framework job (for internal use only). Used for patching or upgrading of dbWatch engine framework.
Analyze tables Postgres dbWatch engine framework job (for internal use only). Used for patching or upgrading of dbWatch engine framework.
Vaccum tables Postgres dbWatch engine framework job (for internal use only). Used for patching or upgrading of dbWatch engine framework.
Blocking statistics Postgres Checks whether there exists any blocked sessions.
Buffer cache reads per database Postgres Collects the number of block fetch requests for table or index per database.
Buffer cache statistics Postgres Gets data cache statistics from pg_stat_database view.
Disk block hitrate Postgres Checks the hitrate for disk block requests.
Disk block reads per database Postgres Collects the number of disk block fetch requests for table or index per database.
Test DML performance Postgres Runs performance test. Procedure executes SELECT, INSERT, UPDATE, DELETE and TRUNCATE statements on schema test tables.
Index block hitrate Postgres Checks the hitrate for index disk block requests.
Locks held and statistics Postgres Shows locks held statistics.
Table and index scan collector Postgres Shows locks held statistics.
Session load Postgres Gathers session load statistics.
Table and index scan statistics Postgres This task gathers scan statistics on tables and indexes from pg_stat_all_tables view.
Transaction statistics Postgres Gathers information on commits and rollbacks in the databases and generates statistics.
SQL statistics Postgres Collects performance statistics for the SQL statements.
SQL statistics Postgres Collects performance statistics for the SQL statements.
Agresso report queue Sqlserver Monitors and checks pending or running reports. Returns warning or alarm if the elapsed time exceeds defined thresholds.
Agresso blob size collector Sqlserver Collects information about the size of blobs in agresso databases.
Agresso framework Sqlserver Checks whether there is an installation of the agresso application in any of the databases.
Agresso help and temp tables Sqlserver Collects information about objects (temporary tables and help tables) created in the agresso application schema.
Agresso – missing system indexes Sqlserver Checks if there are any missing system indexes in the agresso database by comparing records in dbo.asysindex and sys.indexes tables.
Agresso – missing user indexes Sqlserver Checks if there are any missing user indexes in the agresso database by comparing records in dbo.asysindex and sys.indexes tables.
Agresso – not registered indexes Sqlserver Checks if there are any indexes in the agresso database which are not registered in the dbo.asysindex or dbo.aagindex tables.
Agent error log Sqlserver Reads and checks the Agent error log file by using the sp_readerrorlog stored procedure.
Agent Jobs Check Sqlserver Checks whether there exists jobs on the SQL server which have not been executed, or have failed during execution.
Agent Jobs Check Sqlserver Checks whether there exists jobs on the SQL server which have not been executed or have failed during execution.
SQL Server Agent status Sqlserver Checks if the SQL Server Agent is running.
Database backup Sqlserver This procedure analyzed the backup statistics from msdb.dbo.backupset table (excluding system databases: master, model and msdb).
Database backup Sqlserver This procedure analyzed the system database backups statistics from msdb.dbo.backupset table.
Database backup Sqlserver This procedure analyzes the backup statistics (type D and I) from the msdb.dbo.backupset table (excluding the system databases: master, model and msdb).
Database Log backup Sqlserver This procedure checks the database transaction log backups from the msdb.dbo.backupset table (excluding system databases: master, model and msdb).
Database backup Sqlserver This procedure analyzes the backup statistics (type D and I) from the msdb.dbo.backupset table (excluding the system databases: master, model and msdb).
Database backup Sqlserver This procedure analyzes the backup statistics (type D) from the msdb.dbo.backupset table for databases in SIMPLE recovery model (excluding the system databases: master, model and msdb).
Database backup Sqlserver This procedure analyzes the FULL backup statistics for the system databases (master, model and msdb) using data from the msdb.dbo.backupset table.
Database Log backup Sqlserver This procedure checks the database transaction log backups from the msdb.dbo.backupset table (excluding system databases: master, model and msdb).
Collation check Sqlserver Checks if there is a collation conflict with temp tables and table variables.
Check database recovery mode Sqlserver Checks if all databases are running in FULL or SIMPLE recovery mode.
Database status Sqlserver Checks if all databases have status ONLINE
Database status Sqlserver Checks if all databases have status ONLINE
Database Server uptime Sqlserver Collects database server uptime statistics.
Database Server uptime Sqlserver Collects database server uptime statistics.
Database Server uptime Sqlserver Collects database server uptime statistics.
Deadlocks event collector Sqlserver Collects deadlocks event statistics from Microsoft SQL Server Extended Event Log files. If configured a warning or an alarm can be triggered when a deadlock is detected.
Instance error log Sqlserver Reads and checks the Instance error log file by using the sp_readerrorlog stored procedure.
Instance error log Sqlserver Reads and checks the Instance error log file by using the AWS rdsadmin.dbo.rds_read_error_log stored procedure.
Instance status Sqlserver This alert checks if the instance has been restarted since the last check
Database backup Sqlserver This alert checks if the instance has been restarted since the last check
Database log backup Sqlserver This alert checks if the instance has been restarted since the last check
Database status Sqlserver This alert checks if the instance has been restarted since the last check
Missing database backup Sqlserver This alert checks if the instance has been restarted since the last check
Missing database log backup Sqlserver This alert checks if the instance has been restarted since the last check
Program status Sqlserver Checks for any program connected to the SQL Server by checking the program_name column in the master.dbo.sysprocesses table.
Report Server status Sqlserver Checks if the program ‘Report Server’ is connected to the SQL Server by checking the program_name column in the master.dbo.sysprocesses table.
Restricted Enterprise edition features Sqlserver Checks if there are any restricted features in use (supported only by Enterprise or Developer SQL Server edition).
Restricted Enterprise edition features Sqlserver Checks if there are any restricted features in use (supported only by Enterprise or Developer SQL Server edition).
Restricted Enterprise edition features 2005 Sqlserver Checks if there are any restricted features in use (supported only by Enterprise or Developer SQL Server edition).
Test alert Sqlserver Test alert that alerts every ‘X’ minutes.
Auto growth event collector Sqlserver Collects statistics on how often an auto-growth event has occurred.
Data file size check Sqlserver Checks the remaining space for all databases where the data files are set with limited growth rate (max size not unlimited).
Data file size check Sqlserver Checks the remaining space for all databases where the data files are set with limited growth rate (max size not unlimited).
Database growth rate Sqlserver Collects size of all database files (including transaction log files) to visualize the growth rate for all databases.
Database growth rate Sqlserver Collects size of all database files (including transaction log files) to visualize the growth rate for all databases.
Database growth rate Sqlserver Collects size of database files (including transaction log files) to visualize the growth rate for the largest databases.
Database growth rate Sqlserver Collects size of all database files (including transaction log files) to visualize the growth rate for all databases.
Database disk capacity Sqlserver Checks free space on drives where data and transaction log files are defined. An alarm (or warning) is raised if the percentage limit is reached OR if the absolute limit is reached. IF the xp_cmdshell Instance configuration option is enabled the alert can check disk and mounted volumes where data-files are not present.
Database disk space usage Sqlserver Checks free space on drives where all data and transaction log files are defined. Drives where no data files exist will be ignored.
Databases NOT IN USE collector Sqlserver Collects information about most inactive databases.
Disk space check Sqlserver Checks the amount of free space on the available disk drives.
Instance error log file size check Sqlserver Checks the size and the Instance error log file by using the extended stored procedure xp_cmdshell.
Filegroups growth rate Sqlserver This procedure collects space usage for the largest filegroups defined in each database. The undocumented ‘sp_MSforeachdb’ Stored Procedure is used to execute T-SQL statements against dbo.sysfiles table in every database defined on a SQL Server instance.
Filegroups growth rate Sqlserver This procedure collects space usage in all filegroups defined in each database. The undocumented ‘sp_MSforeachdb’ Stored Procedure is used to execute T-SQL statements against dbo.sysfiles table in every database defined to a SQL Server instance.
Data file size check Sqlserver This procedure collects space usage in all filegroups defined in each database. The undocumented ‘sp_MSforeachdb’ Stored Procedure is used to execute T-SQL statements against dbo.sysfiles table in every database defined to a SQL Server instance.
Disk space check Sqlserver This procedure collects space usage in all filegroups defined in each database. The undocumented ‘sp_MSforeachdb’ Stored Procedure is used to execute T-SQL statements against dbo.sysfiles table in every database defined to a SQL Server instance.
Transaction log space usage Sqlserver This procedure collects space usage in all filegroups defined in each database. The undocumented ‘sp_MSforeachdb’ Stored Procedure is used to execute T-SQL statements against dbo.sysfiles table in every database defined to a SQL Server instance.
Objects size collector Sqlserver Collects table and index size information for the largest objects for all databases.
Table size collector Sqlserver Collects table (HEAP and CLUSTER type) size statistics.
Temporary database space usage Sqlserver Checks space usage in tempdb database, and collects statistics including size of data and transaction log files.
Transaction log size check Sqlserver This procedure checks the size of the transaction log (log file(s) size), and compares it to the database size (data file(s) size). If the size of the transaction log file(s) in percentage is greater than the warning/alarm parameter value, the check returns a warning/alarm.
Transaction log size check Sqlserver This procedure checks the size of the transaction log (log file(s) size), and compares it to the database size (data file(s) size). If the size of the transaction log file(s) in percentage is greater than the warning/alarm parameter value, the check returns a warning/alarm.
Transaction log space usage Sqlserver This procedure checks information in sys.dm_db_log_space_usage view which shows space usage in the transaction log.
Transaction log space usage Sqlserver This procedure checks information returned by DBCC SQLPERF which is used to monitor the amount of space used in the transaction log.
Transaction log space usage Sqlserver This procedure checks information returned by DBCC SQLPERF which is used to monitor the amount of space used in the transaction log.
Truncate transaction log Sqlserver This procedure truncates the transaction log for the dbWatch database.
Version store space usage Sqlserver Checks total space in tempdb used by version store records for each database.
Query Store status Sqlserver Checks Query Store space usage in every database where it is enabled.
AG synchronization lag Sqlserver Checks AG synchronization lag.
Database mirroring Sqlserver Checks state information of all mirrored databases.
Failover cluster host switch Sqlserver Checks if an instance switched to a different host i a Windows Server Failover Cluster (WSFC).
Health state Sqlserver Checks groups health state.
Log shipping monitor Sqlserver Monitor the primary database in each log shipping configuration, including information about the last backup file and last restored file.
Log shipping monitor Sqlserver Monitor the secondary database in each log shipping configuration.
Member state Sqlserver Checks the status of each member node of the current WSFC cluster based on Dynamic Management Views sys.dm_hadr_cluster_members.
AlwaysOn database backup alert Sqlserver Checks the status of each member node of the current WSFC cluster based on Dynamic Management Views sys.dm_hadr_cluster_members.
AlwaysOn differential database backup alert Sqlserver Checks the status of each member node of the current WSFC cluster based on Dynamic Management Views sys.dm_hadr_cluster_members.
AlwaysOn transaction log backup alert Sqlserver Checks the status of each member node of the current WSFC cluster based on Dynamic Management Views sys.dm_hadr_cluster_members.
Replica states Sqlserver Checks role state for all alwayson groups.
Replication status Sqlserver The following check provides general info in regards to any replication going on in a server.
Database statistics Sqlserver This procedure gathers statistics per database.
DEMO blocking sessions Sqlserver Creates tables that can be used to simulate blocked sessions in the database.
dbWatch engine alert Sqlserver Creates tables that can be used to simulate blocked sessions in the database.
dbWatch Server activity alert Sqlserver Creates tables that can be used to simulate blocked sessions in the database.
Autogrowth settings Sqlserver Checks database files auto-growth settings.
Autoshrink settings Sqlserver Checks if all databases have auto-shrink turned off.
framework Sqlserver dbWatch engine framework job (for internal use only). Used for patching or upgrading of dbWatch engine framework.
framework Sqlserver dbWatch engine framework task (for internal use only). Used for patching or upgrading of dbWatch engine framework.
Backup All databases Sqlserver Takes backup of all application and system databases.
Backup All transaction logs Sqlserver Takes backup of all transaction logs for databases running in FULL recovery mode.
Check database and server principal mapping Sqlserver Checks if the database owner (dbo) is mapped into any Server Login (server principal).
Cleanup MSDB history tables Sqlserver This task deletes entries in the MSDB database history tables which holds statistics of backup/restore, jobs and maintenance plan executions.
Cycle error log Sqlserver This task cycle MS SQL Server error log and Agent error log files.
DBCC CHECKDB Sqlserver Checks the logical and physical integrity of all the objects in all databases by performing the DBCC CHECKDB operation.
DBCC UPDATEUSAGE Sqlserver This task is performing the DBCC UPDATEUSAGE operation to corrects pages and row count inaccuracies in the catalog views. These inaccuracies may cause incorrect space usage reports returned by the sp_spaceused system stored procedure.
External fragmentation Sqlserver External (logical) fragmentation occurs when an index leaf page is not in logical order. It occurs when the logical ordering of the index does not match the physical ordering of the index. This causes SQL Server to perform extra work to return ordered results.
Internal fragmentation check Sqlserver Checks the internal fragmentation for tables and indexes in all databases. The information is extracted from the dynamic management function (view) sys.dm_db_index_physical_stats.
Page verify option Sqlserver This job checks whether PAGE_VERIFY database option is set to CHECKSUM. This helps provide a high level of data-file integrity.
SQL Server performance counters Sqlserver Checks if SQL Server performance counters are missing.
Rebuild indexes Sqlserver Rebuilds fragmented indexes in all databases.
Rebuild indexes in table Sqlserver Rebuilds fragmented indexes in all tables listed in the ‘table list’ parameter.
Reorganize indexes Sqlserver Reorganizes fragmented indexes in all databases.
Reorganize indexes in table Sqlserver Reorganizing fragmented indexes in all tables listed in the ‘table list’ parameter.
Shrink transaction logs Sqlserver This procedure shrinks transaction log files which are detected by ‘Transaction log size check’ alert which checks the size of the transaction log (log file(s) size), and compares it to the database size (data file(s) size).
Suspect pages Sqlserver Monitors suspect pages statistics in suspect_pages table.
Update index statistics Sqlserver Update statistics in all (non-system) databases.
Update statistics Sqlserver Update statistics in all (non system) databases.
Statistics migration Sqlserver Migrates statistics from a number of tasks from dbWatch version 12 to dbWatch CC.
Blocking detector Sqlserver Checks whether there exists blocked session.
Blocking statistics Sqlserver Checks whether there exists any blocked sessions.
Cached query statistics Sqlserver This task returns aggregate performance statistics based on cached query plans in SQL Server.
Data cache memory usage Sqlserver Collects data cache memory usage per database (for top 10 databases).
Data cache memory usage Sqlserver Collects data cache memory usage per database (for top 10 databases).
Data hit ratio Sqlserver Monitors the buffer cache hit ratio by extracting counter values from the master.dbo.sysperfinfo table for the counters ‘Buffer cache hit ratio’ and ‘Buffer cache hit ratio base’.
Database session load Sqlserver Shows the number of connections over time per database, host and application.
Test DML-DDL performance Sqlserver Runs performance test on the database. The procedure executes SELECT, INSERT, UPDATE, DELETE (and TRUNCATE) statements on the test table.
File IO statistics Sqlserver Collects I/O statistics for data and log files.
High activity monitor Sqlserver Collects SQL instance CPU usage, CPU usage of other processes, logical and physical reads, and active processes count on the SQL Server instance.
High activity monitor Sqlserver Collects SQL instance CPU usage, CPU usage of other processes, logical and physical reads, and active processes count on the SQL Server instance.
Index usage statistics Sqlserver This procedure collects statistics from sys.dm_db_index_usage_stats performance view which gives information on how an index (or a table – heap) has been used to resolve queries.
Instance memory check Sqlserver This job checks the target memory value of the SQL Server instance, and gives a warning/alarm if the instance is not able to allocate a
Instance memory usage Sqlserver Collects total memory usage and data cache memory usage for SQL Server instance. This dbWatch task can be configured to automatically reduce the amount of memory used by the SQL Server instance.
Instance memory usage Sqlserver Collects total memory usage and data cache memory usage for SQL Server instance. This dbWatch task can be configured to automatically reduce the amount of memory used by the SQL Server instance.
Lazy writer and Checkpoint statistics Sqlserver Monitors ‘Checkpoint pages/sec’, ‘Lazy writes/sec’ and ‘Page life expectancy’ by extracting counter values from the sys.dm_os_performance_counters performance table.
Memory objects statistics Sqlserver This task collects the size of memory objects that are currently allocated by the SQL Server
Blocking detector Sqlserver This task collects the size of memory objects that are currently allocated by the SQL Server
Instance memory check Sqlserver This task collects the size of memory objects that are currently allocated by the SQL Server
Server memory statistics Sqlserver This tasks collects statistics from the sys.dm_os_sys_info performance view about the memory resources available to and consumed by the SQL Server.
Sessions per database Sqlserver This task returns aggregate performance statistics based on sessions connected to the SQL Server instance.
Session load Sqlserver Shows the number of active sessions over time.
SQL statements Sqlserver Collects statistics for the SQL statements corresponding to the query plans that have resulted in the most logical reads.
Transactions log flushed bytes load Sqlserver Shows bytes flushed to transaction logs over time, total and top 5 databases.
Transactions log flushed bytes load Sqlserver Shows bytes flushed to transaction logs over time, total and top 5 databases.
Transactions load Sqlserver Shows the transactions load over time, total and top 5 databases.
Wait statistics Sqlserver Collects statistics about all waits encountered by threads that executed. This task is based on the sys.dm_os_wait_stats dynamic performance view.
First Responder Kit Sqlserver Checks if and where the procedures sp_BlitzBackups, sp_BlitzCache, sp_BlitzFirst, sp_BlitzIndex, sp_BlitzLock and sp_BlitzWho (related to Brent Ozar First Responder Kit scripts) are installed (Install-Core-Blitz-No-Query-Store.sql).
sp_BlitzCache Sqlserver Runs the sp_BlitzCache procedure (Brent Ozar) which displays your most resource-intensive queries from the plan cache.
sp_BlitzIndex Sqlserver Runs the sp_BlitzIndex procedure (Brent Ozar) which analyzes the design and performance of your indexes.
sp_BlitzLock Sqlserver Runs the sp_BlitzLock procedure (Brent Ozar) which checks for and analyzes deadlocks from the system health session or a custom extended event path
sp_BlitzWho Sqlserver Runs the sp_BlitzWho procedure (Brent Ozar) which, among other things, shows blocking sessions
Session statistics Sqlserver Collects session statistics.
SQL statistics Sqlserver Collects performance statistics for the SQL statements.
Database compatibility Sqlserver Checks if there is a difference in compatibility levels of databases and the instance.
Logins default database check Sqlserver This procedure performs two checks. ‘Sysadmin Logins Default Database Check’ which
MS SQL Server patch status Sqlserver Checks latest updates for Microsoft SQL Server.
Ad Hoc Distributed Queries Sqlserver Checks if the OPENROWSET and OPENDATASOURCE functions can be used to connect to remote data sources that use OLE DB (DB2, Host File systems, Oracle, etc.).
Asymmetric Key size Sqlserver Checks that at least a 2048-bit encryption key size is used for asymmetric keys.
Auto close database Sqlserver Checks if the contained databases are closed or not after a connection terminates.
CLR Assembly permission Sqlserver Checks if the CLR Assembly permission_set is set to SAFE access.
CLR Enabled Sqlserver Checks if the assemblies can be run by SQL Server.
Command shell setting Sqlserver Checks if the xp_cmdshell is enabled, as a security best practice it is recommended to only enable it for the duration of the actual task that requires it.
Contained database credentials Sqlserver Checks if the database users in contained databases are using database authentication (authentication_type = 2).
Cross DB Ownership Chaining Sqlserver Checks cross-database ownership chaining across all databases at the instance level.
Database Mail XPs Sqlserver Checks the ability to generate and transmit email messages from SQL Server.
Default trace enabled Sqlserver Checks that ‘Default Trace Enabled’ server configuration option is set to ‘1′.
Disabled sa account Sqlserver Checks if the ‘sa’ login account (principal_id=1 and sid=0×01) is set to ‘disabled’.
Number of ERRORLOG files Sqlserver Checks the number of error log files created on the operating file system.
Full-Text service account Sqlserver Checks if the service account used by the Full-Text service account is not a member of the Windows Administrator group.
Guest database users Sqlserver Checks that CONNECT permission (in every non system database) are revoked for the guest user.
Hide Instance Sqlserver Checks if the instance is hidden (not exposed by SQL Browser).
Instance Authentication Mode Sqlserver Checks if the Server Authentication property is set to ‘Windows Authentication Mode’ or ‘Mixed Mode’ authentication.
Login audit setting Sqlserver Checks if the SQL Server login audit is set to value ‘2′ (none = 0, successful logins only = 1, failed logins only = 2, both failed and successful logins = 3).
Login failed and successful setting Sqlserver Checks if the SQL Server login audit is set to value ‘3′ (none = 0, successful logins only = 1, failed logins only = 2, both failed and successful logins = 3).
Public role Sqlserver Checks that the public role in the msdb database is not granted access to SQL Agent proxies.
MS SQL service account Sqlserver Checks if the service account used by the MSSQLSERVER service is not a member of the Windows Administrator group.
Ole Automation Procedures Sqlserver Checks whether OLE Automation objects can be instantiated within Transact-SQL batches.
Orphaned database users Sqlserver Checks if there are orphaned database users (users for which the corresponding SQL Server login is undefined).
Password expiration Sqlserver Checks that CHECK_EXPIRATION option is set to ‘ON’ for all SQL authenticated logins within the sysadmin role.
Password policy Sqlserver Checks that CHECK_POLICY option is set to ‘ON’ for all SQL authenticated logins.
Public server role Sqlserver Checks if extra permissions have been granted to the public server role.
Remote access Sqlserver Checks if local stored procedures can execute on remote servers or remote stored procedures on local server.
Remote admin connections Sqlserver Checks whether a client application on a remote computer can use the Dedicated Administrator Connection (DAC).
Renamed sa account Sqlserver Checks if the standard ‘sa’ login account (principal_id=1 and sid=0×01) has been renamed.
Scan for startup procs Sqlserver Check if MS SQL Server automatically scan and run all stored procedures that are set to execute upon service startup.
Security and Compliance framework Sqlserver dbWatch Security framework job. Used for collecting and analysis of statistics from all Security jobs.
SQL Browser Sqlserver Checks if the SQL Server Browser is disabled.
SQL Server Protocols Sqlserver Check what SQL Server protocols are in use.
SQL Agent service account Sqlserver Checks if the service account used by the SQL Agent service is not a member of the Windows Administrator group.
Standard ports Sqlserver Verify the usage of standard ports, with TCP port 1433 being the default.
Symmetric Key encryption Sqlserver Checks that only AES_128, AES_192, and AES_256 symmetric key encryption algorithms are in use.
Trustworthy Sqlserver Check if the TRUSTWORTHY database option allows database objects to access objects in other databases.
Windows BUILTIN groups Sqlserver Checks that Windows BUILTIN groups are not SQL Logins.
Windows LOCAL groups Sqlserver Checks that Windows LOCAL groups are not SQL Logins.
Database backup Sybase Checks backup status of all databases.
Database status Sybase Checks status of all databases defined on the system. The following incidents triggers a warning or an alarm:
DBMS uptime Sybase Collects database uptime statistics.
Database space check Sybase Checks the amount of free space in all databases.
Database space check Sybase Checks the amount of free space in all databases.
Database growth rate Sybase Collects database growth rates statistics.
Transaction log space check Sybase Checks the amount of free space in all transaction logs.
Dump database Sybase Runs backup of all databases using ‘dump database’ command.
Blocking detector Sybase 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 Sybase Collects data cache statistics based on the dbWatch tasks ‘System monitor collector’ which runs the ‘dbcc monitor’ utility continuously.
Data cache statistics Sybase Collects data cache statistics.
Disk activity monitor Sybase Collects statistics created by the ‘System monitor collector’ task.
Test DML-DDL performance Sybase Runs performance test on database.The procedure executes SELECT, INSERT, UPDATE and DELETE statements on dbwatch engine schema test tables.
Engine CPU monitor Sybase 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 Sybase Collects memory statistics based on the dbWatch tasks ‘System monitor collector’ which runs the ‘dbcc monitor’ utility continuously.
Procedure cache check Sybase Checks the procedure cache.
Procedure cache check Sybase Checks the procedure cache.
Session load Sybase Shows session statistics.
System monitor collector Sybase 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 Sybase Collects temp cache statistics from master..monTempdbActivity performance view.
User connections check Sybase Checks the configuration setting for the ‘number of remote 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 Sybase 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).
SQL statistics Sybase Collects performance statistics for the SQL statements.