dbWatch AS

Search

The topic you requested could not be found.
Related topics are listed below.

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?=…

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…

Console installation on Ubuntu

Getting Started » Installing on Linux » Console installation on Ubuntu

Before You Start Before installing the dbWatch Control Center, note that the installer requires root privileges. For simplicity, this documentation demonstrates steps executed as the root user. You may use ‘sudo’ as an alternative. This guide is for…

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…

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…

Installing and using premium packages

Installing and using premium packages

Premium 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.…

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…

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…

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…

Defining Autodiscover Ports

Using Control Center » Autodiscover » 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…

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…

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…

Property System

Customization » Property System

There are several types of properties in dbWatch. Predefined properties Predefined properties are always present. For example, instances have properties called name and host. For more details see available properties Metadata properties Metadata properties are…

Tree navigation

Using Control Center » Monitoring » Tree navigation

On the left side of the dbWatch monitor, you will see a tree structure. There are 2 component that lets your group and filter instances. Top level of the tree, there is a “Grouping” panel. Below it is a quick text based filter. Grouping This is always…

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…

Advanced Topics

Advanced Topics

For this section, we’ll be focusing on Farm Data Language and other topics you may find interesting. ← Anonymous webaccess / FDL – Farm Data Language →

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…

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.…

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…

No-engine jobs

Using Control Center » Monitoring » Job concepts » Job types » No-engine jobs

No-engine jobs No-engine jobs consists of a series of steps (defined in xml files), and each step retreives data and/or performs some computation on the data. The last step will also set a status and a text describing the current state of the job. The steps can be a…

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…

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…

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…

Web data export

Customization » Web server » Web data export

You can export data from dbWatch through http for easy access by others (tools or humans). Data can be made available formatted as json or csv. Data export might require anonymous webaccess configured. Any data formatted as a table in the dashboard will support data…

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…

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…

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…

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…

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…

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…

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…

Functions

Advanced Topics » FDL – Farm Data Language » Functions

Functions in FDL Numeric functions Function name Description add Adds a number to a base value sub Substracts a number from a base value div Diveds a number mult Multiplies a number …

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…

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…

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…

SQL Performance package

Installing and using premium packages » SQL Performance package

SQL Performance package SQL Performance module is an optional extra cost module in dbWatch Control Center that allows for historical monitoring and analysis of SQL Statements in the database instance. Currently supported platforms: MS SQL Server 2014 and…

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…

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…

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…

Listener log check (java 10g)

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Listener log check (java 10g)

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…

Backup job – pg_dump_all (ssh)

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for PostgreSQL » Backup job – pg_dump_all (ssh)

Name: Backup job – pg_dump_all (ssh) Platform: Postgres Category: Maintenance Description: Runs a backup of all the postgres databases on an instance using pg_dumpall through an ssh connection. Long…

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…

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…

Contained database credentials

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Contained database credentials

Name: Contained database credentials Platform: Sqlserver Category: Security Premium package: Security and compliance package Description: Checks if the database users in contained databases are using database…

Database backup (system databases)

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database backup (system databases)

Name: Database backup (system databases) Platform: Sqlserver Category: Availability Description: This procedure analyzes the FULL backup statistics for the system databases (master, model and msdb) using data from the…

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…

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…

Autodiscover

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…

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…

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…

Javascript property

Customization » Property System » Javascript property

From dbWatch 12.2.1, one of the engines available in properties is javascript. Example that sums each column from an sql result: scripttest instance[databasetype='sqlserver'] select 1, 2, 3 5s In the javascript code there are two…

SQL Worksheet

Using Control Center » Management » Management on SQL Server » SQL Worksheet

SQL Worksheet allows for direct SQL commands on the database instance. ← Audit / Worksheet →

Backup log check (old style 8i)

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Backup log check (old style 8i)

