| Binlog cache check |
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 |
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 |
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 |
Collects instance memory statistics. |
| Instance memory statistics |
Collects instance memory statistics. |
| Lock statistics |
Collects lock statistics |
| Lock statistics |
Collects lock statistics |
| MyISAM key cache check |
Checks the hit rate of the MyISAM key cache. |
| MyISAM key cache check |
Checks the hit rate of the MyISAM key cache. |
| Network statistics |
This job collects the number of bytes received and sent from all clients. |
| Network statistics |
This job collects the number of bytes received and sent from all clients. |
| Session load |
Records the number of active and inactive sessions over time. |
| Session load |
Records the number of active and inactive sessions over time. |
| Threads statistics |
Checks the number of threads created per minute. |
| Temporary table check |
Shows percentage of temporary tables written to disk |
| Binlog cache check |
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 |
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 |
Checks the hit rate of the innodb buffer pool using performance_schema.global_status. |
| InnoDB buffer pool check |
Checks the hit rate of the innodb buffer pool using information_schema.global_status. |
| Instance memory statistics |
Collects instance memory statistics. |
| Instance memory statistics |
Collects instance memory statistics. |
| Lock statistics |
Collects lock statistics |
| Lock statistics |
Collects lock statistics |
| MyISAM key cache check |
Checks the hit rate of the MyISAM key cache. |
| MyISAM key cache check |
Checks the hit rate of the MyISAM key cache. |
| Network statistics |
This job collects the number of bytes received and sent from all clients. |
| Network statistics |
This job collects the number of bytes received and sent from all clients. |
| Session load |
Records the number of active and inactive sessions over time. |
| Session load |
Records the number of active and inactive sessions over time. |
| Statement load |
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 |
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 |
Checks the number of threads created per minute. |
| Threads statistics |
Checks the number of threads created per minute. |
| Temporary table check |
Shows percentage of temporary tables written to disk |
| Temporary table check |
Shows percentage of temporary tables written to disk |
| Blocking detector |
Checks if a session is waiting on a TX (transaction) lock. |
| Buffer cache statistics |
Gets data cache statistics for buffer cache in SGA. |
| Test DML performance |
Runs performance test. Procedure executes SELECT, INSERT, UPDATE, DELETE and TRUNCATE statements on schema test tables. |
| Database network statistics |
Checks database network SQL*NET statistics. |
| Instance memory statistics |
Collects statistics on instance memory. |
| Latch statistics |
Collects latch status statistics. |
| Redo statistics |
Collects redo log switch and transaction statistics per hour and per day using Oracle dynamic performance views. |
| Redo statistics |
Gets redolog files statistics. Based on Oracle dictionary and performance views. |
| SQL statement statistics |
Collects SQL statement statistics from v$sqlarea performance view (Oracle 18c and newer). |
| SQL statement statistics |
Collects SQL statement statistics from v$sqlarea performance view (Oracle 10g only). |
| SQL statement statistics |
Collects SQL statement statistics from v$sqlarea performance view (Oracle 11g only). |
| SQL statement statistics |
Collects SQL statement statistics from v$sqlarea performance view (Oracle 12c only). |
| SQL waits |
Collects SQL wait statistics. |
| Undo statistics |
Collects rollback segment statistics. |
| User memory statistics |
Collects user memory statistics. |
| CPU load |
Checks CPU load using Oracle performance view v$osstat. |
| File IO statistics |
Collects I/O statistics for data files. |
| Long running queries |
Checks for long running queries. |
| Open cursors |
Checks and collects the amount of open cursors per session. |
| Disk read statistics |
Collects disk read statistics from v$system_event performance view for db file sequential and dbfile scattered read event. |
| Disk read statistics |
Collects disk read statistics from v$system_event performance view for db file sequential and dbfile scattered read event. |
| Session load |
Records the number of active and inactive sessions over time. |
| Session load |
Records the number of active sessions over time. |
| Top user memory usage |
Check can be used to trace memory usage per server-process (session). |
| Wait statistics |
Collects waits statistics encountered by threads that executed. This task is based on the v$system_event dynamic performance view. |
| Test DML performance |
Runs performance test. Procedure executes SELECT, INSERT, UPDATE, DELETE and TRUNCATE statements on schema test tables. |
| Blocking statistics |
Checks whether there exists any blocked sessions. |
| Buffer cache reads per database |
Collects the number of block fetch requests for table or index per database. |
| Buffer cache statistics |
Gets data cache statistics from pg_stat_database view. |
| Disk block hitrate |
Checks the hitrate for disk block requests. |
| Disk block reads per database |
Collects the number of disk block fetch requests for table or index per database. |
| Index block hitrate |
Checks the hitrate for index disk block requests. |
| Locks held and statistics |
Shows locks held statistics. |
| Table and index scan collector |
Shows locks held statistics. |
| Session load |
Gathers session load statistics. |
| Table and index scan statistics |
This task gathers scan statistics on tables and indexes from pg_stat_all_tables view. |
| Transaction statistics |
This procedure collects and stores historical snapshots of the xact_commit and xact_rollback counters from the pg_stat_database view. |
| Test DML-DDL performance |
Runs performance test on the database. The procedure executes SELECT, INSERT, UPDATE, DELETE (and TRUNCATE) statements on the test table. |
| Index usage statistics |
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. |
| Blocking detector |
Checks whether there exists blocked session. |
| Blocking statistics |
Collects and evaluates current blocking sessions from master..sysprocesses. Raises WARNING or ALARM when blocking wait times exceed configured thresholds, and writes qualifying events to history tables. |
| Cached query statistics |
This task returns aggregate performance statistics based on cached query plans in SQL Server. |
| Data cache memory usage |
Collects data cache memory usage per database (for top 10 databases). |
| Data cache memory usage |
Collects data cache memory usage per database (for top 10 databases). |
| Data hit ratio |
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 |
Shows the number of connections over time per database, host and application. |
| File IO statistics |
Collects I/O statistics for data and log files. |
| High activity monitor |
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 |
Collects SQL instance CPU usage, CPU usage of other processes, logical and physical reads, and active processes count on the SQL Server instance. |
| First Responder Kit |
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). |
| Instance memory check |
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 |
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 |
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 |
Monitors ‘Checkpoint pages/sec’, ‘Lazy writes/sec’, ‘Free List Stalls/sec’ and ‘Page life expectancy’ by extracting counter values from the sys.dm_os_performance_counters performance table. |
| Memory objects statistics |
This task collects the size of memory objects that are currently allocated by the SQL Server |
| Blocking detector |
This task collects the size of memory objects that are currently allocated by the SQL Server |
| Instance memory check |
This task collects the size of memory objects that are currently allocated by the SQL Server |
| Server memory statistics |
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 |
This task returns aggregate performance statistics based on sessions connected to the SQL Server instance. |
| Session load |
Shows the number of total and active sessions over time. |
| SQL statements |
Collects statistics for the SQL statements corresponding to the query plans that have resulted in the most logical reads. |
| SQL Workload collector |
Collects key SQL Server statistics counters, including Batch Requests/sec, SQL Compilations/sec, and SQL Re-Compilations/sec. |
| Transactions log flushed bytes load |
Shows bytes flushed to transaction logs over time, total and top 5 databases. |
| Transactions log flushed bytes load |
Shows bytes flushed to transaction logs over time, total and top 5 databases. |
| Transactions load |
Shows the transactions load over time, total and top 5 databases. |
| Wait statistics |
Collects statistics about all waits encountered by threads that executed. This task is based on the sys.dm_os_wait_stats dynamic performance view. |
| Test DML-DDL performance |
Runs performance test on database.The procedure executes SELECT, INSERT, UPDATE and DELETE statements on dbwatch engine schema test tables. |
| 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. |
| 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 from master..monTempdbActivity performance view. |
| User connections check |
Checks the configuration setting for 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). |
| SQL statistics |
Collects performance statistics for SQL statements. |
| SQL statistics |
Collects performance statistics for SQL statements. |
| SQL statistics |
Collects performance statistics for SQL statements. |
| SQL statistics |
Collects SQL statements statistics from V$SQLAREA and V$SQL_PLAN dynamic performance views.. |
| SQL statistics |
Collects SQL statements statistics (for container database) from V$SQLAREA and V$SQL_PLAN dynamic performance views. |
| SQL statistics |
Collects SQL statements statistics (for pluggable database) from V$SQLAREA and V$SQL_PLAN dynamic performance views. |
| SQL statistics |
Collects SQL statements statistics from V$SQLAREA and V$SQL_PLAN dynamic performance views.. |
| SQL statistics |
Collects performance statistics for the SQL statements. |
| SQL statistics |
Collects performance statistics for the SQL statements. |
| SQL statistics |
Collects performance statistics for the SQL statements. |
| Session SQL event collector |
This job collects performance statistics from the dbWatchSessionStatsXE Extended Events session. It captures long-running SQL batches and RPC calls along with relevant session and database information. Complements the ‘SQL statistics’ job by adding visibility into who is executing what. |
| Session statistics |
Collects session statistics. |
| SQL statistics |
Takes snapshots of performance data for cached SQL query plans by reading from system dynamic management views: sys.dm_exec_query_stats, sys.dm_exec_sql_text, and sys.dm_exec_text_query_plan. |
| SQL statistics |
Collects performance statistics for the SQL statements. |