Search
Related topics are listed below.
Dataguard startup time
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Dataguard startup time
Name: Dataguard startup time Platform: Oracle Category: Cluster and Replication Description: Checking startup time on dataguard standby nodes Long description: Version: 1.0 Default…
Configuration
Using Control Center » Management » Management on SQL Server » Configuration
Configuration gives an overview of the current setup of the database instance, including parameters and uptime statistics. ← dbWatch alerts / Parameters →
Web configuration
Customization » Web server » Web configuration
To enable the Web server, go to the “Server” -> “Domain Configuration” menu. Expand the domain, Nodes, Server, and right-click on the server you want to run the webserver on. Select “Edit webserver” In the Configure…
Groups Configuration
Using Control Center » Instance management » Groups Configuration
How to get here You can access the group configurations going to Server —> Server Configuration —> Group Configuration. Overview The Group Configuration view consists of two main parts. On the left side you can see a tree structure showing the groups,…
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…
Configuration parameters
Customization » Monitoring » Editor for engine jobs » Configuration parameters
Configuration parameters are the parameters a user can use to control the behavior of a job. This can be thresholds for alerting, items to ignore, and other types of adjustments that make it easy to create a good fit between a standardized job and a custom database…
Domain Configuration
Using Control Center » 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 are: Domain – Lets you configure domain…
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…
Get instance configuration with CCC
Advanced Topics » Control Center Commandline » Get instance configuration with CCC
Prerequisites Before you can get instance configuration through CCC you need to go through the steps described in Setting up a CCC node Getting instance configuration get_instance.script has the following input parameters: server – specify server IP and port,…
Register instance configuration with CCC
Advanced Topics » Control Center Commandline » Register instance configuration with CCC
Prerequisites Before you can get instance configuration through CCC you need to go through the steps described in Setting up a CCC node Registering instance configuration register_instance.script has the following input parameters: server – specify server IP…
Exporting configuration from 12 to CC
Advanced Topics » Exporting configuration from 12 to CC
Exporting database instance configuration from dbWatch 12 to CC A version of 12.9.1 or above is needed for this. The idea is that you can export the instance configuration from a dbWatch 12.9.x installation to install the same instances in dbWatch Control Center, as…
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…
Cluster and replication
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by category » Cluster and replication
Jobs in the Cluster and replication category Control Center Jobs Description Oracle Blocking detector for RAC Checks if a session is waiting on a TX (transaction) lock. (RAC only) Memory session load for RAC Records the…
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…
Changing Instance Group
Using Control Center » Instance management » Groups Configuration » Changing Instance Group
Changing a group can be done when you created an instance under a default group name and change it to another corresponding group. To change the groups base on your newly created group, you can check Group Configuration. Changing Group of an Instance Once a group has…
Adding or changing license
Using Control Center » Domain Configuration » Adding or changing license
Adding or changing license To add or change the license, you need to start the domain configuration window. (Server->Domain Configuration) In this window, click on “Upload license” and point it to the license .json file you received from dbWatch.…
[Database name] (database server)
Using Control Center » Management » Management on SQL Server » Configuration » Uptime statistics » [Database name] (database server)
This gives an overview of up and down periods for the database server. You can right-click on the screen to switch between different ways to display uptime: Like uptime per week: ← Uptime statistics / (instance) →
Maintenance periods
Using Control Center » Management » Management on SQL Server » Configuration » Uptime statistics » Maintenance periods
This is where you can add maintenance periods to correct the uptime report for known scheduled maintenance periods that should not count as part of the report. Right click on the maintenance periods to create a new known maintenance period. This allows you fine…
Parameters
Using Control Center » Management » Management on SQL Server » Configuration » Parameters
First the basic parameters are showed. You can right_click on any of these to configure new values. ← Configuration / Advanced dynamic parameters →
Service groups
Using Control Center » Instance management » 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…
[Instance name] (instance)
Using Control Center » Management » Management on SQL Server » Configuration » Uptime statistics » [Database name] (database server) » [Instance name] (instance)
This gives an overview of when the database instance has been up or down. ← [Database name] (database server) / Maintenance periods →
Uptime statistics
Using Control Center » Management » Management on SQL Server » Configuration » Uptime statistics
Control Center provides uptime statistics reports, and this is the interface to look at uptime periods for an instance and add scheduled maintenance periods that will be taken into consideration when uptime statistics is generated for this report. ← Registry…
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…
Web server
Customization » Web server
Control Center can be configured to serve dynamic web content over http. This is intended for dashboards or live reports, and for data export used for integration purposes. Webserver configuration Webserver setup Configuring anonymous webaccess Mountable web…
Anonymous webaccess
Customization » Web server » Anonymous webaccess
Configuring Anonymous Web Access in dbWatch This guide outlines the updated process for configuring anonymous web access in dbWatch. The configuration is now managed through the ‘tuning.properties’ file, which simplifies the setup process. Step 1: Create…
Registry parameters
Using Control Center » Management » Management on SQL Server » Configuration » Registry parameters
Registry parameters are primarily directory defaults that are saved in the registry. You can change these by right-clicking and choosing configure. ← Advanced static parameters / Uptime statistics →
Advanced dynamic parameters
Using Control Center » Management » Management on SQL Server » Configuration » Parameters » Advanced dynamic parameters
Advanced dynamic parameters are more advanced, but they can be configured by right-clicking and choosing configure. They take effect immediately. ← Parameters / Advanced static parameters →
Advanced static parameters
Using Control Center » Management » Management on SQL Server » Configuration » Parameters » Advanced static parameters
Advanced static parameters will need an instance restart to take effect. You can configure these by right-clicking on the parameter and choose configure. ← Advanced dynamic parameters / Registry parameters →
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…
Install jobs with CCC
Advanced Topics » Control Center Commandline » Install jobs with CCC
Prerequisites Before installing jobs through CCC you need to go through the steps described in Setting up a CCC node ← Set metadata with CCC / Get instance configuration with CCC →
Control Center Commandline
Advanced Topics » Control Center Commandline
CCC.exe – the Control Center Commandline CCC.exe is a command intended to run on the commandline or terminal to trigger USL scripts. The intention of CCC is to use it for integration and automation purposes to access the capabilities of dbWatch for other 3rd…
Internal Control Center firewall
Advanced Topics » Internal Control Center firewall
The internal firewall Mostly used for advanced configurations, where nodes are placed in locations facing internet traffic, there is a built-in firewall in Control Center. You access the firewall configuration in the domain configuration dialog for each node.…
External dependencies
Customization » Monitoring » Editor for engine jobs » External dependencies
External dependencies are used to add dependencies to external tables, views, functions, and procedures. External in this setting is external to, as not part of, this job. It can be external objects, such as tables and procedures that the procedures in this job…
Log shipping monitor (secondary)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Log shipping monitor (secondary)
Name: Log shipping monitor (secondary) Platform: Sqlserver Category: Cluster and Replication Description: Monitor the secondary database in each log shipping configuration. Long description: Monitor the…
Troubleshooting Guide
Troubleshooting Guide
In this section, we’ll discuss about: dbWatch Backup Restoring Configuration Backup Fault Finding Guide Issues and Troubleshooting Definition Mapping ← Internal Control Center firewall / Backup of dbWatch →
Log shipping monitor (primary)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Log shipping monitor (primary)
Name: Log shipping monitor (primary) Platform: Sqlserver Category: Cluster and Replication Description: Monitor the primary database in each log shipping configuration, including information about the last backup file and…
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…
Certificate infrastructure
Advanced Topics » Product Security » Certificate infrastructure
Certificate infrastructure Domain root The root certificate of the domain. In order to be trusted by external domains this certificate must be signed by dbWatch. User identity certificate This certificate is used by the domain to sign user certificate…
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…
Database disk capacity
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database disk capacity
Name: Database disk capacity Platform: Sqlserver Category: Capacity Description: Checks free space on drives where data and transaction log files are defined. An alarm (or warning) is raised if the percentage limit is…
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…
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…
Dashboards
Customization » Web server » Dashboards
Dashboard overview The main page for the dashboards: User and login To view dashboards, you need to login with a user that has at least read privileges on web. Default dashboards These are the default dashboards: Instance status: This dashboard…
Managing roles
Using Control Center » Domain Configuration » Managing roles
Roles In the roles configuration you can add, delete and configure roles. In this example we have created a “Dev” role that has Read, Write and Configure on the security group “Test instances”, aswell as “Read” on “Dev…
Creating a user
Using Control Center » Domain Configuration » Managing users » Creating a user
To create a user, right click on the “Users” element in the tree in Domain Configuration This will open the add user dialog: Where you add a username and password: If you want to add a user that uses Active Directory for password verification,…
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…
Multi-server setup
Getting Started » Multi-server setup
Multi-server setup In most setup one dbWatch Server serve all the roles, where the most common are Domain CA, Instance hub and Webserver. However, in more complex environments more than one dbWatch Server will be connected in one domain, where one server has the role…
Managing security groups
Using Control Center » Domain Configuration » Managing security groups
Security groups This is were you define the groups that users and roles can have privileges on. There are some predefined security groups: Security group name Description All Instances A group containing all instances in this dbWatch…
Job templates
Customization » Monitoring » Job templates
Creating templates Template functionality makes it possible to automate installation and configuration of jobs across the entire database farm you are managing. The configuration interface is available in the menu Server -> Server Configuration -> Edit job…
Email and SMS
Customization » Extensions and 3rd party integrations » 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. To configure the extension, select it and click “Configure”. You should now see the initial configuration screen…
SQL performance
Using Control Center » Management » Management on SQL Server » SQL performance
SQL performance is an extra cost module, that might not be available if your license has not enabled it. For more details look at the documentation for this module here ← Maintenance periods / Internal repository →
User integration with Active Directory
Using Control Center » Domain Configuration » Managing users » User integration with Active Directory
Overview Integrating dbWatch Control Center with Active Directory (AD) enables centralized authentication and management. This guide outlines the steps required to configure dbWatch for AD integration, including file setup and certificate import. The integration uses…
User connections check
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Sybase » User connections check
Name: User connections check Platform: Sybase Category: Performance Description: Checks the configuration setting of the ‘number of user connections’ from the master.dbo.syscurconfigs table against the number of…
User connections check (12)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Sybase » User connections check (12)
Name: User connections check Platform: Sybase Category: Performance Description: Checks the configuration setting of the ‘number of user connections’ from the master.dbo.syscurconfigs table against the number of…
Security and Compliance package on SQL Server
Installing and using premium packages » Security and Compliance package » Security and Compliance package on SQL Server
The Security and Compliance package The Security and Compliance package provides a detailed evaluation of your Microsoft SQL Server’s security and compliance, managed via dbWatch Control Center. It offers in-depth insights into your server’s security and…
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…
Management on SQL Server
Using Control Center » Management » Management on SQL Server
When opening the management module in its initial state, you get the status dashboard: This will give an overview of the system, displaying some instance information, the largest databases, logical reads, session load, and memory usage. When a graph indicates…
Release notes
About dbWatch Control Center » Release notes
dbWatch Control Center (2024-10-07) Download Improvements MS SQL Server – Job “Database disk capacity”. New parameter “combine thresholds”. This parameter allows you to combine the conditions of both the “alarm threshold…
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.…
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…
Upgrade
Customization » Monitoring » Editor for engine jobs » Upgrade
When you add upgrade/implementation steps you get prompted for “Version”, and that is a comma-separated list of versions that this implementation can upgrade from. It is always to the current version. You can use the configuration parameters to create…
Using Control Center
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…
Instance management
Using Control Center » Instance management
In instance management we focus on the process of adding, removing and managing instances and instance groups. You will need to add database instances to dbWatch Control Center in order to monitor, manage and create reports from your database instances. There are 4…
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…
Check database recovery mode
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Check database recovery mode
Name: Check database recovery mode Platform: Sqlserver Category: Availability Description: Checks if all databases are running in FULL or SIMPLE recovery mode. Long description: Checks if all databases are…
Managing nodes
Using Control Center » Domain Configuration » Managing nodes
Nodes In the node configuration there are 2 editable fileds. The displayname and the approved checkbox. This is were you approve new Servers that want to join the domain. In addition you can see the type (currently server and/or domaincontroller) and id for the…
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…
Network Ports and Services
Advanced Topics » Product Security » Network Ports and Services
Network Ports and Services 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. If enabled the webserver can run. Default port is 8080. On each…
Jobs for Oracle
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle
Control Center Jobs Description Availability Alert log check This check reads and looks for errors in the database alert log. Alert log check This check reads and looks for errors in the database alert log. Alert…
2 factor authentication
Using Control Center » Domain Configuration » Managing users » 2 factor authentication
dbWatch offers 2 factor authentication through a TOTP (Time-Based One Time Password) mechanism. Tou can use your favourite authenticator for this. For example Google Authenticator or Microsoft Authenticator. To enable 2 factor authentication for your own user, you…
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.…
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…
Upgrade dbWatch
Using Control Center » Domain Configuration » Upgrade dbWatch
If you have dbWatch version 2023-06-27 or later, it is possible to semi automatically upgrade the dbWatch Servers. *Only available for Windows Servers. For linux, look here. In the Domain Configuration dialog, select the Upgrade tab. Click on the Check button to…
Automated maintenance package
Installing and using premium packages » Automated maintenance package
Automated Maintenance Package The Automated Maintenance Package is an additional package for dbWatch Control Center, designed to streamline routine database maintenance tasks. By automating essential upkeep, this package helps ensure optimal database performance and…
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…
Properties on Internal
Advanced Topics » FDL – Farm Data Language » Available properties » Properties on Internal
Internal is available under server through the internal property server/internal The available properties are: Name Description Return type Typical values Extra installdir The dbWatch Server installation directory Entity…
Jobs for Sybase
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Sybase
Control Center Jobs Description Availability Database backup Checks backup status of all databases. Database status Checks status of all databases defined on the system. The following incidents triggers a warning or an…
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…
Bulk installing instances
Using Control Center » Instance management » Bulk installing instances
CSV File Format You can add instances in bulk. The prerequisite is to have a CSV file with the following…
Managing users
Using Control Center » Domain Configuration » Managing users
A user can have roles and grants. A grants is set of privileges on a “Security group”, while roles are a set of grants or other roles or security groups. A “Security group” is a set of database instances and/or servers. Four roles are…
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…
Metadata properties
Customization » Property System » Metadata properties
You can put metadata on instances, and this metadata will be automatically available in FDL. 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…
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.…
Setting up a CCC node
Advanced Topics » Control Center Commandline » Setting up a CCC node
To setup a ccc node you first need to download the ccc scripts and extract them in a catalog that you want to be the ccc workarea. In the following example we have downloaded the scripts to “E:/tmp/scripts” and our Control Center installation is located in…
Installing on Linux
Getting Started » Installing on Linux
dbWatch Server 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…
Node to Node communication
Advanced Topics » Product Security » Node to Node communication
dbWatch Control Center is composed of a set of nodes that speak to each other using a layered protocol. This document describes these layers and how they interact to achieve security and reliability. The dbWatch monitor is also a node and has all the behavior…
Properties on Jobs
Advanced Topics » FDL – Farm Data Language » Available properties » Properties on Jobs
Jobs are available under instance through the task property server/instance[name = '...']/task The available properties are: Name Description Return type Typical values Extra name The name of the job String Blocking…
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…
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…
Repository management and monitoring
Installing and using premium packages » 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…
Jobs for MS SQL Server
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server
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. Agent Jobs Check for MS2000 Checks whether there…
Performance
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by category » Performance
Jobs in the Performance category Control Center Jobs Description Oracle Blocking detector Checks if a session is waiting on a TX (transaction) lock. Buffer cache statistics Gets data cache statistics for buffer cache in…
Capacity
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by category » Capacity
Jobs in the Capacity category Control Center Jobs Description Oracle ASM disk statistics Checks ASM disks for status and statistics. ASM diskgroup space Checks ASM diskgroups space statistics. Monitor SYS.AUD$…