The topic you requested could not be found.
Related topics are listed below.

Setting up a CCC node

Advanced Topics » Control Center Commandline » Setting up a CCC node

To setup a ccc node you first need to download the ccc scripts and extract them in a catalog that you want to be the ccc workarea. In the following example we have downloaded the scripts to “E:/tmp/scripts” and our Control Center installation is located in…

Web dashboard editor (beta)

Customization » Web server » Web dashboard editor (beta)

Web dashboard editor (currently in beta) Web dashboard editor is an additional addon module to dbWatch Control Center, that allows the customer to create their own dashboards displaying data about their database environment. While it is in beta, it is open for…

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…

Web configuration

Customization » Web server » Web configuration

To enable the Web server, go to the “Server” -> “Domain Configuration” menu. Expand the domain, Nodes, Server, and right-click on the server you want to run the webserver on. Select “Edit webserver” In the Configure…

Web server

Customization » Web server

Control Center can be configured to serve dynamic web content over http. This is intended for dashboards or live reports, and for data export used for integration purposes. Webserver configuration Webserver setup Configuring anonymous webaccess Mountable web…

Web data export

Customization » Web server » Web data export

You can export data from dbWatch through http for easy access by others (tools or humans). Data can be made available formatted as json or csv. Data export might require anonymous webaccess configured. Any data formatted as a table in the dashboard will support data…

Creating a user

Using Control Center » Domain Configuration » Managing users » Creating a user

To create a user, right click on the “Users” element in the tree in “Domain Configuration” This will open the add user dialog: Where you add a username and password: If you want to add a user that uses Active Directory for password…

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…

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…

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…

Dashboards

Customization » Web server » Dashboards

Dashboard overview The main page for the dashboards: User and login To view dashboards, you need to login with a user that has at least read privileges on web. Default dashboards These are the default dashboards: Instance status: This dashboard…

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…

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…

Start/stop webservice with CCC

Advanced Topics » Control Center Commandline » Start/stop webservice with CCC

*Not available in general release. You need the 22.03.2024 build or later. *Note: The term service in this context is an internal service in dbWatch, not a Windows service. Prerequisites First you need to go through the steps described in Setting up a CCC node You…

Customization

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…

Monitoring

Using Control Center » Monitoring

In this section, we’ll be familiarized with how the Monitoring Module works. When opening the monitoring module on its initial state, you get the status dashboard: The status dashboard is intended to provide a quick overview of the current state of your…

FDL with CCC

Advanced Topics » Control Center Commandline » FDL with CCC

Prerequisites Before running fdl through CCC you need to go through the steps described in Setting up a CCC node First we need to specify the fdl query to execute. This is done by editing the “fdl.script” file. The query is specified after the query?=…

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

Install jobs with CCC

Advanced Topics » Control Center Commandline » Install jobs with CCC

Prerequisites Before installing jobs through CCC you need to go through the steps described in Setting up a CCC node ← Set metadata with CCC / Get instance configuration with CCC →

Set metadata with CCC

Advanced Topics » Control Center Commandline » Set metadata with CCC

Prerequisites Before settings metadata through CCC you need to go through the steps described in Setting up a CCC node Metadata is defined in a file (default “metadata.properties”) ← Add instance with CCC / Install jobs with CCC…

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…

Get instance configuration with CCC

Advanced Topics » Control Center Commandline » Get instance configuration with CCC

Prerequisites Before you can get instance configuration through CCC you need to go through the steps described in Setting up a CCC node Getting instance configuration get_instance.script has the following input parameters: server – specify server IP and port,…

Register instance configuration with CCC

Advanced Topics » Control Center Commandline » Register instance configuration with CCC

Prerequisites Before you can get instance configuration through CCC you need to go through the steps described in Setting up a CCC node Registering instance configuration register_instance.script has the following input parameters: server – specify server IP…

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…

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…

Internal repository

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

The internal repository is a dashboard to see how the gathering process of SQL performance data is working, finetune and analyze load and statistics. ← SQL performance / Server activity →

Server activity

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

Server activity is a dashboard to get an overview of current sessions and statistics from multiple performance counters viewed together. There is also a menu to kill sessions or view last sql statements. ← Internal repository / Blocking sessions…

Add instance with CCC

Advanced Topics » Control Center Commandline » Add instance with CCC

Prerequisites Before adding instances through CCC you need to go through the steps described in Setting up a CCC node The properties for the instance to add are defined in a file (default is “instance.properties”). The syntax is key/value pairs seperated…

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…

Management

Using Control Center » Management

In this section, we’ll be familiarized with how the Management Module works. Examples in this documentation are from Microsoft SQL Server, but this is available on all platforms, however, contents are platform and license dependent. When opening the management…

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…

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…

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…

Managing security groups

Using Control Center » Domain Configuration » Managing security groups

Security groups This is were you define the groups that users and roles can have privileges on. There are some predefined security groups: Security group name Privilege All instances A list of instances containing all instances added to…

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…

Auditing

Advanced Topics » Auditing

DbWatch supports auditing of all statements that are executed on the database instances from dbWatch. There is currently no graphical way of turning this feature on, so it involves manually editing the server_configuration.xml file. Stop the dbWatch Server and take a…

External dependencies

Customization » Monitoring » Editor for engine jobs » External dependencies

External dependencies are used to add dependencies to external tables, views, functions, and procedures. External in this setting is external to, as not part of, this job. It can be external objects, such as tables and procedures that the procedures in this job…

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…

