Search
Related topics are listed below.
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 →
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…
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…
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…
groupby function
Advanced Topics » FDL – Farm Data Language » Functions » groupby function
Description Groups a set on some value(s). Used in combination with aggregate function(s). Example Group the instances by database type, and count the number of instances in each…
difference function
Advanced Topics » FDL – Farm Data Language » Functions » difference function
(Available from september 2023 release) The difference function finds the values that are in set A but not in set B Description Finds the difference of two sets Example Finds the elements in the first set that are not part of the second set. difference( …
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…
The property file format
Customization » Property System » The property file format
Any queriable node in the dbwatch server can have properties. These can be statically set values or dynamically created. This document describes the format used to define dynamic properties. The file header Oracle…
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…
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…
FDL with CCC
Advanced Topics » Control Center Commandline » FDL with CCC
Prerequisites Before running fdl through CCC you need to go through the steps described in Setting up a CCC node First we need to specify the fdl query to execute. This is done by editing the “fdl.script” file. The query is specified after the query?=…
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…
Installation of the Security and Compliance package
Installing and using premium packages » Security and Compliance package » Installation of the Security and Compliance package
Installation of the Security and Compliance package The Security and Compliance package is a premium package that comes with extra cost. If you want to get this package and its not part of your current license, please contact sales@dbwatch.com. To install the…
Adding SQLServer instances with kerberos
Using Control Center » Instance management » Adding a SQLServer Instance » Adding SQLServer instances with kerberos
Using the kerberos authentication option requires some additional setup. We need dbwatch user added to the domain: First we create a dbwatch user that is a normal domain user. We set a passord, and make sure it dont expire. And we must add this user to the…
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…
Autogrow settings
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Autogrow settings
Name: Autogrow settings Platform: Sqlserver Category: Maintenance Description: Checks database files auto-growth settings. Long description: The default auto-grow settings associated with the model database are…
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.…
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…
Report
Customization » Monitoring » Editor for engine jobs » Report
The report section of a job is a lightweight version of the reporting engine in Control Center. It supports SQL queries that can be used in multiple output formats, such as graphs and tables. You can right-click on the “Report” item, add new…
Using SQL Performance package on Oracle
Installing and using premium packages » SQL Performance package » Using SQL Performance package on Oracle
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…
Using SQL Performance package on PostgreSQL
Installing and using premium packages » SQL Performance package » Using SQL Performance package on PostgreSQL
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…
Using SQL Performance package on MySQL
Installing and using premium packages » 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…
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…
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…
Line chart
Customization » Management » Result types » Graphical » Line chart
A line chart example The specification for this chart: select (SELECT cntr_value FROM sys.dm_os_performance_counters where counter_name = 'Index Searches/sec') as "Index Scans", (SELECT cntr_value FROM sys.dm_os_performance_counters where counter_name…
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…
Using SQL Performance package on SQL Server
Installing and using premium packages » SQL Performance package » Using SQL Performance package on SQL Server
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 SQL…
Installation of SQL Performance package
Installing and using premium packages » SQL Performance package » Installation of SQL Performance package
Requirements for installation dbWatch Control Center release 2022-09-29 / 501 or newer License that includes SQL Performance module. It can be as the separate “SQL Performance Package” license or as part of a larger licence package. It is included in…
The FString format
Advanced Topics » The FString format
The FString format. FString is a format created to extract data from complex data structures in order to create well-formed files or strings. The basic FString - Any string is considered an FString. - Any parts of the string starting with ‘{$’ and…
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…
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…
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…
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…
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…
Item active
Customization » Management » Item active
You can hide or disable elements (typically nodes or menu items) by using the item-active tag You can specify multiple item-active tags, and all of them have to resolve to “active” in order for the element to be classified as active. The item-active tag…
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…
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.…
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…
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…
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 (v 5.2 or later). To configure the extension, select it and click “Configure”. You should now see the initial…
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…