Search
Related topics are listed below.
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…
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 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…
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…
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…
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.…
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…
Disk block hitrate
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for PostgreSQL » Disk block hitrate
Name: Disk block hitrate Platform: Postgres Category: Performance Description: Checks the hitrate for disk block requests. Long description: Task checks the hitrate for disk block…
Backup job – pg_dump_all (ssh)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for PostgreSQL » Backup job – pg_dump_all (ssh)
Name: Backup job – pg_dump_all (ssh) Platform: Postgres Category: Maintenance Description: Runs a backup of all the postgres databases on an instance using pg_dumpall through an ssh connection. Long…
Index block hitrate
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for PostgreSQL » Index block hitrate
Name: Index block hitrate Platform: Postgres Category: Performance Description: Checks the hitrate for index disk block requests. Long description: Task checks the hitrate for index disk block…
Framework
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for PostgreSQL » Framework
Name: Framework Platform: Postgres Category: Maintenance Description: dbWatch engine framework job (for internal use only). Used for patching or upgrading of dbWatch engine framework. Long description: dbWatch…
Replication delay alert
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for PostgreSQL » Replication delay alert
Name: Replication delay alert Platform: Postgres Category: Cluster Description: Checks for BDR replication lag Long description: Version: 1.01 Default schedule: 15m Requires…
Replication slave client alert
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for PostgreSQL » Replication slave client alert
Name: Replication slave client alert Platform: Postgres Category: Cluster Description: Checks for BDR replication lag Long description: Version: 1 Default schedule: 15m Requires…
Analyze tables
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for PostgreSQL » Analyze tables
Name: Analyze tables Platform: Postgres Category: Maintenance Description: dbWatch engine framework job (for internal use only). Used for patching or upgrading of dbWatch engine framework. Long description: This…
Buffer cache reads per database
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for PostgreSQL » Buffer cache reads per database
Name: Buffer cache reads per database Platform: Postgres Category: Performance Description: Collects the number of block fetch requests for table or index per database. Long description: Collects the number of…
Disk block reads per database
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for PostgreSQL » Disk block reads per database
Name: Disk block reads per database Platform: Postgres Category: Performance Description: Collects the number of disk block fetch requests for table or index per database. Long description: Collects the number…
Schema growth collector
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for PostgreSQL » Schema growth collector
Name: Schema growth collector Platform: Postgres Category: Capacity Description: Checks the size of the log file. Long description: This job collects growth rate statistics for all schemas i all…
BDR Replication lag
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for PostgreSQL » BDR Replication lag
Name: BDR Replication lag Platform: Postgres Category: Cluster Description: Checks for BDR replication lag Long description: Task analyses BDR replication lag Version: 0.3 Default…
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…
SQL statistics
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for PostgreSQL » SQL statistics
Name: SQL statistics Platform: Postgres Category: Performance Description: Collects performance statistics for the SQL statements. Long description: Collects performance statistics for SQL statements from…
SQL statistics
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for PostgreSQL » SQL statistics
Name: SQL statistics Platform: Postgres Category: Performance Description: Collects performance statistics for the SQL statements. Long description: Collects performance statistics for SQL statements from…
Auto-discover with different default port
Using Control Center » Autodiscover » Discovering Database Instances » Auto-discover with different default port
We’ll look deeper into how auto-discover works. First of all, you need to be familiar with what file the data is being stored in. The default directory can be found in “C:\ProgramData\dbWatchControlCenter\config\server” and it’s in file…
Vacuum alert
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for PostgreSQL » Vacuum alert
Name: Vacuum alert Platform: Postgres Category: Capacity Description: Checks the size of the log file. Long description: This job hecks if vacuum has been performed…
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…
Session load
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for PostgreSQL » Session load
Name: Session load Platform: Postgres Category: Performance Description: Gathers session load statistics. Long description: Task gathers session load statistics. Version: 1.7 Default…
DBMS uptime
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for PostgreSQL » DBMS uptime
Name: DBMS uptime Platform: Postgres Category: Availability Description: Collects database uptime statistics. Long description: Collects database uptime statistics. Version: 1.4 Default…
Log size statistics
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for PostgreSQL » Log size statistics
Name: Log size statistics Platform: Postgres Category: Capacity Description: Checks the size of the log file. Long description: Checks the size of the log file. Version: 1.2 Default…
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…
Backup check – pg_dump
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for PostgreSQL » Backup check – pg_dump
Name: Backup check – pg_dump Platform: Postgres Category: Availability Description: Checks that there exists an up to date backup file. Long description: Checks that there exists an up to date backup…
Buffer cache statistics
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for PostgreSQL » Buffer cache statistics
Name: Buffer cache statistics Platform: Postgres Category: Performance Description: Gets data cache statistics from pg_stat_database view. Long description: Task gets data cache statistic from pg_stat_database…
Transaction statistics
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for PostgreSQL » Transaction statistics
Name: Transaction statistics Platform: Postgres Category: Performance Description: Gathers information on commits and rollbacks in the databases and generates statistics. Long description: Task gathers…
Schema growth statistics
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for PostgreSQL » Schema growth statistics
Name: Schema growth statistics Platform: Postgres Category: Capacity Description: Collects and analyzes schema growth statistics from data collected by Schema growth collector job Long description: Collects and…
Backup check – WAL
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for PostgreSQL » Backup check – WAL
Name: Backup check – WAL Platform: Postgres Category: Availability Description: Checks that the WAL files have been backed up. Long description: Checks that the WAL files have been backed…
Vacuum tables
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for PostgreSQL » Vacuum tables
Name: Vaccum tables Platform: Postgres Category: Maintenance Description: This job runs VACUUM statement on every database and reclaims storage occupied by dead tuples. It’s necessary to do VACUUM periodically,…
Test DML performance
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for PostgreSQL » Test DML performance
Name: Test DML performance Platform: Postgres Category: Performance Description: Runs performance test. Procedure executes SELECT, INSERT, UPDATE, DELETE and TRUNCATE statements on schema test tables. Long…
Maintenance
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by category » Maintenance
Jobs in the Maintenance category Control Center Jobs Description Oracle Framework Engine framework is used when upgrading earlier versions of dbWatch. Ensures the dbWatch Engine and dbWatch Server run compatible…
dbWatch engine alert
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for PostgreSQL » dbWatch engine alert
Name: dbWatch engine alert Platform: Postgres Category: Internal Description: Collects database uptime statistics. Long description: Version: 1 Default schedule: 15m Requires…
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…
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…
Using SQL Performance package on PostgreSQL
Installing and using premium packages » SQL Performance package » Using SQL Performance package on PostgreSQL
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…
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$…
Exporting configuration from 12 to CC
Advanced Topics » Exporting configuration from 12 to CC
Exporting database instance configuration from dbWatch 12 to CC A version of 12.9.1 or above is needed for this. The idea is that you can export the instance configuration from a dbWatch 12.9.x installation to install the same instances in dbWatch Control Center, as…
Discovering Database Instances
Using Control Center » Autodiscover » Discovering Database Instances
The dbWatch Autodiscover feature scans your network and locates database instances that are available. You will find the Autodiscover feature under the “Autodiscover” tab on the left-most side of the dbWatch Monitor. In the Autodiscover view, you have 3…
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…
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…
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…
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…
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…
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…
Adding an Oracle Instance
Using Control Center » Instance management » Adding an Oracle Instance
Oracle Prerequisites !1. Oracle databases need to have a listener process running and also allow for an external login with sysdba user or user with enough privileges. 2. You need a privileged user, such as sys as sysdba, another user with sysdba privileges or…
Properties on dbWatch Servers
Advanced Topics » FDL – Farm Data Language » Available properties » Properties on dbWatch Servers
The available properties for server are: Name Description Return type Typical values Extra name, displayname The name of the dbWatch Server Entity dbWatch Control Center instance All the instances…
Bulk installing instances
Using Control Center » Instance management » Bulk installing instances
CSV File Format You can add instances in bulk. The prerequisite is to have a CSV file with 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 →
Architecture
Product Overview » Architecture
Architecture components The dbWatch installation consists of three components: dbWatch Monitor/Client serves as the front-end GUI dbWatch Server is the core business logic and central hub of the system dbWatch Framework contains stored objects in the registered…
Property System
Customization » Property System
There are several types of properties in dbWatch. Predefined properties Predefined properties are always present. For example, instances have properties called name and host. For more details see available properties Metadata properties Metadata properties are…
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…
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…
File Structure
Product Overview » File Structure
Files stored in the users home directory The dbWatch Monitor stores files in the “.dbwatch/.monitor/” catalog in the users home directory. This directory contains the following directories: config Config files crypto Cryptographic keys data Currently…
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…
Alert log check (java)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Alert log check (java)
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…
Monitoring
Customization » Monitoring
Custom monitoring and editing monitoring jobs dbWatch has two types of monitoring jobs that can detect issues in the database instances. They are referred to as Engine jobs and “No-engine jobs”. Engine jobs are jobs that run inside the database engine,…
Disk read statistics
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Disk read statistics
Name: Disk read statistics Platform: Oracle Category: Performance Description: Collects disk read statistics from v$system_event performance view for db file sequential and dbfile scattered read event. Long…
Object size collector (all databases)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Object size collector (all databases)
Name: Objects size collector (all databases) Platform: Sqlserver Category: Capacity Description: Collects table and index size information for the largest objects for all databases. Long description: Collects…
Control Center Commandline
Advanced Topics » Control Center Commandline
CCC.exe – the Control Center Commandline CCC.exe is a command intended to run on the commandline or terminal to trigger USL scripts. The intention of CCC is to use it for integration and automation purposes to access the capabilities of dbWatch for other 3rd…
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…
Listener log check (java)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Listener log check (java)
Name: Listener log check (java) Platform: Oracle Category: Availability Description: This checks and reads errors in database listener log. Using embedded java to read. Long description: Task checks and reads…
Licensing terms
Licensing terms
dbWatch End User License Agreement 1. PARTIES This License and Services Agreement (“Agreement”) is between dbWatch AS, organization number 991 500 456 Norway (“dbWatch”), and the Customer, which is the entity or person whose name and contact details as it…
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…
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…
Job details
Using Control Center » Monitoring » Job details
When you click on one of the jobs in the job tree, you can see a more detailed job overview. The idea of this overview is to show current and historical state, configured parameters and how the job is behaving on other database instances. In the top left…
Domain Configuration
Using Control Center » Domain Configuration
How to get here The Domain Configuration can be accessed by going to Server > Domain Configuration. Overview The Domain Configuration dialog lets you configure domain-wide settings. The concepts listed for each domain on the left side tree are: Nodes –…
Test alert
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Test alert
Name: Test alert Platform: Oracle Category: Availability Description: Test alert that alerts every ‘X’ minutes. Long description: Test alert that alerts every ‘X’ minutes. Usefull for…
No-engine jobs
Customization » Monitoring » No-engine jobs
No-engine jobs No-engine jobs are monitoring jobs that does not run in the database engine. No-engine jobs are jobs that run on the dbWatch Server, and typically run a SQL statement and process the result of this statement in javascript. Example code for different…
Instance Configuration
Using Control Center » Instance management » Instance Configuration
How to get here Instance Configuration can be accessed by going to Server > Server Configuration > Instance Configuration, or by right clicking on an instance and selecting Configure Instance from the popup menu. Main view The instance configuration view consists…
Using Control Center
Using Control Center
In this section, we will cover the user interface, the different modules, and how they are used. When we start dbWatch Control Center we will by default start-up in the monitoring view: We have the top menu, where we find the configuration of client connections…
Javascript property
Customization » Property System » Javascript property
From dbWatch 12.2.1, one of the engines available in properties is javascript. Example that sums each column from an sql result: scripttest instance[databasetype='sqlserver'] select 1, 2, 3 5s In the javascript code there are two…
Status
Using Control Center » Monitoring » Job concepts » Status
Jobs can have four different statuses. Additionally, the instance can have the “Lost connection” state, blue, that takes precedence over job statuses. Green for OK, Yellow for Warning, and Red for Alarm. Tasks can be without status, and the no-status icon…
Dynamic properties
Customization » Property System » Dynamic properties
Dynamic properties are defined in xml files located in the [dbWatch Server]/server/resources/properties/ catalog. You cannot add files to this catalogue manually, but import them by placing them in the [dbWatch Server]/server/resources/import_area catalog. Examples…
Report
Using Control Center » Monitoring » Job concepts » Report
Each job has a job report that is generated when you use the job menu and choose “Details”. The job report, here an example from the CPU load details on Oracle, provides a set of graphs, pie charts, and tables. It uses previously generated history…
Export log Check (‘old style’ backups)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Export log Check (‘old style’ backups)
Name: Export log Check (‘old style’ backups) Platform: Oracle Category: Availability Description: Checks for errors in a log file (i.e. export log). Long description: Task checks for errors in the…
Backup log check (old style 10g)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Backup log check (old style 10g)
Name: Backup log Check 10g (‘old style’ backups) Platform: Oracle Category: Availability Description: Checks for errors in a log file (e.i. backup log). For backups not using RMAN. Long description: …
Backup log check (old style 9i)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Backup log check (old style 9i)
Name: Backup log Check 9i (‘old style’ backups) Platform: Oracle Category: Availability Description: Checks for errors in a log file (e.i. backup log). For backups not using RMAN. Long…
Anonymous webaccess
Customization » Web server » Anonymous webaccess
Configuring Anonymous Web Access in dbWatch This guide outlines the updated process for configuring anonymous web access in dbWatch. The configuration is now managed through the ‘tuning.properties’ file, which simplifies the setup process. Step 1: Create…
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…
Internal Control Center firewall
Advanced Topics » Internal Control Center firewall
The internal firewall Mostly used for advanced configurations, where nodes are placed in locations facing internet traffic, there is a built-in firewall in Control Center. You access the firewall configuration in the domain configuration dialog for each node.…
Alert log check
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Alert log check
Name: Alert log check Platform: Oracle Category: Availability Description: This check reads and looks for errors in the database alert log. Long description: This check reads and looks for errors in the database…
The FString format
Advanced Topics » The FString format
The FString format. FString is a format created to extract data from complex data structures in order to create well-formed files or strings. The basic FString - Any string is considered an FString. - Any parts of the string starting with ‘{$’ and…
SQL statistics (CDB)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » SQL statistics (CDB)
Name: SQL statistics Platform: Oracle Category: Performance Extra cost package: SQL Performance package Description: Collects SQL statements statistics (for container database) from V$SQLAREA and V$SQL_PLAN…
SQL statistics (PDB)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » SQL statistics (PDB)
Name: SQL statistics Platform: Oracle Category: Performance Extra cost package: SQL Performance package Description: Collects SQL statements statistics (for pluggable database) from V$SQLAREA and V$SQL_PLAN…
Data Guard Archive Status Check (10g & 9i)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Data Guard Archive Status Check (10g & 9i)
Name: Data Guard Archive Status Check Platform: Oracle Category: Availability Description: Checks that the standby database is receiving archive files from master database. Long description: Task checks that the…
Cloud router security
Product Overview » Architecture » Cloud router » Cloud router security
Introduction Robust Security Despite Exposure to Threats: Designed for internet accessibility, the cloud router operates under the assumption that it could be compromised. This perspective has shaped its security architecture to ensure that users remain protected,…