Search - 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…

Using OS Authentication

Using Control Center » Instance management » Adding a SQLServer Instance » Using OS Authentication

When connecting to Microsoft SQL Server instances it is possible to login with Windows Authentication (called OS Authentication in dbWatch). The accout used is the same account as the dbWatch Control Center service runs as. Per default the dbWatch Control Center…

Customize View using FDL

Customization » Monitoring » Customize View using FDL

Before proceeding to this section, you must be familiar with Farm Data Language. To give you an overview, Farm Data Language is a type of query dbWatch uses to read and display data to its user. Think of it as your query tool when using dbWatch. How to edit…

Installing and using premium packages

Premium 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.…

Using SQL Performance package on Oracle

Installing and using premium packages » SQL Performance package » Using SQL Performance package on Oracle

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…

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…

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…

Using SQL Performance package on SQL Server

Installing and using premium packages » SQL Performance package » Using SQL Performance package on SQL Server

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 SQL…

Instance details

Using Control Center » Monitoring » Instance details

When navigating to an individual database instance, you get the instance details overview: This dashboard is intended to give an overview of what monitoring jobs are installed and how they are performing. The top tabs let you switch between the instance details…

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…

Integration with SSMS

Installing and using premium packages » SQL Performance package » Using SQL Performance package on SQL Server » Integration with SSMS

When analyzing a SQL statement, the choice “Show query plan (using SSMS)” appears on SQL Server. This is for opening a query plan in SQL Server Management Studio. Clicking on this will not open anything, if it is not setup correctly. There is a monitor.xml…

Customization

dbWatch Control Center is designed to be customizable and much of the contents are developed inside the product In this section, we will go over how you can customize different parts of the product. To proceed, click on of the topics below: Customize dbWatch Views…

Listener log check (java 10g)

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Listener log check (java 10g)

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…

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…

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…

Instance action script with CCC

Advanced Topics » Control Center Commandline » Instance action script with CCC

Instance action script The instance action script (instance_action.script) can do the following commands: Connect You can connect an already registered and disconnected instance using the connect action. It is the same as what happens if you right-click on an…

Contained database credentials

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Contained database credentials

Name: Contained database credentials Platform: Sqlserver Category: Security Premium package: Security and compliance package Description: Checks if the database users in contained databases are using database…

Database backup (system databases)

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database backup (system databases)

Name: Database backup (system databases) Platform: Sqlserver Category: Availability Description: This procedure analyzes the FULL backup statistics for the system databases (master, model and msdb) using data from the…

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…

Adding a SQLServer Instance

Using Control Center » Instance management » Adding a SQLServer Instance

How to get here To open the “Add Instance Wizard”, click on the “Plus (+)” sign on the bottom left of the dbWatch Client. Select Instance Type and Input Connection Details Specify the host and port number. dbWatch will attempt to…

Autodiscover

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…

Installation of SQL Performance package

Installing and using premium packages » SQL Performance package » Installation of SQL Performance package

Requirements for installation dbWatch Control Center release 2022-09-29 / 501 or newer License that includes SQL Performance module. It can be as the separate “SQL Performance Package” license or as part of a larger licence package. It is included in…

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…

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…

SQL Worksheet

Using Control Center » Management » Management on SQL Server » SQL Worksheet

SQL Worksheet allows for direct SQL commands on the database instance. ← Audit / Worksheet →

Backup log check (old style 8i)

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Backup log check (old style 8i)

