Search
Related topics are listed below.
User integration with Active Directory
Using Control Center » Domain Configuration » Managing users » User integration with Active Directory
The user integration with Active Directory offloads the password verification and storage from the dbWatch Control Center domain controller to Active Directory. Port openings To allow the correct communications between the dbWatch Server and the Active Directory…
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…
Active processes
Using Control Center » Management » Management on SQL Server » Server activity » Active processes
Active processes are the current running SQL statements along with statistics. ← Locks / Performance test →
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…
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?=…
Add instance with CCC
Advanced Topics » Control Center Commandline » Add instance with CCC
Prerequisites Before adding instances through CCC you need to go through the steps described in Setting up a CCC node The properties for the instance to add are defined in a file (default is “instance.properties”). The syntax is key/value pairs seperated…
Set metadata with CCC
Advanced Topics » Control Center Commandline » Set metadata with CCC
Prerequisites Before settings metadata through CCC you need to go through the steps described in Setting up a CCC node Metadata is defined in a file (default “metadata.properties”) ← Add instance with CCC / Install jobs with CCC…
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 →
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…
Instance action script with CCC
Advanced Topics » Control Center Commandline » Instance action script with CCC
Instance action script The instance action script (instance_action.script) can do the following commands: Connect You can connect an already registered and disconnected instance using the connect action. It is the same as what happens if you right-click on an…
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…
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…
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…
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…
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…
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 Privilege All instances A list of instances containing all instances added to…
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…
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…
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…
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.…
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.…
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…
Alert log check
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Alert log check
Name: Alert log check Platform: Oracle Category: Availability Description: This check reads and looks for errors in the database alert log. Long description: This check reads and looks for errors in the database…
Listener log check
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Listener log check
Name: Listener log check Platform: Oracle Category: Availability Description: This checks and reads errors from the database listener log. Using Oracle native code to read. Long description: This checks and …
Listener log check (10g)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Listener log check (10g)
Name: Listener log check Platform: Oracle Category: Availability Description: This checks and reads errors from the database listener log. Using Oracle native code to read. Long description: This checks and …
Listener log check (9i)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Listener log check (9i)
Name: Listener log check Platform: Oracle Category: Availability Description: This checks and reads errors from the database listener log. Using Oracle native code to read. Long description: This checks and …
Listener log check (11g)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Listener log check (11g)
Name: Listener log check Platform: Oracle Category: Availability Description: This checks and reads errors from the database listener log. Using Oracle native code to read. Long description: This checks and …
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…
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…
Backup log check (old style 10g)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Backup log check (old style 10g)
Name: Backup log Check 10g (‘old style’ backups) Platform: Oracle Category: Availability Description: Checks for errors in a log file (e.i. backup log). For backups not using RMAN. Long description: …
Backup log check (old style 9i)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Backup log check (old style 9i)
Name: Backup log Check 9i (‘old style’ backups) Platform: Oracle Category: Availability Description: Checks for errors in a log file (e.i. backup log). For backups not using RMAN. Long…
Export log Check (‘old style’ backups)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Export log Check (‘old style’ backups)
Name: Export log Check (‘old style’ backups) Platform: Oracle Category: Availability Description: Checks for errors in a log file (i.e. export log). Long description: Task checks for errors in the…
Alert log check (10g)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Alert log check (10g)
Name: Alert log check Platform: Oracle Category: Availability Description: This check reads and looks for errors in the database alert log. Long description: This check reads and looks for errors in the database…
Alert log check (9i)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Alert log check (9i)
Name: Alert log check Platform: Oracle Category: Availability Description: This check reads and looks for errors in the database alert log. Long description: This check reads and looks for errors in the database…
Disabling and Enabling Views
Using Control Center » Disabling and Enabling Views
You can enable or disable modules from your dbWatch Control Center by unticking their check boxes. If you check Views, you will see the default set up of modules that are visible. Once you disable all the modules, you’ll only be left with the Report Module. …
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…
Alert log check (java for 10g)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Alert log check (java for 10g)
Name: Alert log check (java) Platform: Oracle Category: Availability Description: This check reads and looks for errors in the database alert log. Uses embedded java to read files. Long description: This check…
Alert log check (java)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Alert log check (java)
Name: Alert log check (java) Platform: Oracle Category: Availability Description: This check reads and looks for errors in the database alert log. Uses embedded java to read files. Long description: This check…
Listener log check (java)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Listener log check (java)
Name: Listener log check (java) Platform: Oracle Category: Availability Description: This checks and reads errors in database listener log. Using embedded java to read. Long description: Task checks and reads…
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…
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 →
Stacked area chart
Customization » Management » Result types » Graphical » Stacked area chart
Here is an example of a stacked area chart showing the relationship between active and inactive sessions over time. The specification for this chart: select number_of_processes_active as "Active", number_of_processes_total - number_of_processes_active as…
Performance test
Using Control Center » Management » Management on SQL Server » Server activity » Performance test
Performance test displays statistics gathered from the DML performance test job that runs a performance test on the database instance. ← Active processes / Sessions →
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…
Locks
Using Control Center » Management » Management on SQL Server » Server activity » Locks
Locks view current locks in the database and statistics. There is also a menu to get more session details. ← Blocking sessions history / Active processes →
Session load (8i and 9i)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Session load (8i and 9i)
Name: Session load Platform: Oracle Category: Performance Description: Records the number of active sessions over time. Long description: Task records the number of active sessions over a period of…
Session load
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Session load
Name: Session load Platform: Oracle Category: Performance Description: Records the number of active and inactive sessions over time. Long description: Records the number of active and inactive sessions over…
Memory session load for RAC
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Memory session load for RAC
Name: Memory session load for RAC Platform: Oracle Category: Cluster and Replication Description: Records the load memory of RAC active sessions over time. Long description: Task records the load memory of RAC…
Session load RAC
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Session load RAC
Name: Session load Rac Platform: Oracle Category: Cluster and Replication Description: Records the number of active sessions over time (RAC only). Long description: Task records the number of active sessions…
Instance error log file size check
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Instance error log file size check
Name: Instance error log file size check Platform: Sqlserver Category: Capacity Description: Checks the size og the Instance error log file by using the extended stored procedure xp_cmdshell. Long…
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…
Configuring email extension for Service Now
Customization » Extensions and 3rd party integrations » Email and SMS » Configuring email extension for Service Now
Integration with Servicenow In this example we will configure dbWatch and Servicenow so that alarms from dbWatch, can create incidents in Servicenow. To integrate the alerts from dbWatch with Servicenow incident creation, there are two parts that needs to be setup.…
Category line chart
Customization » Management » Result types » Graphical » Category line chart
A category line chart example The specification for this chart SELECT rtrim(ltrim(instance_name)) "Type", cntr_value "Value" FROM sys.dm_os_performance_counters where counter_name like 'Lock Requests/sec%' and instance_name in ( select top 6…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
replace function
Advanced Topics » FDL – Farm Data Language » Functions » replace function
Description Replaces all occurences of string A with string B in a string. Example Replace all occurences of “abc” with “def” in instance names. instance/name/replace("abc", "def") Syntax expression1/replace(expression2,…
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…
Web dashboard editor (beta)
Customization » Web server » Web dashboard editor (beta)
Web dashboard editor (currently in beta) Web dashboard editor is an additional addon module to dbWatch Control Center, that allows the customer to create their own dashboards displaying data about their database environment. While it is in beta, it is open for…
FDL console
Using Control Center » FDL console
See FDL – Farm Data Language ← Auto-discover with different default port / Reporting →
Adding an Oracle Instance
Using Control Center » Instance management » Adding an Oracle Instance
Oracle Prerequisites !1. Oracle databases need to have a listener process running and also allow for an external login with sysdba user or user with enough privileges. 2. You need a privileged user, such as sys as sysdba, another user with sysdba privileges or…
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…
Schedule
Using Control Center » Monitoring » Job concepts » Schedule
The scheduling in Control Center has two modes, cron schedule, and interval schedule. Cron schedule The cron schedule is loosely based on the crontab format used on Unix systems. We have 4 fields that can be set, “Minute”, “Hour”,…
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”…
Licensing terms
Licensing terms
dbWatch End User License Agreement 1. PARTIES This License and Services Agreement (“Agreement”) is between dbWatch AS, organization number 991 500 456 Norway (“dbWatch”), and the Customer, which is the entity or person whose name and contact details as it…
Security and Compliance package
Installing and using premium packages » Security and Compliance package
Security and Compliance package The Security and Compliance package is an optional extra cost module in dbWatch Control Center that allows automated detection and reporting on security and compliance-related issues where database instances are not conforming to best…
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…
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…
Data file size check
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Data file size check
Name: Data file size check Platform: Sqlserver Category: Capacity Description: Checks the remaining space for all databases where the data files are set with limited growth rate (max size not unlimited). Long…
Data file size check (MS2000)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Data file size check (MS2000)
Name: Data file size check Platform: Sqlserver Category: Capacity Description: Checks the remaining space for all databases where the data files are set with limited growth rate (max size not unlimited). Long…
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…
Properties
Customization » Monitoring » Editor for engine jobs » Properties
The properties section defines the main settings for the job. Once a job is created the “Task name”, “Company” and “Compatibility” is specified. “Task name” is the visible job name when you install a job or when its…
TNSping check
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » TNSping check
Name: TNSping check Platform: Oracle Category: Availability Description: Checks TNSping connectivity on listed targets. Task requires ‘java’ support. Supports Linux/Unix and Windows, will react with an alarm if…
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…
Using OS Authentication
Using Control Center » Instance management » Adding a SQLServer Instance » Using OS Authentication
When connecting to Microsoft SQL Server instances it is possible to login with Windows Authentication (called OS Authentication in dbWatch). The accout used is the same account as the dbWatch Control Center service runs as. Per default the dbWatch Control Center…
orderby function
Advanced Topics » FDL – Farm Data Language » Functions » orderby function
Description Orders the rows in a set, with an optional limit on the number of rows to return Example Find the 10 instances with the highest number of sessions instance->i{}/total_session_count/orderby('desc', 10) Order the instances based on…
Collation check
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Collation check
Name: Collation check Platform: Sqlserver Category: Availability Description: Checks if there is a collation conflict with temp tables and table variables. Long description: You may get a collation conflict when…
Product Security
Advanced Topics » Product Security
Introduction on dbWatch Control Center regarding product security dbWatch AS has implemented reasonable administrative, technical and physical safeguards to help protect against security incidents and privacy breaches involving a dbWatch product, provided those…
Reporting
Using Control Center » Reporting
Control Center comes bundled with a series of report templates that you can use to generate standard reports on various aspects of your database environment. It also allows you to edit the templates or create your own for fully customizable reporting which will be…
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…
Defining Autodiscover Ports
Using Control Center » Autodiscover » Discovering Database Instances » Defining Autodiscover Ports
By default autodiscover scans the following ports: MS SQL Server: 1433 Oracle: 1520, 1521, 1522, 1523, 1524, 1526, 1527 Sybase: 4998, 4999, 5000, 5001, 5002 MySQL: 3304, 3305, 3306, 3307, 3308 PostgreSQL: 5429, 5430, 5431, 5432, 5433, 5434 You can override the…
Control Center Jobs
Using Control Center » Monitoring » Control Center Jobs
Jobs (older dbWatch versions Tasks and alerts) are the cornerstone of the dbWatch Monitoring module. Jobs perform the actual monitoring of the database instance. There are two types of Monitoring in dbWatch. The Basic and Standard monitoring. To see each monitoring…
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…
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…
Management
Using Control Center » Management
In this section, we’ll be familiarized with how the Management Module works. Examples in this documentation are from Microsoft SQL Server, but this is available on all platforms, however, contents are platform and license dependent. When opening the management…
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…
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…