Name: Backup log Check 8i(‘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…

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…

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 →

Listener log check (8i)

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Listener log check (8i)

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 …

Availability

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by category » Availability

Jobs in the Availability category Control Center Jobs Description Oracle 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…

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…

Buffer cache reads per database

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for PostgreSQL » Buffer cache reads per database

Name: Buffer cache reads per database Platform: Postgres Category: Performance Description: Collects the number of block fetch requests for table or index per database. Long description: Collects the number of…

Disk block reads per database

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for PostgreSQL » Disk block reads per database

Name: Disk block reads per database Platform: Postgres Category: Performance Description: Collects the number of disk block fetch requests for table or index per database. Long description: Collects the number…

Sessions performance

Using Control Center » Management » Management on SQL Server » Sessions performance

The Sessions performance view is part of the SQL performance package, which 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 ← Sessions history / Disk…

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 …

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…

CPU load

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » CPU load

Name: CPU load Platform: Oracle Category: Performance Description: Checks CPU load using Oracle performance view v$osstat. Long description: Checks and collects CPU load statistics. The task also aggregates…

Instance error log

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Instance error log

Name: Instance error log Platform: Sqlserver Category: Availability Description: Reads and checks the Instance error log file by using the sp_readerrorlog stored procedure. Long description: The sp_readerrorlog…

Disk space check

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Disk space check

Name: Disk space check Platform: Sqlserver Category: Capacity Description: Checks the amount of free space on the available disk drives. Long description: Checks the amount of free space on the available disk…

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…

Engine jobs

Using Control Center » Monitoring » Job concepts » Job types » Engine jobs

Engine jobs Each engine Job consists of a set of objects (procedures, tables, etc) that are installed on the monitored database instance. The main procedure will be triggered by the dbWatch Server, This procedure will then perform a check or collect statistics…

Instance error log (AWS)

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Instance error log (AWS)

Name: Instance error log (AWS) Platform: Sqlserver Category: Availability Description: Reads and checks the Instance error log file by using the AWS rdsadmin.dbo.rds_read_error_log stored procedure. Long…

Disk space check (noschema)

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Disk space check (noschema)

Name: Disk space check Platform: Sqlserver Category: Capacity Description: This procedure collects space usage in all filegroups defined in each database. The undocumented ‘sp_MSforeachdb’ Stored Procedure is…

Sensitive Data Transmitted

Advanced Topics » Product Security » Sensitive Data Transmitted

Sensitive Data Transmitted dbWatch Control Center will, by its nature log into database instances and run queries on the database instances it manages. Key data accessed is primarily data related to statistics on the behavior of the database instance, and not actual…

Network Controls

Advanced Topics » Product Security » Network Controls

Network Controls dbWatch Control Center deploys several methods of network control. 1. Node authentication (clients and servers) using certificate infrastructure built up around the Domain CA system 2. The built-in firewall to restrict incoming connections on an IP…

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…

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…

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…

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…

Cloud router security

Product Overview » Architecture » Cloud router » Cloud router security

Introduction Robust Security Despite Exposure to Threats: Designed for internet accessibility, the cloud router operates under the assumption that it could be compromised. This perspective has shaped its security architecture to ensure that users remain protected,…

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…

Jobs for Oracle

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle

Control Center Jobs Description Agresso (part of the Agresso Application Package) Agresso reports queue Monitors and checks pending or running reports. Returns warning or alarm if the elapsed time exceeds defined…

Edit Report Templates

Using Control Center » Reporting » Edit Report Templates

Report Selection When you click on Server -> “Reporting” on the toolbar and then select “Edit Report Template”, you will see a list of all available report templates. Select the report template you wish to edit and click “OK”.…

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…

Report

Using Control Center » Monitoring » Job concepts » Report

Each job has a job report that is generated when you use the job menu and choose “Details”. The job report, here an example from the CPU load details on Oracle, provides a set of graphs, pie charts, and tables. It uses previously generated history…

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…

Renamed sa account

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Renamed sa account

Name: Renamed sa account Platform: Sqlserver Category: Security Premium package: Security and compliance package Description: Checks if the standard ‘sa’ login account (principal_id=1 and…

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…

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…

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…

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…

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…

Agent error log

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Agent error log

Name: Agent error log Platform: Sqlserver Category: Availability Description: Reads and checks the Agent error log file by using the sp_readerrorlog stored procedure. Long description: The sp_readerrorlog stored…

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…

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…