Search
Related topics are listed below.
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…
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…
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…
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…
Supported Web Browsers for dbWatch Dashboard
Customization » Web server » Supported Web Browsers for dbWatch Dashboard
As of the current version, dbWatch Dashboard supports the following web browsers: Google Chrome Microsoft Edge Firefox Why These Browsers? Our focus on Google Chrome and Microsoft Edge is driven by several factors: Advanced Features and Standards These…
Remote Connectivity
Advanced Topics » Product Security » Remote Connectivity
Remote Connectivity dbWatch Control Center servers are by default configured to allow connections on port 7100/TCP. This communication is encrypted and several network controls are available to restrict traffic. Communication is only available to approved nodes,…
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…
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…
Hardware Specifications
Advanced Topics » Product Security » Hardware Specifications
Hardware Specifications dbWatch Server Prerequisites Windows Server or Linux Ubuntu Server(VMWare virtual server supported) 8 GB RAM 4 CPU cores 1 GB HD Space (for dbWatch) dbWatch Engine Prerequisites 500 Mb free space in each database instance. SQL…
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…
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,…
Notes
Using Control Center » Monitoring » Job concepts » Notes
Notes on jobs are information that DBA’s and the Control Center system save to better document a system setup and known behaviour. When you open notes on a job, it will start off as a blank note. The top field is for personal notes and the contents are stored…
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…
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…
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 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…
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…
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…
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…
Job details
Using Control Center » Monitoring » Job details
When you click on one of the jobs in the job tree, you can see a more detailed job overview. The idea of this overview is to show current and historical state, configured parameters and how the job is behaving on other database instances. In the top left…
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…
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…
Scheduled reports
Using Control Center » Reporting » Scheduled reports
Scheduled reports are defined to be generated at specified intervals, and can be automatically emailed to you when they are completed. Create a scheduled report To create a scheduled report see Generate Report. Configure a scheduled report Once a report has been…
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…
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…
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…
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…
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…
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…
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”.…
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…
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…
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…
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…
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…
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…
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…
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…
Implementation
Customization » Monitoring » Editor for engine jobs » Implementation
The implementation steps are the most important section. It consists of code blocks that creates the contents of the job. Typically at least one table and a procedure. You can right-click on the “Implementation” tree element to add new code blocks. You…
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 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…
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…
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…
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…
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.…
Status
Using Control Center » Monitoring » Job concepts » Status
Jobs can have four different statuses. Additionally, the instance can have the “Lost connection” state, blue, that takes precedence over job statuses. Green for OK, Yellow for Warning, and Red for Alarm. Tasks can be without status, and the no-status icon…
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…
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…
Properties on Jobs
Advanced Topics » FDL – Farm Data Language » Available properties » Properties on Jobs
Jobs are available under instance through the task property server/instance[name = '...']/task The available properties are: Name Description Return type Typical values Extra name The name of the job String Blocking…
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…
Adding a PostgreSQL Instance
Using Control Center » Instance management » Adding a PostgreSQL Instance
How to get here To open the “Add Instance Wizard”, click on the “Plus (+)” sign on the bottom left of the dbWatch Client. This will bring up the “Add Instance” wizard, which will guide you through the following steps. Select Instance Type and Input…
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…
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…
Transaction log size check
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Transaction log size check
Name: Transaction log size check Platform: Sqlserver Category: Capacity Description: This procedure checks the size of the transaction log (log file(s) size), and compares it to the database size (data file(s) size). If the…
Transaction log size check (MS2000)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Transaction log size check (MS2000)
Name: Transaction log size check Platform: Sqlserver Category: Capacity Description: This procedure checks the size of the transaction log (log file(s) size), and compares it to the database size (data file(s) size). If…
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…
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…
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…
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.…
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…
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…
Security and Compliance package on SQL Server
Installing and using premium packages » Security and Compliance package » Security and Compliance package on SQL Server
The Security and Compliance package The Security and Compliance package provides a detailed evaluation of your Microsoft SQL Server’s security and compliance, managed via dbWatch Control Center. It offers in-depth insights into your server’s security and…
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…
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…
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…
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…
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”,…
Instance alert log
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Instance alert log
Name: Instance alert log Platform: Oracle Category: Availability Description: Reads and checks errors in the X$DBGALERTEXT performance view contained in the XML decoded version of the XML version of Alert log…
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…
Service groups
Using Control Center » Instance management » Service groups
In dbWatch you can organize instances in servicegroups Instances placed in the same servicegroup should provide a common service of some sort. For example this can be instances belonging to the same cluster. Servicegroups may also be placed inside other…
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…
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…
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…
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…
Jobs for Sybase
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Sybase
Control Center Jobs Description Availability Database backup Checks backup status of all databases. Database status Checks status of all databases defined on the system. The following incidents triggers a warning or an…
Network and communications
Product Overview » Network and communications
Network and communications Default ports and protocol dbWatch Control Center uses by default port 7100/tcp for client to node and node to node connections. This can be configured to a different port. On each node there is a node.connections file that both lists what…
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?=…
Auditing
Advanced Topics » Auditing
DbWatch supports auditing of all statements that are executed on the database instances from dbWatch. There is currently no graphical way of turning this feature on, so it involves manually editing the server_configuration.xml file. Stop the dbWatch Server and take a…
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…
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…
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 …
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…
Acknowledgement system
Using Control Center » Monitoring » Job concepts » Acknowledgement system
The acknowledgment system is designed to make sure that jobs that have had alarms in the past, but now have changed status, is known to the DBA. By default we list all un-acknowledged warnings or alarms in the “Alert Acknowledgement History” view. If…
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…
Max datafiles check
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Max datafiles check
Name: Max datafiles check Platform: Oracle Category: Availability Description: Checks the ‘soft limit’ and the ‘hard limit’ of the maximum number of physical OS files, that can be mapped to an…
Alert log check (8i)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Alert log check (8i)
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…
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.…
Pre implementation
Customization » Monitoring » Editor for engine jobs » Pre implementation
“Pre implementation” is used to issue grants or create objects as another user, before the implementation step. Its optional, and in this example used to issue grants that is needed by the implementation procedure. “Execute as user” is the…
Upgrade
Customization » Monitoring » Editor for engine jobs » Upgrade
When you add upgrade/implementation steps you get prompted for “Version”, and that is a comma-separated list of versions that this implementation can upgrade from. It is always to the current version. You can use the configuration parameters to create…
Main procedure SQL Server
Customization » Monitoring » Editor for engine jobs » Implementation » Main procedure SQL Server
We will use the “Test alert” as example code, as its only purpose is to generate alarms and warnings, but uses many underlying functions. We go through it in steps, and include the full routine at the end. For historical reasons some code will refer to…
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…
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…