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

Item active

Advance Topics » 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…

Adding SQLServer instances with kerberos

dbWatch Monitor Setup » 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…

Getting Started with dbWatch Control Center

Getting Started with dbWatch Control Center

Downloading the Latest Version of dbWatch Control Center The latest version of dbWatch is available in dbWatch’s Get Started Page. Scroll down until you reach the email consent form. Fill up the form with your email and check all necessary boxes. Wait for…

Auto-discover with different default port

dbWatch Monitor Setup » 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…

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…

Startup configuration

Configuration » Startup configuration

There are two files that supply the startup configuration for dbWatch, both can be found in the root of the dbWatch installation catalog. monitor.conf Startup configuration for the dbWatch Monitor server.conf Startup configuration for the dbWatch…

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…

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…

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

Customizing Report

Advance Topics » Customizing Control Center » Customizing Report

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…

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…

Setting up the default web dashboard

Product Overview » Dashboards and Overview Screens » Setting up the default web dashboard

The web dashboard is the standard monitoring dashboard. Firstly, you will be directed to the first tab which is Instance Status. The Instance Status tab shows an overview of statistics and issues during monitoring. Instances status displayed as visual…

Resetting dbWatch Control Center Admin Account

Troubleshooting Guide » Resetting dbWatch Control Center Admin Account

Before resetting your admin account, you must be familiar with your working directory. By default, dbWatch Control Center will create a directory in C:\ProgramData\dbWatchControlCenter .If you are not sure, you can open the dbWatch Logo or go to Help > About dbWatch.…

Stacked area chart

Advance Topics » Edit Management » Result types » Graphical » Stacked area chart

Here is an example of a stacked area chart showing the relationship between active and inactive sessions over time. The specification for this chart: select number_of_processes_active as "Active", number_of_processes_total - number_of_processes_active as…

Job templates

dbWatch Control Center Navigation » Edit Jobs » Job templates

Template functionality make it possible to automate installation and configuration of jobs across the entire database farm you are managing. There are 4 templates available in dbWatch Control Center: Default (all platforms) Test (MS SQL Server) Test…

Dynamic properties

Advance Topics » 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…

Running several Monitors in parallel

Advance Topics » Running several Monitors in parallel

In order to run more than one dbWatch Monitor on a machine you have to tell them to use seperate paths for their files. Before making any changes to the files, make sure the the dbWatch Monitor is stopped. The dbWatch Monitor reads a file called monitor.conf on…

Describing the different dbWatch Control Center modules

dbWatch Control Center Navigation » dbWatch Modules » Describing the different dbWatch Control Center modules

We have 7 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 have a better idea of how these modules…

Running several Servers in parallel

Advance Topics » Running several Servers in parallel

In order to run more than one dbWatch Server on a machine there are two things you need to do. Make them listen to different ports, and use seperate paths for their files. Before making any changes to the files, make sure the the dbWatch Server is stopped. Change…

FDL – Farm Data Language

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

Installing on Windows

Getting Started with dbWatch Control Center » Installing on Windows

dbWatch Server Prerequisites Windows Server (VMWare virtual server supported) 8 GB RAM 4 CPU cores 1 GB HD Space (for dbWatch) dbWatch Engine Prerequisites 100 Mb free space in each database instance. Engine – Server communication determined by each…

Updating dbWatch Control Center license

Troubleshooting Guide » Updating dbWatch Control Center license

If your problem is regarding an expired license of dbWatch Control Center and you have the latest license file, you can directly upload it to dbWatch Control Center. To do this, you need to do the following: (1) Check the license file of dbWatch Control Center …

Edit Jobs

dbWatch Control Center Navigation » Edit Jobs

How to get 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 To create a new Task or Alert from scratch, go to the Manage tasks and alerts…

Javascript property

Advance Topics » 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…

For SQLServer

dbWatch Control Center Navigation » Control Center Jobs » For SQLServer

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. Check database recovery mode Checks if all…

Release notes

About dbWatch Control Center » Release notes

dbWatch Control Center (2022-09-29) Download New features MS SQL Server – new performance tuning module (this functionality is licensed) MS SQL Server – new job “Query Store status”. Checks Query Store space usage. MS SQL Server –…

