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

Installing on Multihomed Systems

Getting Started » Installing on Multihomed Systems

Multihomed describes a computer host that has multiple IP addresses connected to networks. When the dbWatch Server runs on a multihomed computer, you have to specify which IP the Server should bind to. On windows Create/change the environment variable called…

Installing on Linux

Getting Started » Installing on Linux

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

Installing on Windows

Getting Started » 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…

dbWatch installation on Ubuntu

Getting Started » Installing on Linux » dbWatch installation on Ubuntu

Step by step guide To start off, prepare the installation directory of dbWatch. Execute the following commands: Create a new directory for dbWatch: sudo mkdir –p /usr/local/dbWatch Then input the root or super user password. Change the owner of the…

SQL Server Always ON Cluster Monitoring

Setup and Usage » SQL Server Always ON Cluster Monitoring

dbWatch allows you to monitor the status of your Always ON High Availability groups and check the state of the member nodes within an AlwaysOn cluster. Let’s start by adding a database instance in the dbWatch application. On top Choose Add database > Select MS SQL…

Getting Started

Getting Started

In this section we will learn the supported platforms of dbWatch. Download dbWatch The dbWatch installer can be downloaded here About the architecture dbWatch is a distributed system that consists of two seperate applications (the dbWatch Server and the dbWatch…

Upgrading dbWatch

Getting Started » Upgrading dbWatch

dbWatch tests and supports upgrades from 11.x to 12.x only. If you have an older installation, it is recommended that you remove the old dbWatch installation and schema in the database and install the latest dbWatch release. Steps for upgrade Contact dbWatch Support…

Nagios

Advanced Topics » dbWatch Extensions » Extensions » Nagios

Introduction The dbWatch Nagios extension mechanism consists of two parts. First, a jar file called nagiospump.jar that causes dbWatch to export its status to a text file. Second a Nagios plugin called Nagios_Fileread.pl that imports the status in the text file into…

Nagios

Extending dbWatch » Extensions » Nagios

Introduction The dbWatch Nagios extension mechanism consists of two parts. First, a jar file called nagiospump.jar that causes dbWatch to export its status to a text file. Second a Nagios plugin called Nagios_Fileread.pl that imports the status in the text file into…

HP Openview

Advanced Topics » dbWatch Extensions » Extensions » HP Openview

Installing Installing the dbWatch HP OpenView extension is quite straightforward. You need a file called openview.jar that can be downloaded from the dbWatch website: https://download.dbwatch.com/download/extensions/openview/ Place the openview.jar file in the…

HP OpenView

Extending dbWatch » Extensions » HP OpenView

Installing Installing the dbWatch HP OpenView extension is quite straightforward. You need a file called openview.jar that can be downloaded from the dbWatch website: https://download.dbwatch.com/download/extensions/openview/ Place the openview.jar file in the…

Adding an SQLServer Instance

Setup and Usage » Adding an SQLServer Instance

How to get here To add an SQLServer instance, click on the “Add” icon on the main toolbar. This will bring up the “Add Database Instance” wizard, which will guide you through the following steps. Select Installation Type The first step of…

Adding a SQL Server Instance

dbWatch Monitor Setup » Adding a SQL Server Instance

How to get here To add an SQLServer instance, click on the “Add” icon on the main toolbar. This will bring up the “Add Database Instance” wizard, which will guide you through the following steps. Select Installation Type The first step of…

Adding a SQL Express Instance

Setup and Usage » Adding an SQLServer Instance » Adding a SQL Express Instance

To add a SQL Express instance, click on the “Add database” icon on the main toolbar. It will display the “Add Database Instance” wizard, which will guide you through the following steps. Select Installation Type The first step of the…

Adding a SQL Express Instance

dbWatch Monitor Setup » Adding a SQL Server Instance » Adding a SQL Express Instance

To add a SQL Express instance, click on the “Add database” icon on the main toolbar. It will display the “Add Database Instance” wizard, which will guide you through the following steps. Select Installation Type The first step of the…

Replication

Setup and Usage » Replication

dbWatch allows you to monitor the status of your database replication. You can do this by installing replication status task in dbWatch. Choose Configure Monitoring Select the instance you want to install the task in. Tick Replication status and click…

Replication Monitoring

dbWatch Monitoring and Reporting » Monitoring » Replication Monitoring

dbWatch allows you to monitor the status of your database replication. You can do this by installing replication status task in dbWatch. Choose Configure Monitoring Select the instance you want to install the task in. Tick Replication status and click…

Adding an Oracle Instance

Setup and Usage » Adding an Oracle Instance

Oracle Prerequisites Oracle databases need to have a listener process running and also allow for an external login with sysdba user or user with enough privileges. You need a privileged user, such as sys as sysdba, another user with sysdba privileges or another user…

Adding an Oracle instance

dbWatch Monitor Setup » Adding an Oracle instance

Oracle Prerequisites Oracle databases need to have a listener process running and also allow for an external login with sysdba user or user with enough privileges. You need a privileged user, such as sys as sysdba, another user with sysdba privileges or another user…

SCOM

Advanced Topics » dbWatch Extensions » Extensions » SCOM

Required files You need two files scom.jar and dbWatchMP.xml that can be downloaded from the following location: https://download.dbwatch.com/download/extensions/SCOM/ Installing The first thing you must do is to tell dbWatch to export the SCOM text file. In order…

SCOM

Extending dbWatch » Extensions » SCOM

Required files You need two files scom.jar and dbWatchMP.xml that can be downloaded from the following location: https://download.dbwatch.com/download/extensions/SCOM/ Installing The first thing you must do is to tell dbWatch to export the SCOM text file. In order…

Unit4 Agresso

Setup and Usage » Application Modules » Unit4 Agresso

Installation guide for Microsoft SQL Server and Oracle platforms The dbWatch Agresso Module is based on the dbWatch Engine Framework and can be installed during the initial installation of the dbWatch Framework. If the MS SQL Server or Oracle instance where the…

Adding a Sybase Instance

dbWatch Monitor Setup » Adding a Sybase Instance

How to get here To add a Sybase instance, click on the “Add” icon on the main toolbar. This will bring up the “Add Database Instance” wizard, which will guide you through the following steps. Select Installation Type The first step of the…

Unit4 Agresso

Advanced Topics » Application Modules » Unit4 Agresso

Installation guide for Microsoft SQL Server and Oracle platforms The dbWatch Agresso Module is based on the dbWatch Engine Framework and can be installed during the initial installation of the dbWatch Framework. If the MS SQL Server or Oracle instance where the…

Adding a Sybase Instance

Setup and Usage » Adding a Sybase Instance

How to get here To add a Sybase instance, click on the “Add” icon on the main toolbar. This will bring up the “Add Database Instance” wizard, which will guide you through the following steps. Select Installation Type The first step of the…

Managing Tasks and Alerts

Setup and Usage » Managing Tasks and Alerts

dbWatch Tasks and Alerts are the cornerstone of the dbWatch Monitoring framework. By controlling which Tasks and Alerts are installed on your database instances, you control what aspects of the instance that is monitored. How to get here To access the Manage Tasks…

Managing tasks and alerts

dbWatch Navigation » Managing tasks and alerts

dbWatch Tasks and Alerts are the cornerstone of the dbWatch Monitoring framework. By controlling which Tasks and Alerts are installed on your database instances, you control what aspects of the instance that is monitored. How to get here To access the Manage Tasks…

Edit Tasks and Alerts

Development in dbWatch » Edit Tasks and Alerts

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…

Edit tasks and alerts

dbWatch Navigation » Edit tasks and alerts

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…

Release notes

About dbWatch » Release notes

New in dbWatch 12.6.16 21. okt 2019 – ( Download ) Bugfix [DBW-371] – Fix for “Update statistics” in MS SQL Server management. [DBW-372] – Executing report queries from task/report editor does not work New in dbWatch 12.6.15 09.…

Modify Monitoring View

Setup and Usage » Modify Monitoring View

On the right side in the Monitoring tab, there are two different views. An instance view and a task view. Wich one depends on the selection in the navigation tree on the left side. Both these views can be modified by right clicking on the header, and selecting…

Modifying Monitoring View

dbWatch Monitoring and Reporting » Monitoring » Modifying Monitoring View

On the right side in the Monitoring tab, there are two different views. An instance view and a task view. Wich one depends on the selection in the navigation tree on the left side. Both these views can be modified by right clicking on the header, and selecting…

Fault Finding Guide

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

Reporting

dbWatch Monitoring and Reporting » Reporting

dbWatch comes bundled with a series of report templates that you can use to generate standard reports on various aspects of your database environment. dbWatch also allows you to edit the templates or create your own for fully customizable reporting. You can access…

Reporting

Setup and Usage » Reporting

dbWatch comes bundled with a series of report templates that you can use to generate standard reports on various aspects of your database environment. dbWatch also allows you to edit the templates or create your own for fully customizable reporting. You can access…

Web Configuration

dbWatch Server Configuration » Web Server » Web Configuration

To enable the Web server, go to the “Configure” -> “Server Configuration” -> “Web Server” menu. If the Web server is not enabled, you will be greeted with an “Initial webserver setup dialog”. Here you can enter the…

Web configuration

Setup and Usage » Web server » Web configuration

To enable the Web server, go to the “Configure” -> “Server Configuration” -> “Web Server” menu. If the Web server is not enabled, you will be greeted with an “Initial webserver setup dialog”. Here you can enter the…

Group Configuration

dbWatch Monitor Setup » Group Configuration

How to get here You can access the group configurations view by clicking on the Groups icon on the main toolbar. Overview The Group Configuration view consists of two main parts. On the left side you can see a tree structure showing the groups, and on the right…

Groups Configuration

Setup and Usage » Groups Configuration

How to get here You can access the group configurations view by clicking on the Groups icon on the main toolbar. Overview The Group Configuration view consists of two main parts. On the left side you can see a tree structure showing the groups, and on the right…

OS monitoring

Setup and Usage » OS monitoring

dbWatch provides OS monitoring by connecting to the host machine that is running the database instance using SSH. This currently works only for Unix-like platforms. To enable OS monitoring through SSH you first have to register the database instance running on the…

JDBC Properties

Setup and Usage » Instance Configuration » JDBC Properties

It is possible to set properties for the JDBC driver on specific instances. You can find this under “Advanced Driver Setup” in the Add instance wizard, or under “Edit parameters” in the JDBC panel in the Configure instance dialog. The…

Operating system monitoring

dbWatch Monitoring and Reporting » Monitoring » Operating system monitoring

dbWatch provides OS monitoring by connecting to the host machine that is running the database instance using SSH. This currently works only for Unix-like platforms. To enable OS monitoring through SSH you first have to register the database instance running on the…

dbWatch Logs

dbWatch Server Configuration » dbWatch Logs

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…

Logging

Setup and Usage » 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…

JDBC Properties

dbWatch Monitor Setup » Instance Configuration » JDBC Properties

It is possible to set properties for the JDBC driver on specific instances. You can find this under “Advanced Driver Setup” in the Add instance wizard, or under “Edit parameters” in the JDBC panel in the Configure instance dialog. The…

Web server

Setup and Usage » Web server

Dbwatch can be configured to serve dynamic web content over http. Webserver configuration Webserver setup Mountable web pages The following pages can be mounted on an url in dbWatch. Dashboard Data export ← Running several Monitors in parallel / …

Metadata Properties

Advanced Topics » Property System » Metadata Properties

You can put metadata on instances, and this metadata will be automatically available in dbwql. 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…

Metadata properties

Setup and Usage » Property System » Metadata properties

You can put metadata on instances, and this metadata will be automatically available in dbwql. 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…

Web Server

dbWatch Server Configuration » Web Server

Dbwatch can be configured to serve dynamic web content over http. Webserver configuration Webserver setup Mountable web pages The following pages can be mounted on an url in dbWatch. Dashboard Data export ← Special setup in NAT environments / …

Edit Report Templates

Development in dbWatch » Edit Report Templates

Report Selection When you click on “Reports” 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”. Report…

Edit Report Templates

dbWatch Monitoring and Reporting » Reporting » Edit Report Templates

Report Selection When you click on “Reports” 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”. Report…

Instance Configuration

Setup and Usage » Instance Configuration

How to get here The instance configuration view can be accessed by clicking on the Instances icon on the main toolbar, or by right clicking directly on an instance and selecting Configure from the pop-up menu. Main view The instance configuration view consists of…

Instance Configuration

dbWatch Monitor Setup » Instance Configuration

How to get here The instance configuration view can be accessed by clicking on the Instances icon on the main toolbar, or by right clicking directly on an instance and selecting Configure from the pop-up menu. Main view The instance configuration view consists of…

Operator Configuration

dbWatch Monitor Setup » Operator Configuration

Access to dbWatch is controlled through operators. Operators have a password and a set of privileges on dbWatch. How to get here The operator configuration view can be accessed by clicking on Operators on the main toolbar. Operators main view The operators view…

Operator Configuration

Setup and Usage » Operator Configuration

Access to dbWatch is controlled through operators. Operators have a password and a set of privileges on dbWatch. How to get here The operator configuration view can be accessed by clicking on Operators on the main toolbar. Operators main view The operators view…

Special setup in NAT environments

dbWatch Server Configuration » Special setup in NAT environments

dbWatch 11 and 12 uses JAVA RMI with SSL for network communication, and the JAVA RMI Registry functionality will create a problem when connecting from the monitor client to the server, when the IP address of the actual dbWatch server host is different from the IP…

Special setup in NAT environments

Setup and Usage » Configuration » Special setup in NAT environments

dbWatch 11 and 12 uses JAVA RMI with SSL for network communication, and the JAVA RMI Registry functionality will create a problem when connecting from the monitor client to the server, when the IP address of the actual dbWatch server host is different from the IP…

Example: Restrict access to instances

dbWatch Monitor Setup » Operator Configuration » Example: Restrict access to instances

Scenario I have a consultant coming in to do some work on our Oracle instances. I want to create a user for him so that he can only modify the Oracle instances. Solution First, to have a secure setup make sure that at least the following objects are secured. (Any…

Backup of dbWatch

Troubleshooting » 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 is installed in a directory which is normally /usr/local/dbWatch/[version] on Unix/Linux and…

Example: Restrict access to instances

Setup and Usage » Operator Configuration » Example: Restrict access to instances

Scenario I have a consultant coming in to do some work on our Oracle instances. I want to create a user for him so that he can only modify the Oracle instances. Solution First, to have a secure setup make sure that at least the following objects are secured. (Any…

Architecture

Overview of dbWatch » Architecture

Architecture components The dbWatch installation consists of three components; the dbWatch Monitor which is the front end GUI. The dbWatch Server which is the core business logic and central hub of the system. And the dbWatch Framework where objects are stored in the…

CLI examples

Setup and Usage » Commandline » CLI examples

Moving an instance from Server A to Server B Get the configuration from the source server The following command gets the configuration of the instance called “MyInstanceName” from the local dbWatch Server and puts it in the file instance.xml dbw get -url…

dbWatch Notes

dbWatch Navigation » dbWatch Notes

dbWatch allows you to attach notes to tasks, instances and servers. You can access the notes dialog by right clicking on a instance/task/server, and selecting “Notes” on the menu, The notes dialog has two tabs, one for public notes (visible to all…

View host cpu and disk usage

dbWatch Monitor Setup » Adding a MySQL Instance » View host cpu and disk usage

Configure SSH to view cpu and disk usage Currently the tasks for CPU and disk usage are not installed. You must enable SSH to install it. Go to the management module > Right click on the Instance > Choose Configure A new window will appear > Select the…

Notes

Setup and Usage » Notes

dbWatch allows you to attach notes to tasks, instances and servers. You can access the notes dialog by right clicking on a instance/task/server, and selecting “Notes” on the menu, The notes dialog has two tabs, one for public notes (visible to all…

Adding SQL Server Instances in Bulk

dbWatch Monitor Setup » Adding a SQL Server Instance » Adding SQL Server Instances in Bulk

Select Installation Type The first step of the wizard lets you select the type of installation. Select MS SQLServer as the database type, and “Add Database Instance (BULK)” as installation type. Click “Next”. Select Group Select the group…

Adding SQLServer Instances (BULK)

Setup and Usage » Adding an SQLServer Instance » Adding SQLServer Instances (BULK)

Select Installation Type The first step of the wizard lets you select the type of installation. Select MS SQLServer as the database type, and “Add Database Instance (BULK)” as installation type. Click “Next”. Select Group Select the group…

CLI Examples

Advanced Topics » Command Line » CLI Examples

Moving an instance from Server A to Server B Get the configuration from the source server The following command gets the configuration of the instance called “MyInstanceName” from the local dbWatch Server and puts it in the file instance.xml dbw get -url…

Scheduled Reports

dbWatch Monitoring and Reporting » Reporting » Scheduled Reports

Scheduled reports are defined to be generated at specified intervals, and can be automatically emailed to you when they are completed. Create a scheduled report To create a scheduled report see Generate Report. Configure a scheduled report Once a report has been…

Scheduled reports

Setup and Usage » Reporting » Scheduled reports

Scheduled reports are defined to be generated at specified intervals, and can be automatically emailed to you when they are completed. Create a scheduled report To create a scheduled report see Generate Report. Configure a scheduled report Once a report has been…

SNMP v1

Extending dbWatch » Extensions » SNMP v1

Setup To configure the extensinio, go to the “Server”->“Server extensions” menu in the dbWatch Monitor. Here you will find an entry called “SNMP v1 extension”, select this and click “Configure” on the toolbar. In the…

Tasks and Alerts

dbWatch Navigation » Tasks and Alerts

Tasks and Alerts are the cornerstone of the dbWatch Monitoring module. Tasks and Alerts perform the actual monitoring of the database instance. There are two types of Tasks and Alerts. The Standard Tasks and Alerts, and the Advanced Tasks and Alerts. Standard…

SNMP v1

Advanced Topics » dbWatch Extensions » Extensions » SNMP v1

Setup To configure the extensinio, go to the “Server”->“Server extensions” menu in the dbWatch Monitor. Here you will find an entry called “SNMP v1 extension”, select this and click “Configure” on the toolbar. In the…

Overview of dbWatch

Overview of dbWatch

This topic will be covering setup and methods for the way we at dbWatch consider setting up dbWatch for Database Operations in the best possible way. It will be based on experience from our customers as well as our own database operations team. Architecture Tasks…

Running several Monitors in parallel

Setup and Usage » 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…

Discovering Database Instances

Setup and Usage » 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…

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…

SQL Worksheet

Setup and Usage » 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…

SQL Worksheet

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

Adding Oracle Instances (BULK)

Setup and Usage » Adding an Oracle Instance » Adding Oracle Instances (BULK)

Select Installation Type The first step of the wizard lets you select the type of installation. Select Oracle as the database type and “Add Database Instance (BULK)” as installation type. Click “Next”. Select Group Select the group you…

Adding Oracle Instances in Bulk

dbWatch Monitor Setup » Adding an Oracle instance » Adding Oracle Instances in Bulk

Select Installation Type The first step of the wizard lets you select the type of installation. Select Oracle as the database type and “Add Database Instance (BULK)” as installation type. Click “Next”. Select Group Select the group you…

Oracle License Analysis

dbWatch Monitoring and Reporting » Monitoring » Oracle License Analysis

dbWatch allows you to collect and monitor the license information of your Oracle instances. You will be able to check the various options and features installed within your instance that has an added cost. This feature is useful to avoid Oracle’s unexpected fees…

Restore configuration backup

Setup and Usage » 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…

Restore dbWatch configuration backup

Troubleshooting » Restore dbWatch 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 new server to your dbWatch monitor

dbWatch Server Configuration » Adding a new server to your dbWatch monitor

dbWatch Monitor supports connecting to multiple monitors, which can be handy in setups where you have two seperate networks and need the databases in both networks monitored. This setup requires that the machine running dbWatch Monitor can see both the dbWatch Server…

Adding a MySQL Instance

dbWatch Monitor Setup » Adding a MySQL Instance

How to get here To add a MySQL instance, click on the “Add” icon on the main toolbar. This will bring up the “Add Database Instance” wizard, which will guide you through the following steps. Select Installation Type The first step of the…

Importing resources

Development in dbWatch » 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…

Add a new server to your monitor

Setup and Usage » Configuration » Add a new server to your monitor

dbWatch Monitor supports connecting to multiple monitors, which can be handy in setups where you have two seperate networks and need the databases in both networks monitored. This setup requires that the machine running dbWatch Monitor can see both the dbWatch Server…

Importing Resources

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

SQLServer performance benchmarks

Setup and Usage » SQLServer performance benchmarks

Dbwatch comes with a set of benchmarks for measuring the performance capabilities of an SQLServer instance. This benchmarks runs a series of DML statements designed to test various key properties of a database system. This is the same benchmarks we have used to…

SQL Server performance benchmarking

dbWatch Monitoring and Reporting » Monitoring » SQL Server performance benchmarking

Dbwatch comes with a set of benchmarks for measuring the performance capabilities of an SQLServer instance. This benchmarks runs a series of DML statements designed to test various key properties of a database system. This is the same benchmarks we have used to…

Issues and fixes

Troubleshooting » Issues and fixes

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…

Web data export

Setup and Usage » 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 in several formats, most notably html, json and csv. To create a simple export containing an overview of your environment, click “New” in…

Issues and troubleshooting

Setup and Usage » 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…

Web Data Export

dbWatch Server Configuration » 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 in several formats, most notably html, json and csv. To create a simple export containing an overview of your environment, click “New” in…

Running several Servers in parallel

Setup and Usage » 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…

SQL Server AlwaysON Monitoring

dbWatch Monitoring and Reporting » Monitoring » SQL Server AlwaysON Monitoring

dbWatch allows you to monitor the status of your Always ON High Availability groups and check the state of the member nodes within an AlwaysOn cluster. Let’s start by adding a database instance in the dbWatch application. On top Choose Add database > Select MS SQL…

Generate Reports

Setup and Usage » Reporting » Generate Reports

When you click on “Generate Report”, 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…

Edit Management

Development in dbWatch » 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…

Custom headings

Setup and Usage » Web server » Web dashboard » Custom headings

Setting custom headings in dashboard You can set custom headings in dashboard, they are spesified in the url. Normaly the dashboard URL for a dbWatch Server running on local host with a dashboard configured as “dashboard”…

Generate Reports

dbWatch Monitoring and Reporting » Reporting » Generate Reports

When you click on “Generate Report”, 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…

Adding Instances With Existing Schema

Setup and Usage » Adding Instances With Existing Schema

If you have a database instance with an existing dbWatch schema and you want to use this you have to first add the instance with only the “Administration” module. Follow the normal procedure for adding the instance (click “Add” on the main…

Formatting tables results

dbWatch Navigation » Edit Management » Formatting tables results

When you are displaying a table result based on an SQL query, you have the same render hints that are offered as part of dbwql. To use these hints, add a “result-table-format” tag to the result. select a, b, c from sometable TABLE …

Adding instances with existing dbWatch schema

dbWatch Monitor Setup » Adding instances with existing dbWatch schema

If you have a database instance with an existing dbWatch schema and you want to use this you have to first add the instance with only the “Administration” module. Follow the normal procedure for adding the instance (click “Add” on the main…

Formatting table results

Development in dbWatch » Edit Management » Formatting table results

When you are displaying a table result based on an SQL query, you have the same render hints that are offered as part of dbwql. To use these hints, add a “result-table-format” tag to the result. select a, b, c from sometable TABLE …

Custom Heading

dbWatch Server Configuration » Web Server » Web Dashboard » Custom Heading

Setting custom headings in dashboard You can set custom headings in dashboard, they are spesified in the url. Normaly the dashboard URL for a dbWatch Server running on local host with a dashboard configured as “dashboard”…

Edit Management

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

DBWQL – dbWatch Query Language

Advanced Topics » DBWQL – dbWatch Query Language

Introduction to dbwql Dbwql is the query language used in dbWatch to find information about objects. This topic should be considered as the advanced part of dbWatch. It is also the central part from which many features in dbWatch are based and should be learned by…

Protecting the communication

Setup and Usage » Configuration » Protecting the communication

This page describes the communication between the dbWatch Monitor and the Server. The default setup To ensure the privacy of the user sessions, dbWatch wraps all communication between the monitors and the servers in ssl. During installation the installer generates…

Auditing

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

Tree navigation

Setup and Usage » Tree navigation

In the tree structures that you will find throughout dbWatch there are 2 components that lets you group and filter instances. On the top of the tree you have a “Grouping” panel that is minimized by default, and below that you have the quick text based…

Tree Navigation

dbWatch Navigation » Tree Navigation

In the tree structures that you will find throughout dbWatch there are 2 components that lets you group and filter instances. On the top of the tree you have a “Grouping” panel that is minimized by default, and below that you have the quick text based…

Commandline Configuration

Setup and Usage » Commandline » Commandline Configuration

Configuring default behaviour in the command line When executed, the dbw command searches the file [user]/.dbwatch/dbw.conf for default values within its parameters. By setting default values in this file it is possible to greatly increase the usability of the dbw…

Command line configuration

Advanced Topics » Command Line » Command line configuration

Configuring default behaviour in the command line When executed, the dbw command searches the file [user]/.dbwatch/dbw.conf for default values within its parameters. By setting default values in this file it is possible to greatly increase the usability of the dbw…

Auditing

Setup and Usage » Configuration » 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…

Protecting the communication

dbWatch Server Configuration » Protecting the communication

This page describes the communication between the dbWatch Monitor and the Server. The default setup To ensure the privacy of the user sessions, dbWatch wraps all communication between the monitors and the servers in ssl. During installation the installer generates…

Nimsoft/Nimbus

Advanced Topics » dbWatch Extensions » Extensions » Nimsoft/Nimbus

Installation In order to install the dbWatch Nimsoft extension you need two files nimbus.jar nimbuspump.jar They can be downloaded from the following…

Nimsoft/Nimbus

Extending dbWatch » Extensions » Nimsoft/Nimbus

Installation In order to install the dbWatch Nimsoft extension you need two files nimbus.jar nimbuspump.jar They can be downloaded from the following…

SNMP v3

Extending dbWatch » Extensions » SNMP v3

Setup To enable the SNMPv3 extension, go to the “Server”->“Server extensions” menu in the dbWatch Monitor. Here you will find an entry called “SNMP extension”, select this and click “Configure” on the toolbar. This will bring up thefollowing …

SNMP v3

Advanced Topics » dbWatch Extensions » Extensions » SNMP v3

Setup To enable the SNMPv3 extension, go to the “Server”->“Server extensions” menu in the dbWatch Monitor. Here you will find an entry called “SNMP extension”, select this and click “Configure” on the toolbar. This will bring up thefollowing …

Create Custom Extensions

Advanced Topics » dbWatch Extensions » Create Custom Extensions

All dbWatch extensions are written in the Java programming language, so creating a custom extension requires some basic knowledge of Java. Dependencies You will need the following jar files located in the [dbWatch Server]/server/lib/…

Creating Custom Extensions

Extending dbWatch » Creating Custom Extensions

All dbWatch extensions are written in the Java programming language, so creating a custom extension requires some basic knowledge of Java. Dependencies You will need the following jar files located in the [dbWatch Server]/server/lib/…

Integrating with Active Directory

Setup and Usage » Configuration » Integrating with Active Directory

Setting up Active Directory authentication By default dbWatch authenticates users using it’s own internal username/password database. This section describes how to add Active Directory as a second user authentication provider. Connect to the server with the…

Integrating with active directory

dbWatch Server Configuration » Integrating with active directory

Setting up Active Directory authentication By default dbWatch authenticates users using it’s own internal username/password database. This section describes how to add Active Directory as a second user authentication provider. Connect to the server with the…

Email and SMS

Advanced Topics » dbWatch Extensions » Extensions » 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 3.0.1 or later). (If it is not, click “Import”) To configure the extension, select it and click…

Email and SMS

Extending dbWatch » Extensions » 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 3.0.1 or later). (If it is not, click “Import”) To configure the extension, select it and click…

Startup configuration

Setup and Usage » 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…

Item active

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

Item active

Development in dbWatch » Edit 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…

Startup Configuration

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

Defining Autodiscover Ports

Setup and Usage » 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…

Web Dashboard

dbWatch Server Configuration » Web Server » Web Dashboard

The web dashboard feature To enable the web based dashbord, select “New” in the “Configure WebServer” view. This will bring up the “New url” dialog. Specify an url for the dashboard and select no.dbwatch.dashboard:dashboard as…

SQL Server Compatibility Level

Setup and Usage » SQL Server Compatibility Level

dbWatch provides DBAs the overview of their database’s compatibility level and displays other attributes of the sql server database they are using. The compatibility report view enables DBAs to find where they have the potential for performance improvements by…

Web dashboard

Setup and Usage » Web server » Web dashboard

The web dashboard feature To enable the web based dashbord, select “New” in the “Configure WebServer” view. This will bring up the “New url” dialog. Specify an url for the dashboard and select no.dbwatch.dashboard:dashboard as…

About dbWatch

About dbWatch

dbWatch 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 will give you the total overview you need…

License terms

Licensing and policies » License terms

dbWatch End User License Agreement 1. PARTIES This License and Services Agreement (“Agreement”) is between dbWatch AS, organization number 991 500 456 (“dbWatch”) and the Customer which is the entity or person whose name and contact details as it appears on…

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…

File Structure

Overview of dbWatch » File Structure

Files stored in the users home directory The monitor stores most of it’s configurations in the .dbwatch/monitor/ in the users home directory. This directory contains the following files: monitor.xml Stores various settings and preferences for the…

The property file format

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

Kerberos configuration

Advanced Topics » Kerberos configuration

The dbWatch server can be configured to authenticate to Oracle databases using Kerberos. Create a kerberos config file. Create a vmoptions file telling dbwatch where to find the kerberos config. If you want to authenticate using a ticket cache use the kinit…

Configuring kerberos

Setup and Usage » Configuration » Configuring kerberos

The dbWatch server can be configured to authenticate to Oracle databases using Kerberos. Create a kerberos config file. Create a vmoptions file telling dbwatch where to find the kerberos config. If you want to authenticate using a ticket cache use the kinit…

The property file format

Development in dbWatch » 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…

Graphical

dbWatch Navigation » Edit Management » Result Types » Graphical

The graphical type When specifying the graphical type there must also be a graphical tag inside the result. select ... graphical ... This graphical tag then again contains the various chart specifications. The currently supported charts…

Oracle RAC

dbWatch Monitor Setup » Adding an Oracle instance » Oracle RAC

dbWatch 11 finally lets you monitor and manage Oracle Real Application Clusters (RAC) the natural way. dbWatch Tasks and Alerts now comes in two forms, instance centric and database centric. Instance centric Tasks/Alerts monitors data that is relevant for a single…

Graphical

Development in dbWatch » Edit Management » Result types » Graphical

The graphical type When specifying the graphical type there must also be a graphical tag inside the result. select ... graphical ... This graphical tag then again contains the various chart specifications. The currently supported charts…

Oracle RAC

Setup and Usage » Adding an Oracle Instance » Oracle RAC

dbWatch 11 finally lets you monitor and manage Oracle Real Application Clusters (RAC) the natural way. dbWatch Tasks and Alerts now comes in two forms, instance centric and database centric. Instance centric Tasks/Alerts monitors data that is relevant for a single…

Devops with dbWatch

Devops with dbWatch

Database operations and devops Traditionally database operations has been a highly specialized field within it-operations. So much so that many organizations operate with platform specific dba teams. Because of the amount of platform specific know-how needed to…

Commands

Setup and Usage » Commandline » Commands

help Prints out a manual page in the console Example dbw -h ping Checks if a dbWatch server accepts a login. -l -login Username used to authenticate. -p -password Password used to authenticate. -url The address of a dbWatch…

Commands

Advanced Topics » Command Line » Commands

help Prints out a manual page in the console Example dbw -h ping Checks if a dbWatch server accepts a login. -l -login Username used to authenticate. -p -password Password used to authenticate. -url The address of a dbWatch…