Search
Related topics are listed below.
Getting Started
Getting Started
Downloading the latest version of Control Center You can get a download link to the latest version of dbWatch Control Center by registering for a free evaluation copy Wait for dbWatch’s Confirmation Email. Follow the steps and link in that email. There are…
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…
Additional Resources
Additional Resources
Here are an additional resources that might help you. You can check all the FAQS on our website. Go to dbWatch/faq You can access our FAQs on this site. Go to FAQs Section To check our video libarary, you can access the link provided: dbWatch/videos ← Fresh…
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…
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…
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…
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,…
Server memory statistics
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Server memory statistics
Name: Server memory statistics Platform: Sqlserver Category: Performance Description: This tasks collects statistics from the sys.dm_os_sys_info performance view about the memory resources available to and consumed by the…
Customization
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…
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…
Auto-discover with different default port
Using Control Center » Autodiscover » Discovering Database Instances » 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…
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…
Dynamic properties
Customization » Property System » Dynamic properties
Dynamic properties are defined in xml files located in the [dbWatch Server]/server/resources/properties/ catalog. You cannot add files to this catalogue manually, but import them by placing them in the [dbWatch Server]/server/resources/import_area catalog. Examples…
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…
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…
Management
Customization » 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…
Reorganize indexes
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Reorganize indexes
Name: Reorganize indexes Platform: Sqlserver Category: Maintenance Description: Reorganizes fragmented indexes in all databases. Long description: Reorganizing an index uses minimal system resources. It…
Reorganize indexes in table
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Reorganize indexes in table
Name: Reorganize indexes in table Platform: Sqlserver Category: Maintenance Description: Reorganizing fragmented indexes in all tables listed in the ‘table list’ parameter. Long…
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,…
Internal fragmentation check
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Internal fragmentation check
Name: Internal fragmentation check Platform: Sqlserver Category: Maintenance Description: Checks the internal fragmentation for tables and indexes in all databases. The information is extracted from the dynamic management…
Start/stop webservice with CCC
Advanced Topics » Control Center Commandline » Start/stop webservice with CCC
*Not available in general release. You need the 22.03.2024 build or later. *Note: The term service in this context is an internal service in dbWatch, not a Windows service. Prerequisites First you need to go through the steps described in Setting up a CCC node 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.…
Generate Reports
Using Control Center » Reporting » Generate Reports
When you click on Report Module, 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 content, will be shown…
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 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…
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.…
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…
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…
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…
Discovering Database Instances
Using Control Center » Autodiscover » 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…
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…
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…
Reports
Customization » Reports
Before proceeding to this topic, you must be familiar with generating a report. You can check it out by click on the link. Customizing your Report by changing the logo and Company Name To customize, your report. First click “Server” on the upper ribbon of…
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…
FDL – Farm Data Language
Advanced Topics » FDL – Farm Data Language
Introduction to Farm Data Language Farm Data Language or FDL for short is the query language used in dbWatch to find information about objects. FDL is formerly known as DBWQL. This topic should be considered as the advanced part of dbWatch. It is also the central…
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…
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…
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…
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…
Release notes
About dbWatch Control Center » Release notes
dbWatch Control Center (2024-03-11) Download Important note Linux release is available as an apt repository, see Linux install guide All clients and servers need to be upgraded in a multi-server setup before the connection will resume due to network…