Search - Control Center

Monitoring

Using Control Center » Monitoring

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

Monitoring

Customization » Monitoring

Custom monitoring and editing monitoring jobs dbWatch has two types of monitoring jobs that can detect issues in the database instances. They are referred to as Engine jobs and “No-engine jobs”. Engine jobs are jobs that run inside the database engine,…

Monitoring Engine

Using Control Center » Instance management » Instance Configuration » Monitoring Engine

The monitoring section of the Configure Instance view looks different depending on if you have a monitoring engine (i.e a database) defined on the instance. With engine: Without engine: Text may vary a bit depending on the database type. Button…

Repository management and monitoring

Installing and using additional modules » SQL Performance package » Repository management and monitoring

Introduction The SQL Performance package creates tables in the dbWatch schema/database on each database instance where the SQL Statistics job is installed and scheduled. The process combines two parts of dbWatch Control Center. The monitoring is used to schedule the…

Customize View using FDL

Customization » Monitoring » 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…

Pause

Using Control Center » Monitoring » Pause

Monitoring in dbWatch have two “levels” of pause. You can pause the monitoring on an instance altogether, meaning that the monitoring jobs will not execute. Or you can pause the alert forwarding, meaning that the jobs will execute but dbWatch will not send…

Instance Configuration

Using Control Center » Instance management » Instance Configuration

How to get here Instance Configuration can be accessed by going to Server > Server Configuration > Instance Configuration, or by right clicking on an instance and selecting Configure Instance from the popup menu. Main view The instance configuration view consists…

Using Control Center

In this section, we will cover the user interface, the different modules, and how they are used. When we start dbWatch Control Center we will by default start-up in the monitoring view: We have the top menu, where we find the configuration of client connections…

Customization

dbWatch Control Center is designed to be customizable and much of the contents are developed inside the product In this section, we will go over how you can customize different parts of the product. To proceed, click on of the topics below: Customize dbWatch Views…

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…

The modules of Control Center

Using Control Center » The modules of Control Center

We have seven default modules available when you start dbWatch Control Center. This article will only introduce you to what these instances are and give a brief description of them. You need to be familiar with the navigation tree to better understand how these modules…

dbWatch alerts

Using Control Center » Management » Management on SQL Server » dbWatch alerts

dbWatch alerts is a list of monitoring jobs in the database in warning or alarm state for this database instance. Example: This is handy so you know you are working on the right database instance when you are correcting issues. You can interact with the…

Control Center Jobs

Using Control Center » Monitoring » 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…

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…

Parameters

Using Control Center » Monitoring » Job concepts » Parameters

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

Adding a PostgreSQL Instance

Using Control Center » Instance management » Adding a PostgreSQL Instance

How to get here To open the “Add Instance Wizard”, click on the “Plus (+)” sign on the bottom left of the dbWatch Client. This will bring up the “Add Instance” wizard, which will guide you through the following steps. Select Instance Type and Input…

Adding a SQLServer Instance

Using Control Center » Instance management » Adding a SQLServer Instance

How to get here To open the “Add Instance Wizard”, click on the “Plus (+)” sign on the bottom left of the dbWatch Client. Select Instance Type and Input Connection Details Specify the host and port number. dbWatch will attempt to…

Instance details

Using Control Center » Monitoring » Instance details

When navigating to an individual database instance, you get the instance details overview: This dashboard is intended to give an overview of what monitoring jobs are installed and how they are performing. The top tabs let you switch between the instance details…

Adding an Oracle Instance

Using Control Center » Instance management » Adding an Oracle Instance

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

No-engine jobs

Customization » Monitoring » No-engine jobs

No-engine jobs No-engine jobs are monitoring jobs that does not run in the database engine. No-engine jobs are jobs that run on the dbWatch Server, and typically run a SQL statement and process the result of this statement in javascript. Example code for different…

Tree navigation

Using Control Center » Monitoring » 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…

JDBC Properties

Using Control Center » Instance management » 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” when adding SQL instances or under “Edit parameters” in the JDBC panel in the Configure Instance dialog. The driver…

Database operations philosophy

Product Overview » Database operations philosophy

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

Privileges and actions map

Using Control Center » Domain Configuration » Privileges and actions map

Overview of actions and required privilege Instance is the specific database instance. Instance system is a predefined security group controlling the overall instance monitoring and management. Domain configuration is a predefined security group controlling the…

Adding a MySQL Instance

Using Control Center » Instance management » Adding a MySQL Instance

