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

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

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…

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…

dbWatch Control Center Navigation

dbWatch Control Center Navigation

In this chapter, we’ll be looking activities and operations to do in Control Center. ← Groups Configuration / Tree navigation →

dbWatch monitoring and Reporting

dbWatch monitoring and Reporting

In this section, we’ll be discussing how to modify your monitoring dashboard and generating a report.. ← Category line chart / Monitoring →

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…

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 …

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

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

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…

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…

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…

Logging

Configuration » Logging

Default setup [Users home]/monitor.log: The monitor will log events to this log. [install dir]/server.log : The server will log events to this log file. Eventlog: On windows systems the server will log login events, failed login events and disconnects to the…

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…

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…

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…

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

Importing resources

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

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…

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…

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…

Initial Domain Setup

Getting Started with dbWatch Control Center » Installing on Windows » Initial Domain Setup

All dbWatch Servers are part of a domain. This domain is unique for each customer and it is specified in the dbWatch license. Every dbWatch installation must have one of the dbWatch Servers specified as the Domain Controller. The first time a you start the dbWatch…

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…

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…

Customizing Control Center

Advance Topics » Customizing Control Center

dbWatch Control Center offers ways in customizing your application. In this section, we will go over how you can customize your dashboards and prepare customized reports. To proceed, click on of the topics below: Customize dbWatch Views using FDL Customize Reports…

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…

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…

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…

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…

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…

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

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…

Troubleshooting Guide

Troubleshooting Guide

In this section, we’ll discuss about: dbWatch Backup Restoring Configuration Backup Fault Finding Guide Issues and Troubleshooting Definition Mapping ← Integration for Brent Ozar’s First Responder Kit / Backup of dbWatch…

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…

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…

Additional Resources

Additional Resources

Here are an additional resources that might help you. You can check all the FAQS on our website. Go to dbWatch/faq You can access our FAQs on this site. Go to FAQs Section To check our video libarary, you can access the link provided: dbWatch/videos ←…

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…

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…

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…

Property System

Advance Topics » Property System

There are several types of properties in dbWatch. Predefined properties Predefined are always present. For example, instances have properties called name and host. Metadata properties Metadata properties are manually assigned to particular objects in dbWatch (like…

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…

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…

Edit Management

Advance Topics » Edit Management

Currently there is no graphical interface for editing the managment interface. However, everything is defined in xml files that can be edited directly. Documentation of the syntax is not complete, and you have to rely on the existing code for examples. The following…

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…

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…

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…

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…

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…

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

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…

Configuration

Configuration

Server Configuration The Server Configuration can be accessed through the Server->Server Configuration->Server configuration menu. The configuration values control the following: session-timeout: How long (in seconds) a session (SQL Worksheet) can be inactive…

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…

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…

Domain Configuration

Configuration » Domain Configuration

How to get here The Domain Configuration can be accessed by going to Server > Domain Configuration. Overview The Domain Configuration dialog lets you configure domain-wide settings. The concepts listed for each domain on the left side tree are: Nodes –…

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

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…

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…

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…

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…

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…

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…

Credential Storage Policy

Configuration » Credential Storage Policy

You can specify the amount of information about logins that the dbWatch Monitor is allowed to store, by adjusting the Monitor Credential Storage policy in the doman configuration view. The legal settings are: Allow username and password The Monitor can store the…

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…

Modify Monitoring View

dbWatch monitoring and Reporting » Monitoring » Modify Monitoring View

You can modify the Monitoring View by right-clicking on the tab and select Edit. You can do this in either tab (“Instance Status” or “Instance”). A separate window will appear showing you the FDL query for that tab view. To Edit the FDL…

Category line chart

Advance Topics » Edit Management » Result types » Graphical » Category line chart

A category line chart example The specification for this chart SELECT rtrim(ltrim(instance_name)) "Type", cntr_value "Value" FROM sys.dm_os_performance_counters where counter_name like 'Lock Requests/sec%' and instance_name in ( select top 6…

Service groups

dbWatch Monitor Setup » Service groups

In dbWatch you can organize instances in servicegroups Instances placed in the same servicegroup should provide a common service of some sort. For example this can be instances belonging to the same cluster. Servicegroups may also be placed inside other…

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…

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…

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…

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…

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…