Name: Backup log Check 8i(‘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…

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…

SQL performance

Using Control Center » Management » Management on SQL Server » SQL performance

SQL performance is an extra cost module, that might not be available if your license has not enabled it. For more details look at the documentation for this module here ← Maintenance periods / Internal repository →

Listener log check (8i)

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Listener log check (8i)

Name: Listener log check Platform: Oracle Category: Availability Description: This checks and reads errors from the database listener log. Using Oracle native code to read. Long description: This checks and …

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…

dbWatch Server activity alert

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » dbWatch Server activity alert

Name: dbWatch Server activity alert Platform: Sqlserver Category: Internal Internal Description: This procedure gathers statistics per database. Long description: This alert returns warning/alarm if the dbWatch…

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…

Sessions performance

Using Control Center » Management » Management on SQL Server » Sessions performance

The Sessions performance view is part of the SQL performance package, which is an extra cost module, that might not be available if your license has not enabled it. For more details look at the documentation for this module here ← Sessions history / Disk…

Listener log check

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Listener log check

Name: Listener log check Platform: Oracle Category: Availability Description: This checks and reads errors from the database listener log. Using Oracle native code to read. Long description: This checks and …

Listener log check (10g)

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Listener log check (10g)

Name: Listener log check Platform: Oracle Category: Availability Description: This checks and reads errors from the database listener log. Using Oracle native code to read. Long description: This checks and …

Listener log check (9i)

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Listener log check (9i)

Name: Listener log check Platform: Oracle Category: Availability Description: This checks and reads errors from the database listener log. Using Oracle native code to read. Long description: This checks and …

Listener log check (11g)

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Listener log check (11g)

Name: Listener log check Platform: Oracle Category: Availability Description: This checks and reads errors from the database listener log. Using Oracle native code to read. Long description: This checks and …

Application Modules

Advanced Topics » Application Modules

About application modules The dbWatch framework is easy to extend and expand with tasks, alerts, reporting and administration to support specific applications. An application module is a bundle of tasks, alerts, reports and administration xml files to allow dbWatch to…

CPU load

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » CPU load

Name: CPU load Platform: Oracle Category: Performance Description: Checks CPU load using Oracle performance view v$osstat. Long description: Checks and collects CPU load statistics. The task also aggregates…

Instance error log

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Instance error log

Name: Instance error log Platform: Sqlserver Category: Availability Description: Reads and checks the Instance error log file by using the sp_readerrorlog stored procedure. Long description: The sp_readerrorlog…

Disk space check

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Disk space check

Name: Disk space check Platform: Sqlserver Category: Capacity Description: Checks the amount of free space on the available disk drives. Long description: Checks the amount of free space on the available disk…

Instance error log file size check

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Instance error log file size check

Name: Instance error log file size check Platform: Sqlserver Category: Capacity Description: Checks the size og the Instance error log file by using the extended stored procedure xp_cmdshell. Long…

Engine jobs

Using Control Center » Monitoring » Job concepts » Job types » Engine jobs

Engine jobs Each engine Job consists of a set of objects (procedures, tables, etc) that are installed on the monitored database instance. The main procedure will be triggered by the dbWatch Server, This procedure will then perform a check or collect statistics…

Instance error log (AWS)

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Instance error log (AWS)

Name: Instance error log (AWS) Platform: Sqlserver Category: Availability Description: Reads and checks the Instance error log file by using the AWS rdsadmin.dbo.rds_read_error_log stored procedure. Long…

Disk space check (noschema)

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Disk space check (noschema)

Name: Disk space check Platform: Sqlserver Category: Capacity Description: This procedure collects space usage in all filegroups defined in each database. The undocumented ‘sp_MSforeachdb’ Stored Procedure is…

Sensitive Data Transmitted

Advanced Topics » Product Security » Sensitive Data Transmitted

Sensitive Data Transmitted dbWatch Control Center will, by its nature log into database instances and run queries on the database instances it manages. Key data accessed is primarily data related to statistics on the behavior of the database instance, and not actual…

Network Controls

Advanced Topics » Product Security » Network Controls

Network Controls dbWatch Control Center deploys several methods of network control. 1. Node authentication (clients and servers) using certificate infrastructure built up around the Domain CA system 2. The built-in firewall to restrict incoming connections on an IP…

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…

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…

Reporting

Using Control Center » Reporting

Control Center comes bundled with a series of report templates that you can use to generate standard reports on various aspects of your database environment. It also allows you to edit the templates or create your own for fully customizable reporting which will be…

Encryption

Advanced Topics » Product Security » Encryption

Encryption Data packages sent between server nodes and monitor clients are end-to-end encrypted with the node certificate. The encryption used for this is AES/GCM (256bit keys). This is possible to verify if you click on Help->Debug->Connection info For…

groupby function

Advanced Topics » FDL – Farm Data Language » Functions » groupby function

Description Groups a set on some value(s). Used in combination with aggregate function(s). Example Group the instances by database type, and count the number of instances in each…

Auto-discover with different default port

Using Control Center » Autodiscover » 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…

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…

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,…

Node to Node communication

Advanced Topics » Product Security » Node to Node communication

dbWatch Control Center is composed of a set of nodes that speak to each other using a layered protocol. This document describes these layers and how they interact to achieve security and reliability. The dbWatch monitor is also a node and has all the behavior…

Jobs for Oracle

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle

Control Center Jobs Description Agresso (part of the Agresso Application Package) Agresso reports queue Monitors and checks pending or running reports. Returns warning or alarm if the elapsed time exceeds defined…

Edit Report Templates

Using Control Center » Reporting » Edit Report Templates

Report Selection When you click on Server -> “Reporting” on the toolbar and then select “Edit Report Template”, you will see a list of all available report templates. Select the report template you wish to edit and click “OK”.…

Getting Started

Downloading the latest version of Control Center You can get a download link to the latest version of dbWatch Control Center by registering for a free evaluation copy Wait for dbWatch’s Confirmation Email. Follow the steps and link in that email. There are…

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…

Adding SQLServer instances with kerberos

Using Control Center » Instance management » Adding a SQLServer Instance » Adding SQLServer instances with kerberos

Using the kerberos authentication option requires some additional setup. We need dbwatch user added to the domain: First we create a dbwatch user that is a normal domain user. We set a passord, and make sure it dont expire. And we must add this user to the…

Renamed sa account

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Renamed sa account

Name: Renamed sa account Platform: Sqlserver Category: Security Premium package: Security and compliance package Description: Checks if the standard ‘sa’ login account (principal_id=1 and…

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…

Autogrow settings

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Autogrow settings

Name: Autogrow settings Platform: Sqlserver Category: Maintenance Description: Checks database files auto-growth settings. Long description: The default auto-grow settings associated with the model database are…

Defining Autodiscover Ports

Using Control Center » Autodiscover » 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…

The modules of Control Center

Using Control Center » The modules of Control Center

We have seven default modules available when you start dbWatch Control Center. This article will only introduce you to what these instances are and give a brief description of them. You need to be familiar with the navigation tree to better understand how these modules…

Restore configuration backup

Troubleshooting Guide » Restore configuration backup

The configuration files in dbWatch are continously backed up using git. Reverting to an old backup Step one If you don’t have git tools installed, you can download them here Step two After stopping the dbWatch Server, use a command prompt (that understands…

Management on SQL Server

Using Control Center » Management » Management on SQL Server

When opening the management module in its initial state, you get the status dashboard: This will give an overview of the system, displaying some instance information, the largest databases, logical reads, session load, and memory usage. When a graph indicates…

Agent error log

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Agent error log

Name: Agent error log Platform: Sqlserver Category: Availability Description: Reads and checks the Agent error log file by using the sp_readerrorlog stored procedure. Long description: The sp_readerrorlog stored…

Generate Reports

Using Control Center » Reporting » Generate Reports

When you click on Report Module, the report wizard will be started. In the first step you will be asked to select the database instance you wish to generate a report for. The instance that does not have a user/login set for generating the report content, will be shown…

Job templates

Customization » Monitoring » Job templates

Creating templates Template functionality makes it possible to automate installation and configuration of jobs across the entire database farm you are managing. The configuration interface is available in the menu Server -> Server Configuration -> Edit job…

Properties on Instances

Advanced Topics » FDL – Farm Data Language » Available properties » Properties on Instances

Instances are available under server through the instance property server/instance All instances have the following properties: Name Description Return type Typical values Extra name The given name of the instance String…

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…

Product Security

Advanced Topics » Product Security

Introduction on dbWatch Control Center regarding product security dbWatch AS has implemented reasonable administrative, technical and physical safeguards to help protect against security incidents and privacy breaches involving a dbWatch product, provided those…

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…

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…

Item active

Customization » Management » Item active

You can hide or disable elements (typically nodes or menu items) by using the item-active tag You can specify multiple item-active tags, and all of them have to resolve to “active” in order for the element to be classified as active. The item-active tag…

Example architecture designs

Product Overview » Architecture » Example architecture designs

Basic setup The most basic setup is where a dbWatch Server service is configured with all functions in the same node, and the client is either local or installed on a separate computer. Example drawing: The pictured architecture is similar to the design and setup…

Installing on Linux

Getting Started » Installing on Linux

dbWatch Server Prerequisites Installation of dbWatch on Linux requires X11 for the graphical installation. Installation executable will fallback to console installation if X11 is not available, otherwise console installation is available with -c switch after…

Table fragmentation

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Table fragmentation

Name: Table fragmentation Platform: Oracle Category: Maintenance Premium package: Maintenance package Description: Checks the Table fragmentation in all database schemas. Long description: Checks…

Table fragmentation (10g)

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Table fragmentation (10g)

Name: Table fragmentation Platform: Oracle Category: Maintenance Premium package: Maintenance package Description: Checks the Table fragmentation in all database schemas. Long description: Checks…

The property file format

Customization » Property System » The property file format

Any queriable node in the dbwatch server can have properties. These can be statically set values or dynamically created. This document describes the format used to define dynamic properties. The file header Oracle…

Fresh Installation of dbWatch Control Center

Troubleshooting Guide » Fresh Installation of dbWatch Control Center

After installing a newer version of dbWatch Control Center, you may encounter problems such as an expired license or a locked account due to forgetting the admin credentials. Here’s a simple guide on doing a fresh installation of dbWatch Control Center.…

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…

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 Agresso (part of Agresso Application Package) Agresso report queue Monitors and checks pending or running reports. Returns warning or alarm if the elapsed time exceeds defined…

Tree navigation

Using Control Center » Monitoring » Tree navigation

On the left side of the dbWatch monitor, you will see a tree structure. There are 2 component that lets your group and filter instances. Top level of the tree, there is a “Grouping” panel. Below it is a quick text based filter. Grouping This is always…

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…

Definition Mapping

Troubleshooting Guide » Definition Mapping

dbWatch 12 dbWatch Control Center Definition Changes Tasks and Alerts Jobs Tasks provide statistics and growth rates for your database, which allows for better planning and performance analysis of how your system is behaving.…

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…

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…

Worksheet

Using Control Center » Worksheet

One of the truly unique features of dbWatch is its integrated SQL Worksheet, which, although easy to use has sophisticated applications, including cross-database queries. The SQL Worksheet is meant to give responsible DBA’s the ability to locate any problems and…

FDL – Farm Data Language

Advanced Topics » FDL – Farm Data Language

Introduction to Farm Data Language Farm Data Language or FDL for short is the query language used in dbWatch to find information about objects. FDL is formerly known as DBWQL. This topic should be considered as the advanced part of dbWatch. It is also the central…

Main procedure SQL Server

Customization » Monitoring » Editor for engine jobs » Implementation » Main procedure SQL Server

We will use the “Test alert” as example code, as its only purpose is to generate alarms and warnings, but uses many underlying functions. We go through it in steps, and include the full routine at the end. For historical reasons some code will refer to…

Installing on Windows

Getting Started » Installing on Windows

dbWatch Server Prerequisites Windows Server (VMWare virtual server or AWS EC2 supported) Windows Server 2008, 2012, 2016, 2019, and 2022 Windows 10 or Windows 11 8 GB RAM 4 CPU cores 10 GB hard drive space dbWatch Engine Prerequisites 500 Mb free space in…

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. To configure the extension, select it and click “Configure”. You should now see the initial configuration screen…

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$…

Release notes

About dbWatch Control Center » Release notes

dbWatch Control Center (2024-11-26) Download New features DBW – Bulk setting of SQL Worksheet authentications DBW – SQL Worksheet query timeout parameter DBW – AD integration now handles LDAP Signing DBW – CCC can now connect to non DC…

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…