Architecture components

The dbWatch installation consists of three components:

  1. dbWatch Monitor/Client serves as the front end GUI
  2. dbWatch Server is the core business logic and central hub of the system
  3. dbWatch Framework contains stored objects in the registered database instances.

dbWatch Monitor

The dbWatch Monitor is the GUI front end for interacting with one or several dbWatch Servers. The Monitor is an installed application.

dbWatch Server

The dbWatch Server is the server program that is responsible for all communication with the configured database instances. It is responsible for triggering the monitoring procedures (if monitoring is enabled), generating reports and performing the actual administration tasks. The dbWatch Server can also communicate with 3rd party products through extensions. In more advanced environments, the dbWatch Server can be configured to have one or more roles configured. This depends on license and features enabled.

dbWatch Server roles

When configured in more advanced environments, role seperation is possible. There are several possible roles and a dbWatch Server can have one or more of them:

Instance hub

This role is for connecting to and monitoring database instances. A configuration of multiple dbWatch Server nodes, can have one or more nodes with the role of instance hub, to enable monitoring multiple security zones, aid with scalability or provide fail-over assistance.

Domain CA

This role is typically the first to be configured, as the domain CA is the node that handles configuration of other nodes and the security.

Storage

This node is used for storage, typically for USL (Unified Scripting Language). If a script needs to temporary or permanently store data, this node will hold the actual data.

Cloud router

This node is used to route secure communication between dbWatch Server nodes. Typical usage is when a dbWatch node can only do outbound connections and you need a common connection point for the GUI client to connect to.

Host node

This node is used for USL to perform scripts that interact with the underlying host. Its used for integrations and USL scripting, but can also work as an agent to allow for host monitoring.

Webserver

This node provides web dashboards and data exports populated with data from FDL (Farm Data Language) queries from across the environment.

Update

This node provides updates for the automatic update functionality for other nodes in the environment. May have internet access to download updates automatically or provide manually downloaded updates for the other dbWatch nodes

Database Instances

There are 4 dbWatch modules that can be enabled for each database instance, the following briefly describes their impact on the instance;

Monitoring

When you enable monitoring for a particular instance a dbWatch Engine is installed on the instance. The Engine is a set of database objects (Procedures, Tables & Functions) written in the native language related to that instance. This code provides the interface used by the dbWatch Server when triggered by the dbWatch Tasks and Alerts. It is also used by Tasks and Alerts to report back to the dbWatch Server.
All engine codes are open for end users to view and is included with the installation of the dbWatch Server. The dbWatch Server maintains a pool of up to 4 sessions which perform the monitoring of each instance.

Management

The dbWatch Management module consists of a set of specifications that define the management interface your user has for a particular instance. A specification can optionally define a set of “helper” objects on the database instance. This will usually entail a number of tables used for temporary storage and functions that perform codes which are used often. If the selected management specification contains such objects, they are installed on the instance the first time the management interface is used and this then is Management.

Framework

The dbWatch Server has a pool of sessions for each instance that will grow on demand, based on the user commands issued in the Management interface. This will hardly ever grow beyond 1 or 2 sessions and when the user is inactive for a while (30 second default) sessions are terminated.

SQL Worksheet

The dbWatch SQL Worksheet allows you to perform custom SQL statements on any database instance. It has no associated database objects. The dbWatch Server has a pool of sessions for each instance that will grow on demand based on the SQL statements issued in the SQL Worksheet. This will hardly ever grow beyond 1 or 2 sessions. When the user is inactive for a while (30 second default) sessions are terminated.

Reports

The dbWatch Reports allows you to generate reports based on any data on any database instance. It has no associated database objects.
The dbWatch Server will create a session for each (global) report it generates and terminates it afterwards. On a normal system this will result in no more than a handfull of sessions being generated per day.

← Product Overview / Example architecture designs →

Feedback

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment