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

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…

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…

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…

Instance status

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

Name: Instance status Platform: Sqlserver Category: Availability Description: This alert checks if the instance has been restarted since the last check Long…

Additional Resources

Additional Resources

Here are an additional resources that might help you. You can check all the FAQS on our website. Go to dbWatch/faq You can access our FAQs on this site. Go to FAQs Section To check our video libarary, you can access the link provided: dbWatch/videos ← Fresh…

Instance memory statistics

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Instance memory statistics

Name: Instance memory statistics Platform: Oracle Category: Performance Description: Collects statistics on instance memory. Long description: Task collects statistics on instance…

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…

Instance memory check

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Instance memory check

Name: Instance memory check Platform: Sqlserver Category: Performance Description: This job checks the target memory value of the SQL Server instance, and gives a warning/alarm if the instance is not able to allocate a…

Instance memory usage

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Instance memory usage

Name: Instance memory usage Platform: Sqlserver Category: Performance Description: Collects total memory usage and data cache memory usage for SQL Server instance. This dbWatch task can be configured to automatically reduce…

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…

Instance error log

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

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

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…

Add instance with CCC

Advanced Topics » Control Center Commandline » Add instance with CCC

Prerequisites Before adding instances through CCC you need to go through the steps described in Setting up a CCC node The properties for the instance to add are defined in a file (default is “instance.properties”). The syntax is key/value pairs seperated…

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…

Instance error log (AWS)

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

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

Instance memory check (noschema)

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

Name: Instance memory check Platform: Sqlserver Category: Performance Description: This task collects the size of memory objects that are currently allocated by the SQL Server Long description: The alert checks…

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…

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…

Troubleshooting Guide

Troubleshooting Guide

In this section, we’ll discuss about: dbWatch Backup Restoring Configuration Backup Fault Finding Guide Issues and Troubleshooting Definition Mapping ← Integration for Brent Ozar’s First Responder Kit / Backup of dbWatch…

Installation variables

Customization » Monitoring » Editor for engine jobs » Installation variables

Installation variables are used if you want user input during job installation. It is mostly used for application-specific monitoring where the application schema or database can not be determined correctly by the job after installation and human input are…

Instance action script with CCC

Advanced Topics » Control Center Commandline » Instance action script with CCC

Instance action script The instance action script (instance_action.script) can do the following commands: Connect You can connect an already registered and disconnected instance using the connect action. It is the same as what happens if you right-click on an…

Get instance configuration with CCC

Advanced Topics » Control Center Commandline » Get instance configuration with CCC

Prerequisites Before you can get instance configuration through CCC you need to go through the steps described in Setting up a CCC node Getting instance configuration get_instance.script has the following input parameters: server – specify server IP and port,…

Register instance configuration with CCC

Advanced Topics » Control Center Commandline » Register instance configuration with CCC

Prerequisites Before you can get instance configuration through CCC you need to go through the steps described in Setting up a CCC node Registering instance configuration register_instance.script has the following input parameters: server – specify server IP…

Instance memory usage (MS2005 / MS2008)

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Instance memory usage (MS2005 / MS2008)

Name: Instance memory usage Platform: Sqlserver Category: Performance Description: Collects total memory usage and data cache memory usage for SQL Server instance. This dbWatch task can be configured to automatically reduce…

Database Farm Management Additional Resources

Additional Resources » Database Farm Management Additional Resources

Blogs For farm management, we have different blogs discussing this topic: From SQL Instance Management to Database Farm Management dbWatch Control Center for managing Database Farms Does managing database server farms differ from database instances? Tips: How you…

Instance error log file size check

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

Name: Instance error log file size check Platform: Sqlserver Category: Capacity Description: Checks the size og the Instance error log file by using the extended stored procedure xp_cmdshell. Long…

Installing and using additional modules

Installing and using additional modules

Additional modules dbWatch Control Center also provides additional packages or modules to cover specific areas. They may be specific only to one or a few of the platforms supported by dbWatch Control Center. More details are found on the pages specific to the package…

Adding MySQL Instance with Super Privilege Error

Troubleshooting Guide » Adding MySQL Instance with Super Privilege Error

MySQL Super Privilege Error When adding an instance for MySQL 5.0 or over, you may encounter the following error: This error happens when dbWatch Control Center is creating a user. This error appears indicating that the user has no super privilege rights. There…

Console installation on Ubuntu

Getting Started » Installing on Linux » Console installation on Ubuntu

