Search
Related topics are listed below.
Jobs for MariaDB
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB
Control Center Jobs Description Availability DBMS uptime Collects uptime statistics in the database. Aborted connects alert Collects uptime statistics in the database. Maximum connections alert Collects uptime…
MariaDB Space Optimizer
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » MariaDB Space Optimizer
Name: MariaDB Space Optimizer Platform: Mariadb Category: Availability Description: Tells the user how much space tables in a specific database consume. Long description: Version: 1 Default…
Jobs for MySQL
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MySQL
Control Center Jobs Description Availability DBMS uptime Collects uptime statistics in the database. MySQL aborted connects Checking if there is many aborted connects MySQL max connections Checking if the system…
MariaDB Index Redundancy Checker
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » MariaDB Index Redundancy Checker
Name: MariaDB Index Redundancy Checker Platform: Mariadb Category: Performance Description: Shows percentage of temporary tables written to disk Long description: Version: 1 Default…
MySQL max connections
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MySQL » MySQL max connections
Name: MySQL max connections Platform: Mysql Category: Description: Checking if the system is near maximum connections Long description: Version: 1 Default…
MySQL mysqld process
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MySQL » MySQL mysqld process
Name: MySQL mysqld process Platform: Mysql Category: Description: Checking if mysqld process is running Long description: Version: 1 Default schedule: 15m Requires engine…
MySQL aborted connects
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MySQL » MySQL aborted connects
Name: Aborted connections Platform: Mysql Category: Availability Description: Checks the number of aborted client connections. Long description: Checks the number of aborted client connections. Usually this is…
Adding a MySQL Instance
Using Control Center » Instance management » Adding a MySQL Instance
How to get here To open the “Add Instance Wizard”, click on the “Plus (+)” sign on the bottom left of the dbWatch Client. This will bring up the “Add Instance” wizard, which will guide you through the following steps. Select Instance Type and Input…
Using SQL Performance package on MySQL
Installing and using premium packages » SQL Performance package » Using SQL Performance package on MySQL
Navigating to the SQL Performance package dashboard Once the SQL statistics job is installed and have collected data, you can navigate to the dashboard. It is located in the management interface for that database instance. The pictures and descriptions are from…
Adding MySQL Instance with Super Privilege Error
Troubleshooting Guide » Adding MySQL Instance with Super Privilege Error
MySQL Super Privilege Error When adding an instance for MySQL 5.0 or over, you may encounter the following error: This error happens when dbWatch Control Center is creating a user. This error appears indicating that the user has no super privilege rights. There…
Jobs for PostgreSQL
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for PostgreSQL
Control Center Jobs Description Availability Backup check – pg_dump Checks that there exists an up to date backup file. Backup check – WAL Checks that the WAL files have been backed up. DBMS…
Jobs for Sybase
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Sybase
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…
Jobs for Oracle
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle
Control Center Jobs Description Availability Alert log check This check reads and looks for errors in the database alert log. Alert log check This check reads and looks for errors in the database alert log. Alert…
Editor for engine jobs
Customization » Monitoring » Editor for engine jobs
How to get here Example jobs We have some example jobs to make the development easier here. Edit Existing To edit an existing Task or Alert open the Task/Alert Editor by right clicking on any task or alert and select Edit task from the popup menu. Create new…
Blocking detector for RAC
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Blocking detector for RAC
Name: Blocking detector for RAC Platform: Oracle Category: Cluster and Replication Description: Checks if a session is waiting on a TX (transaction) lock. (RAC only) Long description: Task checks if a session is…
Issues and troubleshooting
Troubleshooting Guide » Issues and troubleshooting
High CPU usage on database Occasionally when investigating resource-consuming SQL statements running on your system, you may find that some of them belong to the dbWatch application. For example, a SQL statement that has the highest value of spent CPU time. In most…
Email and SMS
Customization » Extensions and 3rd party integrations » Email and SMS
Configure In the dbWatch Monitor, go to the “Server”->”Server Extensions” menu. An item called “E-mail extension” should now be visible (v 5.2 or later). To configure the extension, select it and click “Configure”. You should now see the initial…
Network and communications
Product Overview » Network and communications
Network and communications Default ports and protocol dbWatch Control Center uses by default port 7100/tcp for client to node and node to node connections. This can be configured to a different port. On each node there is a node.connections file that both lists what…
Cluster and replication
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by category » Cluster and replication
Jobs in the Cluster and replication category Control Center Jobs Description Oracle Blocking detector for RAC Checks if a session is waiting on a TX (transaction) lock. (RAC only) Memory session load for RAC Records the…
Jobs for MS SQL Server
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server
Control Center Jobs Description Availability Agent Jobs Check Checks whether there exists jobs on the SQL server which have not been executed, or have failed during execution. Agent Jobs Check for MS2000 Checks whether there…
Memory session load for RAC
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Memory session load for RAC
Name: Memory session load for RAC Platform: Oracle Category: Cluster and Replication Description: Records the load memory of RAC active sessions over time. Long description: Task records the load memory of RAC…
Alert log check (java for 10g)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Alert log check (java for 10g)
Name: Alert log check (java) Platform: Oracle Category: Availability Description: This check reads and looks for errors in the database alert log. Uses embedded java to read files. Long description: This check…
Supported Web Browsers for dbWatch Dashboard
Customization » Web server » Supported Web Browsers for dbWatch Dashboard
As of the current version, dbWatch Dashboard supports the following web browsers: Google Chrome Microsoft Edge Firefox Why These Browsers? Our focus on Google Chrome and Microsoft Edge is driven by several factors: Advanced Features and Standards These…
Configuring email extension for Service Now
Customization » Extensions and 3rd party integrations » Email and SMS » Configuring email extension for Service Now
Integration with Servicenow In this example we will configure dbWatch and Servicenow so that alarms from dbWatch, can create incidents in Servicenow. To integrate the alerts from dbWatch with Servicenow incident creation, there are two parts that needs to be setup.…
Disabling and Enabling Views
Using Control Center » Disabling and Enabling Views
You can enable or disable modules from your dbWatch Control Center by unticking their check boxes. If you check Views, you will see the default set up of modules that are visible. Once you disable all the modules, you’ll only be left with the Report Module. …
Schema growth and information
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for PostgreSQL » Schema growth and information
Name: Schema growth and information Platform: Postgres Category: Capacity Description: Collects detailed schema growth rate information. Long description: Collects detailed schema growth rate…
Tablespace growth and information
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for PostgreSQL » Tablespace growth and information
Name: Tablespace growth and information Platform: Postgres Category: Capacity Description: Shows an overview of tablespace growth and statistics. Long description: Shows an overview of tablespace growth and…
Locks held and statistics
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for PostgreSQL » Locks held and statistics
Name: Locks held and statistics Platform: Postgres Category: Performance Description: Shows locks held statistics. Long description: Task shows locks held statistics. Version: 1.6 Default…
Network Ports and Services
Advanced Topics » Product Security » Network Ports and Services
Network Ports and Services Default ports and protocol dbWatch Control Center uses by default port 7100/tcp for client to node and node to node connections. This can be configured to a different port. If enabled the webserver can run. Default port is 8080. On each…
Privileges and actions map
Using Control Center » Domain Configuration » Privileges and actions map
Overview of actions and required privilege Instance is the specific database instance. Instance system is a predefined security group controlling the overall instance monitoring and management. Domain configuration is a predefined security group controlling the…
Disk and Memory usage
Using Control Center » Management » Management on SQL Server » Disk and Memory usage
This allows you to get an overview and drill down into disk and memory usage on the database instance. ← Sessions performance / Backups →
Repository management and monitoring
Installing and using premium packages » SQL Performance package » Repository management and monitoring
Introduction The SQL Performance package creates tables in the dbWatch schema/database on each database instance where the SQL Statistics job is installed and scheduled. The process combines two parts of dbWatch Control Center. The monitoring is used to schedule the…
Security and Compliance package
Installing and using premium packages » Security and Compliance package
Security and Compliance package The Security and Compliance package is an optional extra cost module in dbWatch Control Center that allows automated detection and reporting on security and compliance-related issues where database instances are not conforming to best…
Segment size status for old style tablespaces
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Segment size status for old style tablespaces
Name: Segment size status for old style tablespaces Platform: Oracle Category: Capacity Description: Checks segment storage definitions in tablespaces where extent management is not set to local. Long…
Monitor dashboards and overview screens
Product Overview » Monitor dashboards and overview screens
Being effective in database operations are one of the key focus areas for the dbWatch database operations team. This chapter will focus on the dashboards or overview screens used by our internal database operations team, what information they show, how they are used…
Extensions and 3rd party integrations
Customization » Extensions and 3rd party integrations
Configuring extensions and 3rd party integrations Email Contact support if you want to make sure you have installed the latest version of your extension. ← Reports / Email and SMS →
Session load (8i and 9i)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Session load (8i and 9i)
Name: Session load Platform: Oracle Category: Performance Description: Records the number of active sessions over time. Long description: Task records the number of active sessions over a period of…
Lazy writer and checkpoint statistics
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Lazy writer and checkpoint statistics
Name: Lazy writer and Checkpoint statistics Platform: Sqlserver Category: Performance Description: Monitors ‘Checkpoint pages/sec’, ‘Lazy writes/sec’ and ‘Page life expectancy’ by…
Table and index scan collector
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for PostgreSQL » Table and index scan collector
Name: Table and index scan collector Platform: Postgres Category: Performance Description: Shows locks held statistics. Long description: This job collects table and index scan statistics for all schemas i all…
Table and index scan statistics
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for PostgreSQL » Table and index scan statistics
Name: Table and index scan statistics Platform: Postgres Category: Performance Description: This task gathers scan statistics on tables and indexes from pg_stat_all_tables view. Long description: Statistics from…
Installing and using premium packages
Installing and using premium packages
Additional packages dbWatch Control Center also provides additional premium packages to cover specific areas. They may be specific only to one or a few of the platforms supported by dbWatch Control Center. More details are found on the pages specific to the package.…
Check database and server principal mapping
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Check database and server principal mapping
Name: Check database and server principal mapping Platform: Sqlserver Category: Maintenance Description: Checks if the database owner (dbo) is maped into any Server Login (server principal). Long…
Installation of the Security and Compliance package
Installing and using premium packages » Security and Compliance package » Installation of the Security and Compliance package
Installation of the Security and Compliance package The Security and Compliance package is a premium package that comes with extra cost. If you want to get this package and its not part of your current license, please contact sales@dbwatch.com. To install the…
Security and Compliance package on SQL Server
Installing and using premium packages » Security and Compliance package » Security and Compliance package on SQL Server
The Security and Compliance package The Security and Compliance package provides a detailed evaluation of your Microsoft SQL Server’s security and compliance, managed via dbWatch Control Center. It offers in-depth insights into your server’s security and…
Platforms supported
About dbWatch Control Center » Platforms supported
Platforms supported for the main product. Current release supports the following platforms, versions, and setups: On-premise support Supports* Express edition, Standard edition, Standard edition one, Standard edition two, and Enterprise edition of the following…
Jobs grouped by platform
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform
Go to the individual platforms to see the jobs for that database platform Jobs for Oracle Jobs for MS SQLServer Jobs for MySQL Jobs for MariaDB Jobs for PostgreSQL Jobs for Sybase ← Control Center Jobs / Jobs for Oracle →
Performance
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by category » Performance
Jobs in the Performance category Control Center Jobs Description Oracle Blocking detector Checks if a session is waiting on a TX (transaction) lock. Buffer cache statistics Gets data cache statistics for buffer cache in…
Control Center Jobs
Using Control Center » Monitoring » Control Center Jobs
Jobs (older dbWatch versions Tasks and alerts) are the cornerstone of the dbWatch Monitoring module. Jobs perform the actual monitoring of the database instance. There are two types of Monitoring in dbWatch. The Basic and Standard monitoring. To see each monitoring…
Availability
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by category » Availability
Jobs in the Availability category Control Center Jobs Description Oracle Alert log check This check reads and looks for errors in the database alert log. Alert log check This check reads and looks for errors in the database…
About dbWatch Control Center
About dbWatch Control Center
dbWatch Control Center is a highly scalable software solution that helps enterprises monitor and manage large database servers efficiently, providing total control over all database operations, performance, and resource usage. dbWatch Control Center will give you the…
Release notes
About dbWatch Control Center » Release notes
dbWatch Control Center (2024-03-11) Download Important note Linux release is available as an apt repository, see Linux install guide All clients and servers need to be upgraded in a multi-server setup before the connection will resume due to network…
Replica state
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » Replica state
Name: Replica state Platform: Mariadb Category: Cluster and Replication Description: This job checks if replica changes occurs. For example, if an instance becomes a replica or if an instance is no longer a…
Replica delay
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » Replica delay
Name: Replica delay Platform: Mariadb Category: Cluster and Replication Description: This job checks how “late” the replica is, and measures the time difference in seconds between the replication SQL (applier) thread…
Replica count
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » Replica count
Name: Replica count Platform: Mariadb Category: Cluster and Replication Description: This job checks all of replicas currently registered with the source. Long…
Capacity
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by category » Capacity
Jobs in the Capacity category Control Center Jobs Description Oracle ASM disk statistics Checks ASM disks for status and statistics. ASM diskgroup space Checks ASM diskgroups space statistics. Monitor SYS.AUD$…
Replica state
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MySQL » Replica state
Name: Replica state Platform: Mysql Category: Cluster and Replication Description: This job checks if replica changes occurs. For example, if an instance becomes a replica or if an instance is no longer a…
Database growth rate (aggregated)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » Database growth rate (aggregated)
Name: Database growth rate (aggregated) Platform: Mariadb Category: Capacity Description: Collects database size and visualizes the growth rate of the server. Long description: Collects database size and…
NDB data memory usage check
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » NDB data memory usage check
Name: NDB data memory usage check Platform: Mariadb Category: Cluster and Replication Description: NDB data memory usage check Long description: This checks the usage of data memory in NDB cluster…
NDB data node status
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » NDB data node status
Name: NDB data node status Platform: Mariadb Category: Cluster and Replication Description: NDB data node status Long description: This checks the status of data nodes in NDB cluster…
Aborted connects alert
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » Aborted connects alert
Name: Aborted connects alert Platform: Mariadb Category: Availability Description: Checking if there is many aborted connects Long description: Version: 1 Default…
Maximum connections alert
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » Maximum connections alert
Name: Maximum connections alert Platform: Mariadb Category: Availability Description: Checking if the system is near maximum connections Long description: Version: 1 Default…
MySQLd process alert
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » MySQLd process alert
Name: MySQLd process alert Platform: Mariadb Category: Availability Description: Checking if mysqld process is running Long description: Version: 1 Default…
SQL Performance package
Installing and using premium packages » SQL Performance package
SQL Performance package SQL Performance module is an optional extra cost module in dbWatch Control Center that allows for historical monitoring and analysis of SQL Statements in the database instance. Currently supported platforms: MS SQL Server 2014 and…
Key buffer check
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » Key buffer check
Name: Key buffer check Platform: Mariadb Category: Performance Description: Checks key buffer efficiency Long description: Task checks key buffer efficiency Version: 2.22 Default…
Lock statistics
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » Lock statistics
Name: Lock statistics Platform: Mariadb Category: Performance Description: Collects lock statistics Long description: This task collects lock data statistics Version: 2.11 Default…
Lock statistics (old)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » Lock statistics (old)
Name: Lock statistics Platform: Mariadb Category: Performance Description: Collects lock statistics Long description: This task collects lock data statistics Version: 2.11 Default…
Network traffic
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » Network traffic
Name: Network traffic Platform: Mariadb Category: Performance Description: Shows the network traffic Long description: Task shows amount of network traffic in the server Version: 2.2 Default…
Session load
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » Session load
Name: Session load Platform: Mariadb Category: Performance Description: Shows connection statistics Long description: Task shows connection data statistics Version: 2.21 Default…
Session load (old)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » Session load (old)
Name: Session load Platform: Mariadb Category: Performance Description: Shows connection statistics Long description: Task shows connection data statistics Version: 2.21 Default…
Replica delay
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MySQL » Replica delay
Name: Replica delay Platform: Mysql Category: Cluster and Replication Description: This job checks how “late” the replica is, and measures the time difference in seconds between the replication SQL (applier) thread and…
Binlog cache check
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » Binlog cache check
Name: Binlog cache check Platform: Mariadb Category: Performance Description: Binlog cache performance check Long description: This checks the performance of the ‘Binlog…
Binlog cache check (old)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » Binlog cache check (old)
Name: Binlog cache check Platform: Mariadb Category: Performance Description: Binlog cache performance check Long description: This checks the performance of the ‘Binlog…
Database growth rate (detailed)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » Database growth rate (detailed)
Name: Database growth rate (detailed) Platform: Mariadb Category: Capacity Description: Collects detailed growth rate information. Long description: Collects detailed information on the growth rate of the…
Innodb buffer pool check
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » Innodb buffer pool check
Name: Innodb buffer pool check Platform: Mariadb Category: Performance Description: Checks the hit rate of the innodb buffer pool Long description: This checks the hit rate of the innodb buffer…
Key buffer check (old)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » Key buffer check (old)
Name: Key buffer check Platform: Mariadb Category: Performance Description: Checks key buffer efficiency Long description: Task checks key buffer efficiency Version: 2.21 Default…
Database load
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » Database load
Name: Database load Platform: Mariadb Category: Performance Description: Provides information on the server load Long description: Task provides infomation on the server load in the database…
Database load (old)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » Database load (old)
Name: Database load Platform: Mariadb Category: Performance Description: Provides information on the server load Long description: Task provides infomation on the server load in the database…
Memory setup
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » Memory setup
Name: Memory setup Platform: Mariadb Category: Performance Description: Analyzes the memory setup of the server Long description: Task analyzes memory setup of the…
Memory setup (old)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » Memory setup (old)
Name: Memory setup Platform: Mariadb Category: Performance Description: Analyzes the memory setup of the server Long description: Task analyzes memory setup of the…
Network traffic (old)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » Network traffic (old)
Name: Network traffic Platform: Mariadb Category: Performance Description: Shows the network traffic Long description: Task shows amount of network traffic in the server Version: 2.2 Default…
Query cache hitrate
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » Query cache hitrate
Name: Query cache hitrate Platform: Mariadb Category: Performance Description: Shows the query cache hit rate Long description: Task shows the hit rate of query cache Version: 2.42 Default…
Query cache hitrate (old)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » Query cache hitrate (old)
Name: Query cache hitrate Platform: Mariadb Category: Performance Description: Shows the query cache hit rate Long description: Task shows the hit rate of query cache Version: 2.42 Default…
Thread cache hitrate
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » Thread cache hitrate
Name: Thread cache hitrate Platform: Mariadb Category: Performance Description: Shows the thread cache hit rate Long description: Task shows the hit rate of the thread…
Thread cache hitrate (old)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » Thread cache hitrate (old)
Name: Thread cache hitrate Platform: Mariadb Category: Performance Description: Shows the thread cache hit rate Long description: Task shows the hit rate of the thread…
Defining Autodiscover Ports
Using Control Center » Autodiscover » Discovering Database Instances » Defining Autodiscover Ports
By default autodiscover scans the following ports: MS SQL Server: 1433 Oracle: 1520, 1521, 1522, 1523, 1524, 1526, 1527 Sybase: 4998, 4999, 5000, 5001, 5002 MySQL: 3304, 3305, 3306, 3307, 3308 PostgreSQL: 5429, 5430, 5431, 5432, 5433, 5434 You can override the…
Replica count
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MySQL » Replica count
Name: Replica count Platform: Mysql Category: Cluster and Replication Description: This job checks all of replicas currently registered with the source. Long…
DBMS uptime
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » DBMS uptime
Name: DBMS uptime Platform: Mariadb Category: Availability Description: Collects uptime statistics in the database. Long description: Task collecs uptime data statistics in the database…
DBMS uptime (old)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » DBMS uptime (old)
Name: DBMS uptime Platform: Mariadb Category: Availability Description: Collects uptime statistics in the database. Long description: Task collecs uptime data statistics in the database…
Innodb buffer pool check (old)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » Innodb buffer pool check (old)
Name: Innodb buffer pool check Platform: Mariadb Category: Performance Description: Checks the hit rate of the innodb buffer pool Long description: This checks the hit rate of the innodb buffer…
Temporary table check
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » Temporary table check
Name: Temporary table check Platform: Mariadb Category: Performance Description: Shows percentage of temporary tables written to disk Long description: Task shows the percentage of temporary tables which have…
Temporary table check (old)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » Temporary table check (old)
Name: Temporary table check Platform: Mariadb Category: Performance Description: Shows percentage of temporary tables written to disk Long description: Task shows the percentage of temporary tables which have…
Backup of dbWatch
Troubleshooting Guide » Backup of dbWatch
When we think about backup of dbWatch, this involves several different parts of the software and installation: dbWatch Server and configuration files dbWatch Server places its configuration files and workarea in “C:\ProgramData\dbWatchControlCenter\” by…
FAQs
Additional Resources » FAQs
In this section – you will find the frequently asked questions regarding the dbWatch. Do you offer an evaluation copy of your product? - Yes, we do offer a 30-day trial for a maximum of 25 database instances of any database platforms supported. We can also…
Instance management
Using Control Center » Instance management
In instance management we focus on the process of adding, removing and managing instances and instance groups. You will need to add database instances to dbWatch Control Center in order to monitor, manage and create reports from your database instances. There are 4…
Adding a PostgreSQL Instance
Using Control Center » Instance management » Adding a PostgreSQL Instance
How to get here To open the “Add Instance Wizard”, click on the “Plus (+)” sign on the bottom left of the dbWatch Client. This will bring up the “Add Instance” wizard, which will guide you through the following steps. Select Instance Type and Input…
Innodb cluster status
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MySQL » Innodb cluster status
Name: Innodb cluster status Platform: Mysql Category: Cluster and Replication Description: This job checks state of all members in Innodb cluster Long description: Version: 1.2 Default…
Innodb cluster switch
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MySQL » Innodb cluster switch
Name: Innodb cluster switch Platform: Mysql Category: Cluster and Replication Description: This job checks if Innodb cluster PRIMARY/SECONDARY switch occurs. Long…
Database growth rate (aggregated)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MySQL » Database growth rate (aggregated)
Name: Database growth rate (aggregated) Platform: Mysql Category: Capacity Description: Collects database size and visualizes the growth rate of the server. Long description: Collects database size and…
NDB data memory usage check
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MySQL » NDB data memory usage check
Name: NDB data memory usage check Platform: Mysql Category: Cluster and Replication Description: NDB data memory usage check Long description: This checks the usage of data memory in NDB cluster…
NDB data node status
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MySQL » NDB data node status
Name: NDB data node status Platform: Mysql Category: Cluster and Replication Description: NDB data node status Long description: This checks the status of data nodes in NDB cluster…