Search
Related topics are listed below.
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…
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…
Backup of dbWatch
Troubleshooting Guide » Backup of dbWatch
When we think about backup of dbWatch, this involves several different parts of the software and installation: dbWatch Server and configuration files dbWatch Server places its configuration files and workarea in “C:\ProgramData\dbWatchControlCenter\” by…
dbWatch engine alert
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » dbWatch engine alert
Name: dbWatch engine alert Platform: Sqlserver Category: Internal Internal Description: This procedure gathers statistics per database. Long description: This alert returns warning/alarm if there are several…
dbWatch engine alert
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for PostgreSQL » dbWatch engine alert
Name: dbWatch engine alert Platform: Postgres Category: Internal Description: Collects database uptime statistics. Long description: Version: 1 Default schedule: 15m Requires…
High activity monitor
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » High activity monitor
Name: High activity monitor Platform: Sqlserver Category: Performance Description: Collects SQL instance CPU usage, CPU usage of other processes, logical and physical reads, and active processes count on the SQL Server…
Data cache monitor
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Sybase » Data cache monitor
Name: Data cache monitor Platform: Sybase Category: Performance Description: Collects data cache statistics based on the dbWatch tasks ‘System monitor collector’ which runs the ‘dbcc monitor’ utility…
Disk activity monitor
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Sybase » Disk activity monitor
Name: Disk activity monitor Platform: Sybase Category: Performance Description: Collects statistics created by the ‘System monitor collector’ task. Long…
Engine CPU monitor
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Sybase » Engine CPU monitor
Name: Engine CPU monitor Platform: Sybase Category: Performance Description: Collects counter values for busy io and busy cpu, and are based on the dbWatch tasks ‘System monitor collector’ which runs the…
System monitor collector
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Sybase » System monitor collector
Name: System monitor collector Platform: Sybase Category: Performance Description: This task collects statistics by running the ‘dbcc monitor’ utility which is also a part of the stored procedure sp_sysmon. It…
dbWatch Server activity alert
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » dbWatch Server activity alert
Name: dbWatch Server activity alert Platform: Sqlserver Category: Internal Internal Description: This procedure gathers statistics per database. Long description: This alert returns warning/alarm if the dbWatch…
Properties on dbWatch Servers
Advanced Topics » FDL – Farm Data Language » Available properties » Properties on dbWatch Servers
The available properties for server are: Name Description Return type Typical values Extra name, displayname The name of the dbWatch Server Entity dbWatch Control Center instance All the instances…
About dbWatch Control Center
About dbWatch Control Center
dbWatch Control Center is a highly scalable software solution that helps enterprises monitor and manage large database servers efficiently, providing total control over all database operations, performance, and resource usage. dbWatch Control Center will give you the…
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…
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…
High activity monitor (MS2005)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » High activity monitor (MS2005)
Name: High activity monitor Platform: Sqlserver Category: Performance Description: Collects SQL instance CPU usage, CPU usage of other processes, logical and physical reads, and active processes count on the SQL Server…
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.…
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 →
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.…
Supported Web Browsers for dbWatch Dashboard
Customization » Web server » Supported Web Browsers for dbWatch Dashboard
As of the current version, dbWatch Dashboard supports the following web browsers: Google Chrome Microsoft Edge Firefox Why These Browsers? Our focus on Google Chrome and Microsoft Edge is driven by several factors: Advanced Features and Standards These…
Monitor dashboards and overview screens
Product Overview » Monitor dashboards and overview screens
Being effective in database operations are one of the key focus areas for the dbWatch database operations team. This chapter will focus on the dashboards or overview screens used by our internal database operations team, what information they show, how they are used…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
Installing on Windows
Getting Started » Installing on Windows
dbWatch Server Prerequisites Windows Server (VMWare virtual server or AWS EC2 supported) Windows Server 2008, 2012, 2016, 2019, and 2022 Windows 10 or Windows 11 8 GB RAM 4 CPU cores 10 GB hard drive space dbWatch Engine Prerequisites 500 Mb free space in…
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…
Installing and using premium packages
Installing and using premium packages
Additional packages dbWatch Control Center also provides additional premium packages to cover specific areas. They may be specific only to one or a few of the platforms supported by dbWatch Control Center. More details are found on the pages specific to the package.…
Product Overview
Product Overview
Product Overview In Product Overview, we will look into architecture and structure and give an overview of how the application operates. Chapters: Architecture File Structure Network and communications Database Operations Philosophy Monitor Dashboards and…
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…
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…
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…
Find your version
About dbWatch Control Center » Find your version
Checking dbWatch Version To check your current dbWatch version, you can: 1. See it in the upper portion of your application. 2. Open Help > About dbWatch or click on the dbWatch Icon: You’ll see a window showing you the current version of dbWatch Control…
Application Modules
Advanced Topics » Application Modules
About application modules The dbWatch framework is easy to extend and expand with tasks, alerts, reporting and administration to support specific applications. An application module is a bundle of tasks, alerts, reports and administration xml files to allow dbWatch to…
Product Description
Advanced Topics » Product Security » Product Description
Product Description dbWatch Control Center is a database operations software intended to monitor, manage, maintain and report on database instances across multiple database platforms and physical locations. A dbWatch Control Center environment has at its core a…
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…
Integration with SSMS
Installing and using premium packages » SQL Performance package » Using SQL Performance package on SQL Server » Integration with SSMS
When analyzing a SQL statement, the choice “Show query plan (using SSMS)” appears on SQL Server. This is for opening a query plan in SQL Server Management Studio. Clicking on this will not open anything, if it is not setup correctly. There is a monitor.xml…
Initial Domain Setup
Getting Started » Initial Domain Setup
All dbWatch Servers are part of a domain. This domain is unique for each customer and it is specified in the dbWatch license. Every dbWatch installation must have one of the dbWatch Servers specified as the Domain Controller. The first time a you start the dbWatch…
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…
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…
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…
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 →
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…
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…
Graphical installation on Ubuntu
Before you start The installer for dbWatch Control Center requires root to run. However, when we want to run the software under a different user once installed. I will run all the first steps as user root for documentation simplicity. You can use sudo instead. This…
SQL statistics (CDB)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » SQL statistics (CDB)
Name: SQL statistics Platform: Oracle Category: Performance Extra cost package: SQL Performance package Description: Collects SQL statements statistics (for container database) from V$SQLAREA and V$SQL_PLAN…
SQL statistics (PDB)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » SQL statistics (PDB)
Name: SQL statistics Platform: Oracle Category: Performance Extra cost package: SQL Performance package Description: Collects SQL statements statistics (for pluggable database) from V$SQLAREA and V$SQL_PLAN…
Example engine jobs
Customization » Monitoring » Editor for engine jobs » Example engine jobs
Example jobs To simplify development efforts for customers we provide example jobs with comments that should help development efforts. To use, right-click on the link and save as. Make sure its an xml file, with the name you want. You can edit it as its xml to change…
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$…
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”…
Auto-discover with different default port
Using Control Center » Autodiscover » Auto-discover with different default port
We’ll look deeper into how auto-discover works. First of all, you need to be familiar with what file the data is being stored in. The default directory can be found in “C:\ProgramData\dbWatchControlCenter\config\server” and it’s in file…
Encryption
Advanced Topics » Product Security » Encryption
Encryption Data packages sent between server nodes and monitor clients are end-to-end encrypted with the node certificate. The encryption used for this is AES/GCM (256bit keys). This is possible to verify if you click on Help->Debug->Connection info For…
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…
Memory statistics
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Sybase » Memory statistics
Name: Memory statistics Platform: Sybase Category: Performance Description: Collects memory statistics based on the dbWatch tasks ‘System monitor collector’ which runs the ‘dbcc monitor’ utility…
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…
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…
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 →
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 →
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…
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…
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.…
[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 →
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…
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,…
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…
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…
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…
[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) →
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 →
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…
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…
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…
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…
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…
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 →
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…
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…
Release notes
About dbWatch Control Center » Release notes
dbWatch Control Center (2024-11-26) Download New features DBW – Bulk setting of SQL Worksheet authentications DBW – SQL Worksheet query timeout parameter DBW – AD integration now handles LDAP Signing DBW – CCC can now connect to non DC…
Cloud router
Product Overview » Architecture » Cloud router
Introduction The dbWatch Control Center is structured around a network of nodes dedicated to managing server infrastructure. While these nodes effectively communicate within a single network, cross-network communication poses a unique challenge. To address this, we…
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…