Before you start The installer for dbWatch Control Center requires root to run. However, when we want to run the software under a different user once installed. I will run all the first steps as user root for documentation simplicity. You can use sudo instead. This…

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…

Installation of SQL Performance package

Installing and using additional modules » 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…

Jobs for MariaDB

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

Control Center Jobs Description Availability DBMS uptime Collects uptime statistics in the database. Aborted connects alert Collects uptime statistics in the database. Maximum connections alert Collects uptime…

Jobs for PostgreSQL

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

Control Center Jobs Description Availability Backup check – pg_dump Checks that there exists an up to date backup file. Backup check – WAL Checks that the WAL files have been backed up. DBMS…

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…

Jobs for Oracle

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

Control Center Jobs Description Availability Alert log check This check reads and looks for errors in the database alert log. Alert log check This check reads and looks for errors in the database alert log. Alert…

Jobs for MySQL

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

Control Center Jobs Description Availability DBMS uptime Collects uptime statistics in the database. MySQL aborted connects Checking if there is many aborted connects MySQL max connections Checking if the system…

Fresh Installation of dbWatch Control Center

Troubleshooting Guide » Fresh Installation of dbWatch Control Center

After installing a newer version of dbWatch Control Center, you may encounter problems such as an expired license or a locked account due to forgetting the admin credentials. Here’s a simple guide on doing a fresh installation of dbWatch Control Center.…

Editor for engine jobs

Customization » Monitoring » Editor for engine jobs

How to get here Example jobs We have some example jobs to make the development easier 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…

Blocking detector for RAC

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Blocking detector for RAC

Name: Blocking detector for RAC Platform: Oracle Category: Cluster and Replication Description: Checks if a session is waiting on a TX (transaction) lock. (RAC only) Long description: Task checks if a session is…

Memory session load for RAC

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Memory session load for RAC

Name: Memory session load for RAC Platform: Oracle Category: Cluster and Replication Description: Records the load memory of RAC active sessions over time. Long description: Task records the load memory of RAC…

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…

Alert log check (java for 10g)

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

Name: Alert log check (java) Platform: Oracle Category: Availability Description: This check reads and looks for errors in the database alert log. Uses embedded java to read files. Long description: This check…

Segment size status for old style tablespaces

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Segment size status for old style tablespaces

Name: Segment size status for old style tablespaces Platform: Oracle Category: Capacity Description: Checks segment storage definitions in tablespaces where extent management is not set to local. Long…

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…

SQL Performance package

Installing and using additional modules » SQL Performance package

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

Domain Configuration

Using Control Center » Domain Configuration

How to get here The Domain Configuration can be accessed by going to Server > Domain Configuration. Overview The Domain Configuration dialog lets you configure domain-wide settings. The concepts listed for each domain on the left side tree are: Nodes –…

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…

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…

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…

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, and 2019, or Windows 10 or Windows 11 8 GB RAM 4 CPU cores 10 GB hard drive space dbWatch Engine Prerequisites 500 Mb free space in…

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…

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…

Release notes

About dbWatch Control Center » Release notes

dbWatch Control Center (2023-09-27) Download Important note Linux release is now available as an apt repository, see Linux install guide Only the server installation is available on Linux in this release (no graphical client or CCC scripting engine) New…

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…

SQL statistics

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for PostgreSQL » SQL statistics

Name: SQL statistics Platform: Postgres Category: Performance Description: Collects performance statistics for the SQL statements. Long description: Collects performance statistics for SQL statements from…

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…

SQL statistics

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for PostgreSQL » SQL statistics

Name: SQL statistics Platform: Postgres Category: Performance Description: Collects performance statistics for the SQL statements. Long description: Collects performance statistics for SQL statements from…

Set metadata with CCC

Advanced Topics » Control Center Commandline » Set metadata with CCC

Prerequisites Before settings metadata through CCC you need to go through the steps described in Setting up a CCC node Metadata is defined in a file (default “metadata.properties”) ← Add instance with CCC / Troubleshooting Guide…

Parameters

Using Control Center » Monitoring » Job concepts » Parameters

Most of the monitoring jobs will have parameters. This is used controllable thresholds to adjust the monitoring job behavior and to better align it with the database instance and the preferences of the DBA. This is an example from the “Agent jobs check”…

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…

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…

Job templates

Customization » Monitoring » Job templates

Creating templates Template functionality makes it possible to automate installation and configuration of jobs across the entire database farm you are managing. The configuration interface is available in the menu Server -> Server Configuration -> Edit job…