User integration with Active Directory

Using Control Center » Domain Configuration » Managing users » User integration with Active Directory

The user integration with Active Directory offloads the password verification and storage from the dbWatch Control Center domain controller to Active Directory. Port openings To allow the correct communications between the dbWatch Server and the Active Directory…

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…

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…

User connections check

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Sybase » User connections check

Name: User connections check Platform: Sybase Category: Performance Description: Checks the configuration setting of the ‘number of user connections’ from the master.dbo.syscurconfigs table against the number of…

User connections check (12)

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Sybase » User connections check (12)

Name: User connections check Platform: Sybase Category: Performance Description: Checks the configuration setting of the ‘number of user connections’ from the master.dbo.syscurconfigs table against the number of…

Internal fragmentation check

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Internal fragmentation check

Name: Internal fragmentation check Platform: Sqlserver Category: Maintenance Description: Checks the internal fragmentation for tables and indexes in all databases. The information is extracted from the dynamic management…

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…

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…

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…

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…

Metadata properties

Customization » Property System » Metadata properties

You can put metadata on instances, and this metadata will be automatically available in FDL. To add metadata to an instance, right click on it and select “Configure”. Then click on the “Metadata” tab. Here you can add key/value pairs by…

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…

[Instance name] (instance)

Using Control Center » Management » Management on SQL Server » Configuration » Uptime statistics » [Database name] (database server) » [Instance name] (instance)

This gives an overview of when the database instance has been up or down. ← [Database name] (database server) / Maintenance periods →

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…

Listener status check

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

Name: Listener status check Platform: Oracle Category: Availability Description: Checks listener status to verify if up and running, requires java support in the database. Long description: Task checks listener…

Graphical installation on Ubuntu

Before you start The installer for dbWatch Control Center requires root to run. However, when we want to run the software under a different user once installed. I will run all the first steps as user root for documentation simplicity. You can use sudo instead. This…

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

[Database name] (database server)

Using Control Center » Management » Management on SQL Server » Configuration » Uptime statistics » [Database name] (database server)

This gives an overview of up and down periods for the database server. You can right-click on the screen to switch between different ways to display uptime: Like uptime per week: ← Uptime statistics / (instance) →

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…

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…

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…

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…

Parameters

Using Control Center » Monitoring » Job concepts » Parameters

Most of the monitoring jobs will have parameters. This is used controllable thresholds to adjust the monitoring job behavior and to better align it with the database instance and the preferences of the DBA. This is an example from the “Agent jobs check”…

SYS.AUD size

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » SYS.AUD size

Name: SYS.AUD size Platform: Oracle Category: Capacity Description: Checking if SYS.AUD$ fills up with data Long description: Version: 1.1 Default schedule: 3h Requires engine…

Getting Started

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…

Importing resources

Customization » Importing resources

Much of the functionallity in dbWatch is defined in xml files, including report specifications, task specifictions and management specifications. That means that functionallity can be modified by supplying new xml files to dbWatch. There are two ways of doing…

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…

Transaction log space usage

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Transaction log space usage

Name: Transaction log space usage Platform: Sqlserver Category: Capacity Description: This procedure checks information returned by DBCC SQLPERF which is used to monitor the amount of space used in the transaction…

Transaction log space usage (MS2000 / MS2005 / MS2008)

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Transaction log space usage (MS2000 / MS2005 / MS2008)

Name: Transaction log space usage Platform: Sqlserver Category: Capacity Description: This procedure checks information returned by DBCC SQLPERF which is used to monitor the amount of space used in the transaction…

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…

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…

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…

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…

Database operations philosophy

Product Overview » Database operations philosophy

The reasons for database operations The value of database operations comes from the value of the systems the databases support. . In a typical operation, the value of the managed systems is much greater than the resources used on the operations side. Running a…

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

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…

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…

Reports

Customization » Reports

Before proceeding to this topic, you must be familiar with generating a report. You can check it out by click on the link. Customizing your Report by changing the logo and Company Name To customize, your report. First click “Server” on the upper ribbon of…

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…

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…

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…

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…

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…

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…

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…

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

Functions

Advanced Topics » FDL – Farm Data Language » Functions

Functions in FDL Numeric functions Function name Description add Adds a number to a base value sub Substracts a number from a base value div Diveds a number mult Multiplies a number …

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…

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…

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…

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…

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…

Product Overview

Product Overview

Product Overview In Product Overview, we will look into architecture and structure and give an overview of how the application operates. Chapters: Architecture File Structure Network and communications Database Operations Philosophy Monitor Dashboards and…

Job types

Using Control Center » Monitoring » Job concepts » Job types

There are currently two types of jobs, engine jobs, and no-engine jobs. The main difference between them is where processing occurs. Engine jobs do the processing in the database instance engine, and no-engine jobs do the processing on the Control Center Instance…

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 →

Jobs grouped by category

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by category

Jobs by category Jobs in Control Center are grouped by category to make it easier for users to locate the right monitoring job. The categories are: Availability Jobs that checks that the database and database related processes are functioning Capacity – Jobs…

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…

Troubleshooting Guide

Troubleshooting Guide

In this section, we’ll discuss about: dbWatch Backup Restoring Configuration Backup Fault Finding Guide Issues and Troubleshooting Definition Mapping ← Internal Control Center firewall / Backup of dbWatch →

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…