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

[Database name] (database server)

Using Control Center » Management » Management on SQL Server » Configuration » Uptime statistics » [Database name] (database server)

This gives an overview of up and down periods for the database server. You can right-click on the screen to switch between different ways to display uptime: Like uptime per week: ← Uptime statistics / (instance) →

RAC instances status

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » RAC instances status

Name: RAC instances status Platform: Oracle Category: Cluster and Replication Description: Reacts if one or more RAC instances are not available. Long description: Reacts if one or more RAC instances are not…

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…

Bulk installing instances

Using Control Center » Instance management » Bulk installing instances

CSV File Format You can add instances in bulk. The prerequisite is to have a CSV file with the following…

Database load

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MySQL » Database load

Name: Database load Platform: Mysql Category: Performance Description: Provides information on the server load Long description: Task provides infomation on the server load in the database…

Database status

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database status

Name: Database status Platform: Sqlserver Category: Availability Description: Checks if all databases have status ONLINE Long description: A database state specifies the current running mode of that database.…

Database backup

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database backup

Name: Database backup Platform: Sqlserver Category: Availability Description: This procedure analyzes the backup statistics (type D and I) from the msdb.dbo.backupset table (excluding the system databases: master, model and…

Database mirroring

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database mirroring

Name: Database mirroring Platform: Sqlserver Category: Cluster and Replication Description: Checks state information of all mirrored databases. Long description: Checks state information of all mirrored…

Database statistics

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database statistics

Name: Database statistics Platform: Sqlserver Category: Availability Description: This procedure gathers statistics per database. Long description: Version: 1.8 Default schedule: 0 5 6…

Database load

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » Database load

Name: Database load Platform: Mariadb Category: Performance Description: Provides information on the server load Long description: Task provides infomation on the server load in the database…

Database backup

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Sybase » Database backup

Name: Database backup Platform: Sybase Category: Availability Description: Checks backup status of all databases. Long description: Version: 1.1 Default schedule: 50 5 *…

Database status

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Sybase » Database status

Name: Database status Platform: Sybase Category: Availability Description: Checks status of all databases defined on the system. The following incidents triggers a warning or an alarm: Long…

Database uptime

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

Name: Database uptime Platform: Oracle Category: Availability Description: Collects database uptime statistics for all instances mounted on the database. Long description: Collects database uptime statistics for…

Database compatibility

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database compatibility

Name: Database compatibility Platform: Sqlserver Category: Security Description: Checks if there is a difference in compatibility levels of databases and the instance. Long description: Checks if there is a…

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…

Database status (MS2000)

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database status (MS2000)

Name: Database status Platform: Sqlserver Category: Availability Description: Checks if all databases have status ONLINE Long description: Version: 2 Default schedule: 0 * *…

Database server uptime

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database server uptime

Name: Database Server uptime Platform: Sqlserver Category: Availability Description: Collects database server uptime statistics. Long description: Version: 2.2 Default schedule: * *…

Database backup (noschema)

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

Name: Database backup Platform: Sqlserver Category: Availability Description: This alert checks if the instance has been restarted since the last check Long description: This job checks the backup statistics…

Database status (noschema)

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database status (noschema)

Name: Database status Platform: Sqlserver Category: Availability Description: This alert checks if the instance has been restarted since the last check Long description: Version: 2 Default…

Database disk capacity

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database disk capacity

Name: Database disk capacity Platform: Sqlserver Category: Capacity Description: Checks free space on drives where data and transaction log files are defined. An alarm (or warning) is raised if the percentage limit is…

Database backup (MS2000)

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

Name: Database backup (2000) Platform: Sqlserver Category: Availability Description: This procedure analyzed the backup statistics from msdb.dbo.backupset table (excluding system databases: master, model and…

Database session load

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database session load

Name: Database session load Platform: Sqlserver Category: Performance Description: Shows the number of connections over time per database, host and application. Long description: Each time the procedure is…

Sessions per database

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Sessions per database

Name: Sessions per database Platform: Sqlserver Category: Performance Description: This task returns aggregate performance statistics based on sessions connected to the SQL Server instance. Long…

Database load (old)

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » Database load (old)

Name: Database load Platform: Mariadb Category: Performance Description: Provides information on the server load Long description: Task provides infomation on the server load in the database…

Database space check

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Sybase » Database space check

Name: Database space check Platform: Sybase Category: Capacity Description: Checks the amount of free space in all databases. Long description: Version: 2.1 Default schedule: 10 5,17 *…

Database backup (SIMPLE)

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

Name: Database backup (SIMPLE) Platform: Sqlserver Category: Availability Description: This procedure analyzes the backup statistics (type D) from the msdb.dbo.backupset table for databases in SIMPLE recovery model…

Database log backup

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database log backup

Name: Database Log backup Platform: Sqlserver Category: Availability Description: This procedure checks the database transaction log backups from the msdb.dbo.backupset table (excluding system databases: master, model and…

Database mount state

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Database mount state

Name: Database mount state 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…

Database link check

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Database link check

Name: Database link check Platform: Oracle Category: Availability Description: Checks database links. Long description: In order to check private database links you have to create a following view ‘create…

Auto close database

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Auto close database

Name: Auto close database Platform: Sqlserver Category: Security Premium package: Security and compliance package Description: Checks if the contained databases are closed or not after a connection…

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…

Orphaned database users

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Orphaned database users

Name: Orphaned database users Platform: Sqlserver Category: Security Premium package: Security and compliance package Description: Checks if there are orphaned database users (users for which the corresponding…

Database Mail XPs

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database Mail XPs

Name: Database Mail XPs Platform: Sqlserver Category: Security Premium package: Security and compliance package Description: Checks the ability to generate and transmit email messages from SQL Server.…

Guest database users

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Guest database users

Name: Guest database users Platform: Sqlserver Category: Security Premium package: Security and compliance package Description: Checks that CONNECT permission (in every non system database) are revoked for the…

Adding SQLServer instances with kerberos

Using Control Center » Instance management » Adding a SQLServer Instance » Adding SQLServer instances with kerberos

Using the kerberos authentication option requires some additional setup. We need dbwatch user added to the domain: First we create a dbwatch user that is a normal domain user. We set a passord, and make sure it dont expire. And we must add this user to the…

Database growth rate (aggregated)

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MySQL » Database growth rate (aggregated)

Name: Database growth rate (aggregated) Platform: Mysql Category: Capacity Description: Collects database size and visualizes the growth rate of the server. Long description: Collects database size and…

Database growth rate (detailed)

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MySQL » Database growth rate (detailed)

Name: Database growth rate (detailed) Platform: Mysql Category: Capacity Description: Collects detailed growth rate information. Long description: Collects detailed information on the growth rate of the database…

Check database recovery mode

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Check database recovery mode

Name: Check database recovery mode Platform: Sqlserver Category: Availability Description: Checks if all databases are running in FULL or SIMPLE recovery mode. Long description: Checks if all databases are…

Database Server uptime (MS2000)

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database Server uptime (MS2000)

Name: Database Server uptime Platform: Sqlserver Category: Availability Description: Collects database server uptime statistics. Long description: Version: 1.9 Default schedule: * *…

Database server uptime (MS2005)

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database server uptime (MS2005)

Name: Database Server uptime Platform: Sqlserver Category: Availability Description: Collects database server uptime statistics. Long description: Version: 2.2 Default schedule: * *…

Database log backup (noschema)

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

Name: Database log backup Platform: Sqlserver Category: Availability Description: This alert checks if the instance has been restarted since the last check Long description: This job checks the transaction log…

Missing database backup (noschema)

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Missing database backup (noschema)

Name: Missing database backup Platform: Sqlserver Category: Availability Description: This alert checks if the instance has been restarted since the last check Long description: This job checks for each database…

Database growth rate (aggregated)

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database growth rate (aggregated)

Name: Database growth rate (aggregated) Platform: Sqlserver Category: Capacity Description: Collects size of all database files (including transaction log files) to visualize the growth rate for all databases. Long…

Database growth rate (detailed)

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database growth rate (detailed)

Name: Database growth rate (detailed) Platform: Sqlserver Category: Capacity Description: Collects size of database files (including transaction log files) to visualize the growth rate for the largest…

Database disk space usage

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database disk space usage

Name: Database disk space usage Platform: Sqlserver Category: Capacity Description: Checks free space on drives where all data and transaction log files are defined. Drives where no data files exist will be…

Database disk capacity (noschema)

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database disk capacity (noschema)

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

Temporary database space usage

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Temporary database space usage

Name: Temporary database space usage Platform: Sqlserver Category: Capacity Description: Checks space usage in tempdb database, and collects statistics including size of data and transaction log files. Long…

Database backup (system dbs)

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

Name: Database backup (system dbs) Platform: Sqlserver Category: Availability Description: This procedure analyzed the system database backups statistics from msdb.dbo.backupset table. Long…

AlwaysOn database backup alert

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » AlwaysOn database backup alert

Name: AlwaysOn database backup alert Platform: Sqlserver Category: Cluster and Replication Description: Checks the status of each member node of the current WSFC cluster based on Dynamic Management Views…

Database growth rate (aggregated)

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » Database growth rate (aggregated)

Name: Database growth rate (aggregated) Platform: Mariadb Category: Capacity Description: Collects database size and visualizes the growth rate of the server. Long description: Collects database size and…

Database growth rate (detailed)

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » Database growth rate (detailed)

Name: Database growth rate (detailed) Platform: Mariadb Category: Capacity Description: Collects detailed growth rate information. Long description: Collects detailed information on the growth rate of the…

Database space check (12)

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Sybase » Database space check (12)

Name: Database space check Platform: Sybase Category: Capacity Description: Checks the amount of free space in all databases. Long description: Version: 2.1 Default schedule: 10 5,17 *…

Database growth rate (detailed)

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Sybase » Database growth rate (detailed)

Name: Database growth rate (detailed) Platform: Sybase Category: Capacity Description: Collects database growth rates statistics. Long description: Version: 1.3 Default schedule: 10 6…

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…

Database backup (2005-2012)

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database backup (2005-2012)

Name: Database backup Platform: Sqlserver Category: Availability Description: This procedure analyzes the backup statistics (type D and I) from the msdb.dbo.backupset table (excluding the system databases: master, model and…

Database network statistics (SQL*NET)

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Database network statistics (SQL*NET)

Name: Database network statistics (SQL*NET) Platform: Oracle Category: Performance Description: Checks database network SQL*NET statistics. Long description: Task checks database network SQL*NET…

Missing database log backup (noschema)

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Missing database log backup (noschema)

Name: Missing database log backup Platform: Sqlserver Category: Availability Description: This alert checks if the instance has been restarted since the last check Long description: This job checks for each…

Database growth rate (aggregated) (MS2000)

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database growth rate (aggregated) (MS2000)

Name: Database growth rate (aggregated) Platform: Sqlserver Category: Capacity Description: Collects size of all database files (including transaction log files) to visualize the growth rate for all databases. Long…

Database growth rate (detailed) (MS2000)

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database growth rate (detailed) (MS2000)

Name: Database growth rate (detailed) Platform: Sqlserver Category: Capacity Description: Collects size of all database files (including transaction log files) to visualize the growth rate for all databases. Long…

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…

Database Farm Management Additional Resources

Additional Resources » Database Farm Management Additional Resources

Blog This blog delves deeper into this topic: From SQL Instance Management to Database Farm Management Video Resources There are many videos on our Youtube channel You can watch our presentation on Database Farm on our Youtube account: Webinar: Beyond Instance…

AlwaysOn differential database backup alert

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » AlwaysOn differential database backup alert

Name: AlwaysOn differential database backup alert Platform: Sqlserver Category: Cluster and Replication Description: Checks the status of each member node of the current WSFC cluster based on Dynamic Management Views…

Database Log backup (2005-2012)

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database Log backup (2005-2012)

Name: Database Log backup Platform: Sqlserver Category: Availability Description: This procedure checks the database transaction log backups from the msdb.dbo.backupset table (excluding system databases: master, model and…

Check database and server principal mapping

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Check database and server principal mapping

Name: Check database and server principal mapping Platform: Sqlserver Category: Maintenance Description: Checks if the database owner (dbo) is maped into any Server Login (server principal). Long…

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…

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…

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…

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…

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…

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…

About dbWatch Control Center

About dbWatch Control Center

dbWatch Control Center is a highly scalable software solution that helps enterprises monitor and manage large database servers efficiently, providing total control over all database operations, performance, and resource usage. dbWatch Control Center will give you the…

Managing users

Using Control Center » Domain Configuration » Managing users

A user can have roles and grants. A grants is set of privileges on a “Security group”, while roles are a set of grants or other roles or security groups. A “Security group” is a set of database instances and/or servers. Four roles are…

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

Product Description

Advanced Topics » Product Security » Product Description

Product Description dbWatch Control Center is a database operations software intended to monitor, manage, maintain and report on database instances across multiple database platforms and physical locations. A dbWatch Control Center environment has at its core a…

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…

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…

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…

Sensitive Data Stored

Advanced Topics » Product Security » Sensitive Data Stored

Sensitive Data Stored dbWatch Control Center stores usernames and passwords needed to connect to database instances it monitors. The data is encrypted on the disk of the dbWatch Server. ← Sensitive Data Transmitted / Certificate infrastructure…

Monitoring

Customization » Monitoring

Custom monitoring and editing monitoring jobs dbWatch has two types of monitoring jobs that can detect issues in the database instances. They are referred to as Engine jobs and “No-engine jobs”. Engine jobs are jobs that run inside the database engine,…

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…

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…

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…

Worksheet

Using Control Center » Worksheet

One of the truly unique features of dbWatch is its integrated SQL Worksheet, which, although easy to use has sophisticated applications, including cross-database queries. The SQL Worksheet is meant to give responsible DBA’s the ability to locate any problems and…

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…

JDBC Properties

Using Control Center » Instance management » Instance Configuration » JDBC Properties

It is possible to set properties for the JDBC driver on specific instances. You can find this under “Advanced Driver Setup” when adding SQL instances or under “Edit parameters” in the JDBC panel in the Configure Instance dialog. The driver…

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…

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…

Exporting configuration from 12 to CC

Advanced Topics » Exporting configuration from 12 to CC

Exporting database instance configuration from dbWatch 12 to CC A version of 12.9.1 or above is needed for this. The idea is that you can export the instance configuration from a dbWatch 12.9.x installation to install the same instances in dbWatch Control Center, as…

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…

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…

Changing Instance Group

Using Control Center » Instance management » Groups Configuration » Changing Instance Group

Changing a group can be done when you created an instance under a default group name and change it to another corresponding group. To change the groups base on your newly created group, you can check Group Configuration. Changing Group of an Instance Once a group has…

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…

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…

Cluster and replication

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by category » Cluster and replication

Jobs in the Cluster and replication category Control Center Jobs Description Oracle Blocking detector for RAC Checks if a session is waiting on a TX (transaction) lock. (RAC only) Memory session load for RAC Records the…

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…

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…

Default trace enabled

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Default trace enabled

Name: Default trace enabled Platform: Sqlserver Category: Security Premium package: Security and compliance package Description: Checks that ‘Default Trace Enabled’ server configuration option is set…

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…

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…