Search
Related topics are listed below.
Email and SMS
Advanced Topics » dbWatch Extensions » Extensions » Email and SMS
Configure In the dbWatch Monitor, go to the “Configure”->”Extensions” menu. Choose on the item “E-mail extension” To configure the extension, select it and click “Configure”. You should now see the initial configuration screen (below) The…
Configuration of email for Servicenow integration
Advanced Topics » dbWatch Extensions » Extensions » Email and SMS » Configuration of email for Servicenow integration
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.…
Tasks and Alerts
dbWatch Navigation » Tasks and Alerts
Tasks and Alerts are the cornerstone of the dbWatch Monitoring module. Tasks and Alerts perform the actual monitoring of the database instance. There are two types of Tasks and Alerts. The Standard Tasks and Alerts, and the Advanced Tasks and Alerts. Standard…
Issues and fixes
Troubleshooting » Issues and fixes
High CPU usage on database Occasionally when investigating resource-consuming SQL statements running on your system, you may find that some of them belong to the dbWatch application. For example, a SQL statement that has the highest value of spent CPU time. In most…
Issues and troubleshooting
Setup and Usage » Issues and troubleshooting
High CPU usage on database Occasionally when investigating resource-consuming SQL statements running on your system, you may find that some of them belong to the dbWatch application. For example, a SQL statement that has the highest value of spent CPU time. In most…
For MySQL and MariaDB
dbWatch Navigation » Tasks and Alerts » For MySQL and MariaDB
Tasks and Alerts Description MySQL / MariaDB DBMS Uptime Tasks collects uptime statistics of database servers Maximum connections alert Maximum connections alert Database growth rate (aggregated) …
Managing tasks and alerts
dbWatch Navigation » Managing tasks and alerts
dbWatch Tasks and Alerts are the cornerstone of the dbWatch Monitoring framework. By controlling which Tasks and Alerts are installed on your database instances, you control what aspects of the instance that is monitored. How to get here To access the Manage Tasks…
Edit tasks and alerts
dbWatch Navigation » Edit tasks and alerts
How to get here Edit Existing To edit an existing Task or Alert open the Task/Alert Editor by right clicking on any task or alert and select Edit task from the popup menu. Create new To create a new Task or Alert from scratch, go to the Manage tasks and alerts…
Download and install dbWatch
dbWatch Download and Installation – Getting Started » Download and install dbWatch
Download dbWatch Instructions and license key will be sent thru your email when you sign up on this link – Get started with dbWatch The dbWatch installer can be downloaded here About the architecture dbWatch is a distributed system that consists of two…
dbWatch Monitoring and Reporting
dbWatch Monitoring and Reporting
In this section we will learn how to monitor performance and generate reports with dbWatch.
Edit Tasks and Alerts
Development in dbWatch » Edit Tasks and Alerts
How to get here Edit Existing To edit an existing Task or Alert open the Task/Alert Editor by right clicking on any task or alert and select Edit task from the popup menu. Create new To create a new Task or Alert from scratch, go to the Manage tasks and alerts…
Managing Tasks and Alerts
Setup and Usage » Managing Tasks and Alerts
dbWatch Tasks and Alerts are the cornerstone of the dbWatch Monitoring framework. By controlling which Tasks and Alerts are installed on your database instances, you control what aspects of the instance that is monitored. How to get here To access the Manage Tasks…
View host cpu and disk usage
dbWatch Monitor Setup » Adding a MySQL Instance » View host cpu and disk usage
Configure SSH to view cpu and disk usage Currently the tasks for CPU and disk usage are not installed. You must enable SSH to install it. Go to the management module > Right click on the Instance > Choose Configure A new window will appear > Select the…
dbWatch Download and Installation – Getting Started
dbWatch Download and Installation – Getting Started
In this section we will learn the supported platforms of dbWatch. dbWatch Prerequisites Before diving into installing dbWatch on your system, make sure that you have complied to the necessary requirements provided which you can access by opening the link…
dbWatch Extensions
Advanced Topics » dbWatch Extensions
dbWatch supports many 3rd party products and external services. dbWatch currently provides these extension plugins: Email SMS HP Openview Nimsoft BigBrother Huntsman Nagios System Center Operations Manager IBM Tivoli Other systems trough SNMP Not all…
FAQ
FAQ
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…
License Renewal
Troubleshooting » License Renewal
This section covers a simple guide in renewing your dbWatch Enterprise Manager license. Step One: After renewing, the license key will be sent to your registered email. For this example, let’s use the demo license below: Step Two: Open Enterprise Manager…
HP Openview
Advanced Topics » dbWatch Extensions » Extensions » HP Openview
Installing Configuring the dbWatch HP OpenView extension is quite straightforward. Start the dbWatch Monitor and navigate to the “Configure” -> “Extensions” menu. This should open the Extensions view Here you will find an entry named “dbWatch HP…
Generate Reports
dbWatch Monitoring and Reporting » Reporting » Generate Reports
When you click on “Generate Report”, 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…
Generate Reports
Setup and Usage » Reporting » Generate Reports
When you click on “Generate Report”, 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…
Scheduled Reports
dbWatch Monitoring and Reporting » 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…
Scheduled reports
Setup and Usage » 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…
dbWatch installation on Ubuntu
dbWatch Download and Installation – Getting Started » Installing on Linux » dbWatch installation on Ubuntu
Step by step guide To start off, prepare the installation directory of dbWatch. Execute the following commands: Create a new directory for dbWatch: sudo mkdir –p /usr/local/dbWatch Then input the root or super user password. Change the owner of the…
SNMP v3
Advanced Topics » dbWatch Extensions » Extensions » SNMP v3
Setup To enable the SNMPv3 extension, go to the “Server”->“Server extensions” menu in the dbWatch Monitor. Here you will find an entry called “SNMP extension”, select this and click “Configure” on the toolbar. This will bring up thefollowing …
Release notes
About dbWatch » Release notes
New in dbWatch 12.9.2 17. Apr. 2023 – ( Download ) New features support for MS SQL Server 2022 support for Postgres 15 Improvements MS SQL Server -new version of “MS SQL Server patch status” (2.0) job – added patches up to 15th Mar.…
License terms
Licensing and policies » License terms
dbWatch End User License Agreement 1. PARTIES This License and Services Agreement (“Agreement”) is between dbWatch AS, organization number 991 500 456 (“dbWatch”) and the Customer which is the entity or person whose name and contact details as it appears on…
Unit4 Agresso
Advanced Topics » Application Modules » Unit4 Agresso
Installation guide for Microsoft SQL Server and Oracle platforms The dbWatch Agresso Module is based on the dbWatch Engine Framework and can be installed during the initial installation of the dbWatch Framework. If the MS SQL Server or Oracle instance where the…
Unit4 Agresso
Setup and Usage » Application Modules » Unit4 Agresso
Installation guide for Microsoft SQL Server and Oracle platforms The dbWatch Agresso Module is based on the dbWatch Engine Framework and can be installed during the initial installation of the dbWatch Framework. If the MS SQL Server or Oracle instance where the…
About dbWatch
About dbWatch
dbWatch is a highly scalable software solution helping enterprises monitor and manage large numbers of database servers efficiently, providing total control over all aspects of operation, performance and resource usage. dbWatch will give you the total overview you need…
Tree Navigation
dbWatch Navigation » Tree Navigation
In the tree structures that you will find throughout dbWatch there are 2 components that lets you group and filter instances. On the top of the tree you have a “Grouping” panel that is minimized by default, and below that you have the quick text based…
Tree navigation
Setup and Usage » Tree navigation
In the tree structures that you will find throughout dbWatch there are 2 components that lets you group and filter instances. On the top of the tree you have a “Grouping” panel that is minimized by default, and below that you have the quick text based…
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…
Application Modules
Setup and Usage » 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…
Backup of dbWatch
Troubleshooting » 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 is installed in a directory which is normally /usr/local/dbWatch/[version] on Unix/Linux and…
Adding a MySQL Instance
dbWatch Monitor Setup » Adding a MySQL Instance
How to get here To add a MySQL instance, click on the “Add” icon on the main toolbar. This will bring up the “Add Database Instance” wizard, which will guide you through the following steps. Select Installation Type The first step of the…
Protecting the communication
dbWatch Server Configuration » Protecting the communication
This page describes the communication between the dbWatch Monitor and the Server. The default setup To ensure the privacy of the user sessions, dbWatch wraps all communication between the monitors and the servers in ssl. During installation the installer generates…
Protecting the communication
Setup and Usage » Configuration » Protecting the communication
This page describes the communication between the dbWatch Monitor and the Server. The default setup To ensure the privacy of the user sessions, dbWatch wraps all communication between the monitors and the servers in ssl. During installation the installer generates…
Edit Report Templates
Development in dbWatch » Edit Report Templates
Report Selection When you click on “Reports” 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”. Report…
Oracle RAC
dbWatch Monitor Setup » Adding an Oracle instance » Oracle RAC
dbWatch 11 finally lets you monitor and manage Oracle Real Application Clusters (RAC) the natural way. dbWatch Tasks and Alerts now comes in two forms, instance centric and database centric. Instance centric Tasks/Alerts monitors data that is relevant for a single…
Oracle RAC
Setup and Usage » Adding an Oracle Instance » Oracle RAC
dbWatch 11 finally lets you monitor and manage Oracle Real Application Clusters (RAC) the natural way. dbWatch Tasks and Alerts now comes in two forms, instance centric and database centric. Instance centric Tasks/Alerts monitors data that is relevant for a single…
Operating system monitoring
dbWatch Monitoring and Reporting » Monitoring » Operating system monitoring
dbWatch provides OS monitoring by connecting to the host machine that is running the database instance using SSH. This currently works only for Unix-like platforms. To enable OS monitoring through SSH you first have to register the database instance running on the…
OS monitoring
Setup and Usage » OS monitoring
dbWatch provides OS monitoring by connecting to the host machine that is running the database instance using SSH. This currently works only for Unix-like platforms. To enable OS monitoring through SSH you first have to register the database instance running on the…
Devops with dbWatch
Devops with dbWatch
Database operations and devops Traditionally database operations has been a highly specialized field within it-operations. So much so that many organizations operate with platform specific dba teams. Because of the amount of platform specific know-how needed to…
Nagios
Advanced Topics » dbWatch Extensions » Extensions » Nagios
Introduction The dbWatch Nagios extension mechanism is included in the product and can be found under Configure->Extensions from dbWatch Monitor when connected to a dbWatch Server. This must be configured and enabled. A perl script needs to be added to your Nagios…
Edit Report Templates
dbWatch Monitoring and Reporting » Reporting » Edit Report Templates
Report Selection When you click on “Reports” 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”. Report…
For SQL Server
dbWatch Navigation » Tasks and Alerts » For SQL Server
Tasks and Alerts Description SQLServer Database alwayson backup Analyzes the backup statistics (type D and I) from the msdb.dbo.backupset table (excluding the system databases: master, model and msdb). Database alwayson…
Adding a Sybase Instance
dbWatch Monitor Setup » Adding a Sybase Instance
How to get here To add a Sybase instance, click on the “Add” icon on the main toolbar. This will bring up the “Add Database Instance” wizard, which will guide you through the following steps. Select Installation Type The first step of the…
Example: Restrict access to instances
dbWatch Monitor Setup » Operator Configuration » Example: Restrict access to instances
Scenario I have a consultant coming in to do some work on our Oracle instances. I want to create a user for him so that he can only modify the Oracle instances. Solution First, to have a secure setup make sure that at least the following objects are secured. (Any…
Upgrading dbWatch
dbWatch Download and Installation – Getting Started » Upgrading dbWatch
dbWatch tests and supports upgrades from 11.x or 12.x to 12.x only. If you have an older installation, it is recommended that you remove the old dbWatch installation and schema in the database and install the latest dbWatch release. Steps for upgrade Contact dbWatch…
Special setup in NAT environments
Setup and Usage » Configuration » Special setup in NAT environments
dbWatch 11 and 12 uses JAVA RMI with SSL for network communication, and the JAVA RMI Registry functionality will create a problem when connecting from the monitor client to the server, when the IP address of the actual dbWatch server host is different from the IP…
SQL Server Compatibility Level
Setup and Usage » SQL Server Compatibility Level
dbWatch provides DBAs the overview of their database’s compatibility level and displays other attributes of the sql server database they are using. The compatibility report view enables DBAs to find where they have the potential for performance improvements by…
Adding Instances With Existing Schema
Setup and Usage » Adding Instances With Existing Schema
If you have a database instance with an existing dbWatch schema and you want to use this you have to first add the instance with only the “Administration” module. Follow the normal procedure for adding the instance (click “Add” on the main…
Special setup in NAT environments
dbWatch Server Configuration » Special setup in NAT environments
dbWatch 11 and 12 uses JAVA RMI with SSL for network communication, and the JAVA RMI Registry functionality will create a problem when connecting from the monitor client to the server, when the IP address of the actual dbWatch server host is different from the IP…
Adding a Sybase Instance
Setup and Usage » Adding a Sybase Instance
How to get here To add a Sybase instance, click on the “Add” icon on the main toolbar. This will bring up the “Add Database Instance” wizard, which will guide you through the following steps. Select Installation Type The first step of the…
Instance Configuration
dbWatch Monitor Setup » Instance Configuration
How to get here The instance configuration view can be accessed by clicking on the Instances icon on the main toolbar, or by right clicking directly on an instance and selecting Configure from the pop-up menu. Main view The instance configuration view consists of…
Instance Configuration
Setup and Usage » Instance Configuration
How to get here The instance configuration view can be accessed by clicking on the Instances icon on the main toolbar, or by right clicking directly on an instance and selecting Configure from the pop-up menu. Main view The instance configuration view consists of…
Example: Restrict access to instances
Setup and Usage » Operator Configuration » Example: Restrict access to instances
Scenario I have a consultant coming in to do some work on our Oracle instances. I want to create a user for him so that he can only modify the Oracle instances. Solution First, to have a secure setup make sure that at least the following objects are secured. (Any…
For Oracle
dbWatch Navigation » Tasks and Alerts » For Oracle
Tasks and Alerts Description Oracle Alert log check This check reads and looks for errors in the database alert log. Uses embedded java to read files. Alert log check 11g This check reads and looks for errors in…
Metadata Properties
Advanced Topics » Property System » Metadata Properties
You can put metadata on instances, and this metadata will be automatically available in dbwql. 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…
Metadata properties
Setup and Usage » Property System » Metadata properties
You can put metadata on instances, and this metadata will be automatically available in dbwql. 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 SQL Express Instance
dbWatch Monitor Setup » Adding a SQL Server Instance » Adding a SQL Express Instance
To add a SQL Express instance, click on the “Add database” icon on the main toolbar. It will display the “Add Database Instance” wizard, which will guide you through the following steps. Select Installation Type The first step of the…
Adding a SQL Express Instance
Setup and Usage » Adding an SQLServer Instance » Adding a SQL Express Instance
To add a SQL Express instance, click on the “Add database” icon on the main toolbar. It will display the “Add Database Instance” wizard, which will guide you through the following steps. Select Installation Type The first step of the…
Fault Finding Guide
Troubleshooting » Fault Finding Guide
Errors before starting the installer The first step is to download the software. Once downloaded, errors may occur when the installer unpacks. The install executable or zip file might have been damaged during download, and if this is indicated, try first downloading…
Architecture
Overview of dbWatch » Architecture
Architecture components The dbWatch installation consists of three components; the dbWatch Monitor which is the front end GUI. The dbWatch Server which is the core business logic and central hub of the system. And the dbWatch Framework where objects are stored in the…
SQL Server performance benchmarking
dbWatch Monitoring and Reporting » Monitoring » SQL Server performance benchmarking
Dbwatch comes with a set of benchmarks for measuring the performance capabilities of an SQLServer instance. This benchmarks runs a series of DML statements designed to test various key properties of a database system. This is the same benchmarks we have used to…
SQLServer performance benchmarks
Setup and Usage » SQLServer performance benchmarks
Dbwatch comes with a set of benchmarks for measuring the performance capabilities of an SQLServer instance. This benchmarks runs a series of DML statements designed to test various key properties of a database system. This is the same benchmarks we have used to…
Creating a custom dbWatch view using existing performance scripts
dbWatch Monitor Setup » Creating a custom dbWatch view using existing performance scripts
In this section we will learn the step by step process on how you can create a custom view using dbWatch properties and your existing monitoring scripts. In this example we will be creating a dbWatch property and sub properties which will be used to create a custom…
Adding a SQL Server Instance
dbWatch Monitor Setup » Adding a SQL Server Instance
How to get here To add an SQLServer instance, click on the “Add” icon on the main toolbar. This will bring up the “Add Database Instance” wizard, which will guide you through the following steps. Select Installation Type The first step of…
Adding an SQLServer Instance
Setup and Usage » Adding an SQLServer Instance
How to get here To add an SQLServer instance, click on the “Add” icon on the main toolbar. This will bring up the “Add Database Instance” wizard, which will guide you through the following steps. Select Installation Type The first step of…
Importing resources
Development in dbWatch » Importing resources
Much of the functionallity in dbWatch is defined in xml files, including report specifications, task specifictions and management specifications. That means that functionallity can be modified by supplying new xml files to dbWatch. There are two ways of doing…
SQL Server AlwaysON Monitoring
dbWatch Monitoring and Reporting » Monitoring » SQL Server AlwaysON Monitoring
dbWatch allows you to monitor the status of your Always ON High Availability groups and check the state of the member nodes within an AlwaysOn cluster. Let’s start by adding a database instance in the dbWatch application. On top Choose Add database > Select MS SQL…
Create Custom Extensions
Advanced Topics » dbWatch Extensions » Create Custom Extensions
All dbWatch extensions are written in the Java programming language, so creating a custom extension requires some basic knowledge of Java. Dependencies You will need the following jar files located in the [dbWatch Server]/server/lib/…
SQL Server Always ON Cluster Monitoring
Setup and Usage » SQL Server Always ON Cluster Monitoring
dbWatch allows you to monitor the status of your Always ON High Availability groups and check the state of the member nodes within an AlwaysOn cluster. Let’s start by adding a database instance in the dbWatch application. On top Choose Add database > Select MS SQL…
Importing Resources
dbWatch Navigation » Importing Resources
Much of the functionallity in dbWatch is defined in xml files, including report specifications, task specifictions and management specifications. That means that functionallity can be modified by supplying new xml files to dbWatch. There are two ways of doing…
SNMP v1
Advanced Topics » dbWatch Extensions » Extensions » SNMP v1
Setup To configure the extensinio, go to the “Server”->“Server extensions” menu in the dbWatch Monitor. Here you will find an entry called “SNMP v1 extension”, select this and click “Configure” on the toolbar. In the…
SQL Worksheet
dbWatch Navigation » SQL 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…
SQL Worksheet
Setup and Usage » SQL 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…
Adding instances with existing dbWatch schema
dbWatch Monitor Setup » Adding instances with existing dbWatch schema
If you have a database instance with an existing dbWatch schema and you want to use this you have to first add the instance with only the “Administration” module. Follow the normal procedure for adding the instance (click “Add” on the main…
Operator Configuration
Setup and Usage » Operator Configuration
Access to dbWatch is controlled through operators. Operators have a password and a set of privileges on dbWatch. How to get here The operator configuration view can be going to Configure > Server Configuration > Manage Users and Roles Operators main view The…
Issue in starting Web Server
Troubleshooting » Issue in starting Web Server
When you are using dbWatch 12 and this warning prompts: *Information: You must first enable the webserver on ‘Local Server’ by selecting the server node in the tree. And once you open Configure > Server Configuration > Web Server , you see the…
dbWatch Notes
dbWatch Navigation » dbWatch Notes
dbWatch allows you to attach notes to tasks, instances and servers. You can access the notes dialog by right clicking on a instance/task/server, and selecting “Notes” on the menu, The notes dialog has two tabs, one for public notes (visible to all…
Web data export
Setup and Usage » 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 in several formats, most notably html, json and csv. To create a simple export containing an overview of your environment, click “New” in…
SCOM
Advanced Topics » dbWatch Extensions » Extensions » SCOM
Required file You need one file dbWatchMP.xml that can be downloaded from the following location: https://github.com/dbWatch/scripts_and_tools/tree/master/Extensions/SCOM Installing The first thing you must do is to tell dbWatch to export the SCOM text file. In…
Running several Servers in parallel
Setup and Usage » Running several Servers in parallel
In order to run more than one dbWatch Server on a machine there are two things you need to do. Make them listen to different ports, and use seperate paths for their files. Before making any changes to the files, make sure the the dbWatch Server is stopped. Change…
Adding an Oracle instance
dbWatch Monitor Setup » Adding an Oracle instance
Oracle Prerequisites Oracle databases need to have a listener process running and also allow for an external login with sysdba user or user with enough privileges. You need a privileged user, such as sys as sysdba, another user with sysdba privileges or another user…
Adding an Oracle Instance
Setup and Usage » Adding an Oracle Instance
Oracle Prerequisites Oracle databases need to have a listener process running and also allow for an external login with sysdba user or user with enough privileges. You need a privileged user, such as sys as sysdba, another user with sysdba privileges or another user…
Overview of dbWatch
Overview of dbWatch
This topic will be covering setup and methods for the way we at dbWatch consider setting up dbWatch for Database Operations in the best possible way. It will be based on experience from our customers as well as our own database operations team. Architecture Tasks…
Replication Monitoring
dbWatch Monitoring and Reporting » Monitoring » Replication Monitoring
dbWatch allows you to monitor the status of your database replication. You can do this by installing replication status task in dbWatch. Choose Configure Monitoring Select the instance you want to install the task in. Tick Replication status and click…
Logging
Setup and Usage » Configuration » Logging
Default setup [Users home]/monitor.log: The monitor will log events to this log. [install dir]/server.log : The server will log events to this log file. Eventlog: On windows systems the server will log login events, failed login events and disconnects to the…
Replication
Setup and Usage » Replication
dbWatch allows you to monitor the status of your database replication. You can do this by installing replication status task in dbWatch. Choose Configure Monitoring Select the instance you want to install the task in. Tick Replication status and click…
Oracle License Analysis
dbWatch Monitoring and Reporting » Monitoring » Oracle License Analysis
dbWatch allows you to collect and monitor the license information of your Oracle instances. You will be able to check the various options and features installed within your instance that has an added cost. This feature is useful to avoid Oracle’s unexpected fees…
Adding a new server to your dbWatch monitor
dbWatch Server Configuration » Adding a new server to your dbWatch monitor
dbWatch Monitor supports connecting to multiple monitors, which can be handy in setups where you have two seperate networks and need the databases in both networks monitored. This setup requires that the machine running dbWatch Monitor can see both the dbWatch Server…
Add a new server to your monitor
Setup and Usage » Configuration » Add a new server to your monitor
dbWatch Monitor supports connecting to multiple monitors, which can be handy in setups where you have two seperate networks and need the databases in both networks monitored. This setup requires that the machine running dbWatch Monitor can see both the dbWatch Server…
dbWatch Logs
dbWatch Server Configuration » dbWatch Logs
Default setup [Users home]/monitor.log: The monitor will log events to this log. [install dir]/server.log : The server will log events to this log file. Eventlog: On windows systems the server will log login events, failed login events and disconnects to the…
Category Line Chart
dbWatch Navigation » Edit 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…
Formatting output
Setup and Usage » Commandline » Formatting output
Some dbWatch command line commands outputs table data. These commands have a parameter -format which lets you specify the output format of the command. The -format parameter refers to a set of user defined formats stored in the /.dbwatch/formats/ folder. The ability…
Formatting the output
Advanced Topics » Command Line » Formatting the output
Some dbWatch command line commands outputs table data. These commands have a parameter -format which lets you specify the output format of the command. The -format parameter refers to a set of user defined formats stored in the /.dbwatch/formats/ folder. The ability…
Integrating with active directory
dbWatch Server Configuration » Integrating with active directory
Setting up Active Directory authentication By default dbWatch authenticates users using it’s own internal username/password database. This section describes how to add Active Directory as a second user authentication provider. Connect to the server with the…
Integrating with Active Directory
Setup and Usage » Configuration » Integrating with Active Directory
Setting up Active Directory authentication By default dbWatch authenticates users using it’s own internal username/password database. This section describes how to add Active Directory as a second user authentication provider. Connect to the server with the…