Configuration parameters

Customization » Monitoring » Editor for engine jobs » Configuration parameters

Configuration parameters are the parameters a user can use to control the behavior of a job. This can be thresholds for alerting, items to ignore, and other types of adjustments that make it easy to create a good fit between a standardized job and a custom 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.…

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…

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…

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…

Getting Started

Getting Started

Downloading the latest version of Control Center You can get a download link to the latest version of dbWatch Control Center by registering for a free evaluation copy Wait for dbWatch’s Confirmation Email. Follow the steps and link in that email. There are…

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…

Using SQL Performance package on SQL Server

Installing and using additional modules » SQL Performance package » Using SQL Performance package on SQL Server

Navigating to the SQL Performance package dashboard Once the SQL statistics job is installed and have collected data, you can navigate to the dashboard. It is located in the management interface for that database instance. The pictures and descriptions are from SQL…

The modules of Control Center

Using Control Center » The modules of Control Center

We have seven default modules available when you start dbWatch Control Center. This article will only introduce you to what these instances are and give a brief description of them. You need to be familiar with the navigation tree to better understand how these modules…

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…

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…

Test alert

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

Name: Test alert Platform: Oracle Category: Availability Description: Test alert that alerts every ‘X’ minutes. Long description: Test alert that alerts every ‘X’ minutes. Usefull for…

Filegroups growth rate

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Filegroups growth rate

Name: Filegroups growth rate Platform: Sqlserver Category: Capacity Description: This procedure collects space usage for the largest filegroups defined in each database. The undocumented ‘sp_MSforeachdb’ Stored…

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…

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…

Object size collector (all databases)

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Object size collector (all databases)

Name: Objects size collector (all databases) Platform: Sqlserver Category: Capacity Description: Collects table and index size information for the largest objects for all databases. Long description: Collects…

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…

MS SQL Server patch status

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

Name: MS SQL Server patch status Platform: Sqlserver Category: Compliance Description: Checks latest updates for Microsoft SQL Server. Long description: Checks latest updates for Microsoft SQL…

SQL statistics

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

Name: SQL statistics Platform: Sqlserver Category: Performance Description: Collects performance statistics for the SQL statements. Long description: Collects performance statistics for cached query plans from…

Data cache memory usage

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Data cache memory usage

Name: Data cache memory usage Platform: Sqlserver Category: Performance Description: Collects data cache memory usage per database (for top 10 databases). Long description: Collects data cache memory usage per…

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…

Version store space usage (tempdb)

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Version store space usage (tempdb)

Name: Version store space usage (tempdb) Platform: Sqlserver Category: Capacity Description: Checks total space in tempdb used by version store records for each database. Long description: Checks total space in…

Replica state

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MySQL » Replica state

Name: Replica state Platform: Mysql Category: Cluster and Replication Description: This job checks if replica changes occurs. For example, if an instance becomes a replica or if an instance is no longer a…

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…

Replica state

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » Replica state

Name: Replica state Platform: Mariadb Category: Cluster and Replication Description: This job checks if replica changes occurs. For example, if an instance becomes a replica or if an instance is no longer a…

Data cache memory usage (MS2005 / MS2008)

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Data cache memory usage (MS2005 / MS2008)

Name: Data cache memory usage Platform: Sqlserver Category: Performance Description: Collects data cache memory usage per database (for top 10 databases). Long…

Program status

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

Name: Program status Platform: Sqlserver Category: Availability Description: Checks for any program connected to the SQL Server by checking the program_name column in the master.dbo.sysprocesses table. Long…

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

Using SQL Performance package on MySQL

Installing and using additional modules » 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…

Data hit ratio

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Data hit ratio

Name: Data hit ratio Platform: Sqlserver Category: Performance Description: Monitors the buffer cache hit ratio by extracting counter values from the master.dbo.sysperfinfo table for the counters ‘Buffer cache hit…

Using SQL Performance package on PostgreSQL

Installing and using additional modules » 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…

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

Collation check

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

Name: Collation check Platform: Sqlserver Category: Availability Description: Checks if there is a collation conflict with temp tables and table variables. Long description: You may get a collation conflict when…

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…

Index usage statistics (all databases)

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Index usage statistics (all databases)

Name: Index usage statistics (all databases) Platform: Sqlserver Category: Performance Description: This procedure collects statistics from sys.dm_db_index_usage_stats performance view which gives information on how an…