For Oracle

dbWatch Control Center Navigation » Control Center Jobs » For Oracle

Control Center Jobs Description Availability database link check Checks database links. Database uptime Collects database uptime statistics for all instances mounted on the database. DBMS uptime Collects uptime…

replace function

Advance Topics » FDL – Farm Data Language » Functions » replace function

Description Replaces all occurences of string A with string B in a string. Example Replace all occurences of “abc” with “def” in instance names. instance/name/replace("abc", "def") Syntax expression1/replace(expression2,…

The FString format

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

Adding an Oracle Instance

dbWatch Monitor Setup » 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…

Disabling and Enabling Views

dbWatch Control Center Navigation » dbWatch Modules » 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. …

orderby function

Advance Topics » FDL – Farm Data Language » Functions » orderby function

Description Orders the rows in a set, with an optional limit on the number of rows to return Example Find the 10 instances with the highest number of sessions instance->i{}/total_session_count/orderby('desc', 10) Order the instances based on…

Multiserver web dashboards

Product Overview » Dashboards and Overview Screens » Multiserver web dashboards

If you have multiple dbWatch Servers, it is possible to create a dashboard that merges the data from different dbWatch Servers in one view. This can be usefull for large scale dbWatch implementations, Service Providers or customers with database servers in different…

groupby function

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

Using OS Authentication

dbWatch Monitor Setup » 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…

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…

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: This setup is similar to the design and setup of a…

Control Center Jobs

dbWatch Control Center Navigation » 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…

Generate Reports

dbWatch monitoring and Reporting » 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…

Dashboards and Overview Screens

Product Overview » Dashboards and Overview Screens

In this section, we will be focusing on how to set-up your dashboard and setting it up with multiple servers. ← Monitor dashboards and overview screens / Setting up the default web dashboard →

count function

Advance Topics » FDL – Farm Data Language » Functions » count function

Description Counts the number of rows in a set Example Find the number of instances with status warning. count(instance[status='WARNING']) Syntax count(expression) Parameters Type Description Expression An expression that…

Monitoring

dbWatch monitoring and Reporting » Monitoring

In this section, we’ll be familiarized with how the Monitoring Module works. When opening the monitoring module on its initial state, you will see two tabs: Monitoring Module "Instance Status Tab" Monitoring Module "Instance Tab" ← dbWatch monitoring…

Adding a SQLServer Instance

dbWatch Monitor Setup » 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…

round function

Advance Topics » FDL – Farm Data Language » Functions » round function

The round function rounds a number to a specified precision Description Rounds a number Example Find tasks from the ‘sla_higs_tasks’ list that are installed on instances tagged with sla=low instance/disk_space/round(2) round(instance/disk_space,…

Adding Postgres Instance

dbWatch Monitor Setup » Adding Postgres 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…

dbWatch Modules

dbWatch Control Center Navigation » dbWatch Modules

In dbWatch Control Center, you are presented with different modules to aid in your monitor and management effort. We’ll look into each module individually. You can see all the modules in the navigation pane at the left-most side of dbWatch Control Center UI. …

intersect function

Advance Topics » FDL – Farm Data Language » Functions » intersect function

The intersect function finds the values that are in both set A and set B Description Finds the intersection of two sets Example Find tasks from the ‘sla_higs_tasks’ list that are installed on instances tagged with sla=low intersect( …

Getting Started: Downloadable Resources

Getting Started with dbWatch Control Center » Getting Started: Downloadable Resources

Before getting started in installing your dbWatch Control Center, you will need to know the prerequisites for both software and hardware.We have prepared download resources so you can do your installation offline: dbWatch Control Center Checklist For a more…

Adding a MySQL Instance

dbWatch Monitor Setup » 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…

Reporting

dbWatch monitoring and Reporting » 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…

Additional Guide for Instance Installation

dbWatch Monitor Setup » Additional Guide for Instance Installation

Brief Introduction This guide specifically talks about different windows in the installation process. It will discuss in detail the functions of each window in the installation process. Define Connection Details In this window, you will specify the Host IP and…

Discovering Database Instances

dbWatch Monitor Setup » 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…

Bulk installing instances

dbWatch Monitor Setup » Bulk installing instances

CSV File Format You can add instances in bulk. The prerequisite is to have a CSV file with the following…

dbWatch Monitor Setup

dbWatch Monitor Setup

This section contains information regarding the setup and usage of the dbWatch monitor. To access the “Add instance” wizard, click on the “+” sign on the lower left corner of the actionbar. Below are the sub-topics for adding a specific…

Result types

Advance Topics » Edit Management » Result types

You can specift the result type with a “result-type” tag inside the result. select ... table The currently available result types are table / dbwqltable Will display the result as a table. This is the default type. code Will display the…

About dbWatch Control Center

About dbWatch Control Center

dbWatch Control Center is a highly scalable software solution helping enterprises monitor and manage large numbers of database servers efficiently, providing total control over all aspects of operation, performance and resource usage. dbWatch Control Center will give…

Tree navigation

dbWatch Control Center Navigation » 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…

Database Farm Management Additional Resources

Additional Resources » Database Farm Management Additional Resources

Blogs For farm management, we have different blogs discussing this topic: From SQL Instance Management to Database Farm Management dbWatch Control Center for managing Database Farms Does managing database server farms differ from database instances? Tips: How you…

Issues and troubleshooting

Troubleshooting Guide » Issues and troubleshooting

High CPU usage on database Occasionally when investigating resource-consuming SQL statements running on your system, you may find that some of them belong to the dbWatch application. For example, a SQL statement that has the highest value of spent CPU time. In most…

Changing Instance Group

dbWatch Monitor Setup » Groups Configuration » Changing Instance Group

Changing a group can be done when you created an instance under a default group name and change it to another corresponding group. To change the groups base on your newly created group, you can check Group Configuration. Changing Group of an Instance Once a group has…

Customize View using FDL

Advance Topics » Customizing Control Center » 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…

Notes

dbWatch Control Center Navigation » Notes

dbWatch allows you to attach notes to tasks, instances and servers. You can access the notes dialog by right clicking on a instance/job/server, and selecting “Notes” on the menu. The notes view has two main sections. The top is for a free text…

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

Functions

Advance Topics » FDL – Farm Data Language » Functions

Functions in dbwql 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…

Versions Summary

About dbWatch Control Center » Versions Summary

Other Existing Documentations If you are looking for dbWatch’s online documentation for Enterprise Manager, you can proceed with the following link: dbWatch Enterprise Manager Version 12.8 dbWatch Enterprise Manager Version 12.7 dbWatch Enterprise Manager…

Defining Autodiscover Ports

dbWatch Monitor Setup » 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 Configuration

dbWatch Monitor Setup » Instance Configuration

How to get here Instance Configuration can be accessed by going to Server > Server Configuration > Instance Configuration. Main view The instance configuration view consists of several parts. On the left side you see a tree are the list of your instances…

Network and communications

Product Overview » Network and communications

Network and communications Default ports and protocol dbWatch Control Center uses by default port 7100/tcp for client to node and node to node connections. This can be configured to a different port. On each node there is a node.connections file that both lists what…

Fault Finding Guide

Troubleshooting Guide » Fault Finding Guide

Errors before starting the installer The first step is to download the software. Once downloaded, errors may occur when the installer unpacks. The install executable or zip file might have been damaged during download, and if this is indicated, try first downloading…

For Postgres

dbWatch Control Center Navigation » Control Center Jobs » For Postgres

Control Center Jobs Description Availability Archive status Checking pg_stat_archiver for archiving errors Autovacuum freeze Checks for transactions vs auto vacuum freeze max age Backup check –…

SQL Worksheet

dbWatch Control Center Navigation » SQL Worksheet

One of the truly unique features of dbWatch is its integrated SQL Worksheet, which, although simple in operation has some sophisticated applications, including cross-database queries. The SQL Worksheet is not developed from a developer-centric perspective and therefore…

The property file format

Advance Topics » 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…

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 supports. . In a typical operation the value of the managed systems is much greater than the resources used on the operations side. Running a…