How to get here To open the “Add Instance Wizard”, click on the “Plus (+)” sign on the bottom left of the dbWatch Client. This will bring up the “Add Instance” wizard, which will guide you through the following steps. Select Instance Type and Input…

Importing resources

Customization » Importing resources

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

Release notes

About dbWatch Control Center » Release notes

dbWatch Control Center (2023-09-27) Download Important note Linux release is now available as an apt repository, see Linux install guide Only the server installation is available on Linux in this release (no graphical client or CCC scripting engine) New…

Installation variables

Customization » Monitoring » Editor for engine jobs » Installation variables

Installation variables are used if you want user input during job installation. It is mostly used for application-specific monitoring where the application schema or database can not be determined correctly by the job after installation and human input are…

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…

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: The pictured architecture is similar to the design and setup…

Job details

Using Control Center » Monitoring » Job details

When you click on one of the jobs in the job tree, you can see a more detailed job overview. The idea of this overview is to show current and historical state, configured parameters and how the job is behaving on other database instances. In the top left…

Disclaimer

Advanced Topics » Product Security » Disclaimer

Disclamer The information contained in this Product Security Wiki is for reference purposes only. Nothing contained in this document or relayed verbally to any customer will be deemed to amend, modify or supersede the terms and conditions of any written agreement…

Job concepts

Using Control Center » Monitoring » Job concepts

This section will try to explain more in-depth some of the concepts used in monitoring jobs in Control Center. There are currently two types of jobs, engine jobs, and no-engine jobs. The main difference between them is where processing occurs. Engine jobs do the…

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…

Troubleshooting issues in SQL Performance package

Installing and using additional modules » SQL Performance package » Repository management and monitoring » Troubleshooting issues in SQL Performance package

Graph issues with monitoring has been switched off If for some reason dbWatch Control Center has not been connected to a database instance running SQL Performance package for an extended time, you can get odd statistics errors in the graphs. It will look like a linear…

SQL Performance package

Installing and using additional modules » SQL Performance package

SQL Performance package SQL Performance module is an optional module in dbWatch Control Center that allows for historical monitoring and analysis of SQL Statements in the database instance. Currently supported platforms: MS SQL Server 2014 and newer Oracle 11g and…

Jobs grouped by category

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

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

Editor for engine jobs

Customization » Monitoring » Editor for engine jobs

How to get here Example jobs We have some example jobs to make the development easier here. Edit Existing To edit an existing Task or Alert open the Task/Alert Editor by right clicking on any task or alert and select Edit task from the popup menu. Create new…

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

Job menus

Using Control Center » Monitoring » Job menus

Each job has a set of menus. They can be accessed if you right-click on a job. This gives you several options. “Run now” will trigger the job now, outside of the normal schedule. “Details” will open the job report, providing details about…

Using SQL Performance package on MySQL

Installing and using additional modules » SQL Performance package » Using SQL Performance package on MySQL

Navigating to the SQL Performance package dashboard Once the SQL statistics job is installed and have collected data, you can navigate to the dashboard. It is located in the management interface for that database instance. The pictures and descriptions are from…

Properties

Customization » Monitoring » Editor for engine jobs » Properties

The properties section defines the main settings for the job. Once a job is created the “Task name”, “Company” and “Compatibility” is specified. “Task name” is the visible job name when you install a job or when its…

Properties on Instances

Advanced Topics » FDL – Farm Data Language » Available properties » Properties on Instances

Instances are available under server through the instance property server/instance All instances have the following properties: Name Description Return type Typical values Extra name The given name of the instance String…

Database link check

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Database link check

Name: Database link check Platform: Oracle Category: Availability Description: Checks database links. Long description: In order to check private database links you have to create a following view ‘create…

Scheduled reports

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

Cached query statistics

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Cached query statistics

Name: Cached query statistics Platform: Sqlserver Category: Performance Description: This task returns aggregate performance statistics based on cached query plans in SQL Server. Long description: This task…

Buffer cache statistics

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for PostgreSQL » Buffer cache statistics

Name: Buffer cache statistics Platform: Postgres Category: Performance Description: Gets data cache statistics from pg_stat_database view. Long description: Task gets data cache statistic from pg_stat_database…

Table and index scan statistics

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for PostgreSQL » Table and index scan statistics

Name: Table and index scan statistics Platform: Postgres Category: Performance Description: This task gathers scan statistics on tables and indexes from pg_stat_all_tables view. Long description: Statistics from…

Worksheet

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

Wait statistics

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Wait statistics

Name: Wait statistics Platform: Oracle Category: Performance Description: Collects waits statistics encountered by threads that executed. This task is based on the v$system_event dynamic performance view. Long…