Search
Related topics are listed below.
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 name] (instance)
Using Control Center » Management » Management on SQL Server » Configuration » Uptime statistics » [Database name] (database server) » [Instance name] (instance)
This gives an overview of when the database instance has been up or down. ← [Database name] (database server) / Maintenance periods →
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 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…
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 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 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…
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…
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…
Management
Customization » Management
Currently there is no graphical interface for editing the managment interface. However, everything is defined in xml files that can be edited directly. Documentation of the syntax is not complete, and you have to rely on the existing code for examples. The following…
Management
Using Control Center » Management
In this section, we’ll be familiarized with how the Management Module works. Examples in this documentation are from Microsoft SQL Server, but this is available on all platforms, however, contents are platform and license dependent. When opening the management…
Adding an Oracle Instance
Using Control Center » Instance management » Adding an Oracle Instance
Oracle Prerequisites !1. Oracle databases need to have a listener process running and also allow for an external login with sysdba user or user with enough privileges. 2. You need a privileged user, such as sys as sysdba, another user with sysdba privileges or…
Adding a 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…
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…
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…
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…
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…
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…
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…
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…
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 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…
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…
Management on SQL Server
Using Control Center » Management » Management on SQL Server
When opening the management module in its initial state, you get the status dashboard: This will give an overview of the system, displaying some instance information, the largest databases, logical reads, session load, and memory usage. When a graph indicates…
Repository management and monitoring
Installing and using premium packages » SQL Performance package » Repository management and monitoring
Introduction The SQL Performance package creates tables in the dbWatch schema/database on each database instance where the SQL Statistics job is installed and scheduled. The process combines two parts of dbWatch Control Center. The monitoring is used to schedule the…
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 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…
Installing on Windows
Getting Started » Installing on Windows
dbWatch Server Prerequisites Windows Server (VMWare virtual server or AWS EC2 supported) Windows Server 2008, 2012, 2016, 2019, and 2022 Windows 10 or Windows 11 8 GB RAM 4 CPU cores 10 GB hard drive space dbWatch Engine Prerequisites 500 Mb free space in…
Encryption
Advanced Topics » Product Security » Encryption
Encryption Data packages sent between server nodes and monitor clients are end-to-end encrypted with the node certificate. The encryption used for this is AES/GCM (256bit keys). This is possible to verify if you click on Help->Debug->Connection info For…
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…
dbWatch alerts
Using Control Center » Management » Management on SQL Server » dbWatch alerts
dbWatch alerts is a list of monitoring jobs in the database in warning or alarm state for this database instance. Example: This is handy so you know you are working on the right database instance when you are correcting issues. You can interact with the…
[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) →
Maintenance periods
Using Control Center » Management » Management on SQL Server » Configuration » Uptime statistics » Maintenance periods
This is where you can add maintenance periods to correct the uptime report for known scheduled maintenance periods that should not count as part of the report. Right click on the maintenance periods to create a new known maintenance period. This allows you fine…
Privileges and actions map
Using Control Center » Domain Configuration » Privileges and actions map
Overview of actions and required privilege Instance is the specific database instance. Instance system is a predefined security group controlling the overall instance monitoring and management. Domain configuration is a predefined security group controlling the…
Configuration
Using Control Center » Management » Management on SQL Server » Configuration
Configuration gives an overview of the current setup of the database instance, including parameters and uptime statistics. ← dbWatch alerts / Parameters →
Advanced static parameters
Using Control Center » Management » Management on SQL Server » Configuration » Parameters » Advanced static parameters
Advanced static parameters will need an instance restart to take effect. You can configure these by right-clicking on the parameter and choose configure. ← Advanced dynamic parameters / Registry parameters →
SQL statistics (CDB)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » SQL statistics (CDB)
Name: SQL statistics Platform: Oracle Category: Performance Extra cost package: SQL Performance package Description: Collects SQL statements statistics (for container database) from V$SQLAREA and V$SQL_PLAN…
SQL statistics (PDB)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » SQL statistics (PDB)
Name: SQL statistics Platform: Oracle Category: Performance Extra cost package: SQL Performance package Description: Collects SQL statements statistics (for pluggable database) from V$SQLAREA and V$SQL_PLAN…
Sessions history
Using Control Center » Management » Management on SQL Server » Sessions » Sessions history
This view shows historic statistics for sessions on this instance. ← Sessions / Sessions performance →
Disabling and Enabling Views
Using Control Center » Disabling and Enabling Views
You can enable or disable modules from your dbWatch Control Center by unticking their check boxes. If you check Views, you will see the default set up of modules that are visible. Once you disable all the modules, you’ll only be left with the Report Module. …
SQL Worksheet
Using Control Center » Management » Management on SQL Server » SQL Worksheet
SQL Worksheet allows for direct SQL commands on the database instance. ← Audit / Worksheet →
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…
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…
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…
Uptime statistics
Using Control Center » Management » Management on SQL Server » Configuration » Uptime statistics
Control Center provides uptime statistics reports, and this is the interface to look at uptime periods for an instance and add scheduled maintenance periods that will be taken into consideration when uptime statistics is generated for this report. ← Registry…
External fragmentation (all databases)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » External fragmentation (all databases)
Name: External fragmentation (all databases) Platform: Sqlserver Category: Maintenance Description: External (logical) fragmentation occurs when an index leaf page is not in logical order. It occurs when the logical…
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…
Member state
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Member state
Name: Member state Platform: Sqlserver Category: Cluster and Replication Description: Checks the status of each member node of the current WSFC cluster based on Dynamic Management Views…
File IO statistics
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » File IO statistics
Name: File IO statistics Platform: Sqlserver Category: Performance Description: Collects I/O statistics for data and log files. Long description: Collects I/O statistics for data and log files baseed on dynamic…
Disk and Memory usage
Using Control Center » Management » Management on SQL Server » Disk and Memory usage
This allows you to get an overview and drill down into disk and memory usage on the database instance. ← Sessions performance / Backups →
AlwaysOn transaction log backup alert
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » AlwaysOn transaction log backup alert
Name: AlwaysOn transaction log 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…
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…
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…
Performance test
Using Control Center » Management » Management on SQL Server » Server activity » Performance test
Performance test displays statistics gathered from the DML performance test job that runs a performance test on the database instance. ← Active processes / Sessions →
Cached query statistics
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Cached query statistics
Name: Cached query statistics Platform: Sqlserver Category: Performance Description: This task returns aggregate performance statistics based on cached query plans in SQL Server. Long description: This task…
Release notes
About dbWatch Control Center » Release notes
dbWatch Control Center (2024-10-07) Download Improvements MS SQL Server – Job “Database disk capacity”. New parameter “combine thresholds”. This parameter allows you to combine the conditions of both the “alarm threshold…
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.…
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…
Using Control Center
Using Control Center
In this section, we will cover the user interface, the different modules, and how they are used. When we start dbWatch Control Center we will by default start-up in the monitoring view: We have the top menu, where we find the configuration of client connections…
Flash Recovery Area Usage
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Flash Recovery Area Usage
Name: Flash Recovery Area Usage Platform: Oracle Category: Capacity Description: Checks space usage in the flash recovery area. Long description: Checks space usage in the flash recovery…
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…
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…
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…
Using SQL Performance package on PostgreSQL
Installing and using premium packages » SQL Performance package » Using SQL Performance package on PostgreSQL
Navigating to the SQL Performance package dashboard Once the SQL statistics job is installed and have collected data, you can navigate to the dashboard. It is located in the management interface for that database instance. The pictures and descriptions are from…
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…
Using SQL Performance package on SQL Server
Installing and using premium packages » SQL Performance package » Using SQL Performance package on SQL Server
Navigating to the SQL Performance package dashboard Once the SQL statistics job is installed and have collected data, you can navigate to the dashboard. It is located in the management interface for that database instance. The pictures and descriptions are from SQL…
Control Center Jobs
Using Control Center » Monitoring » Control Center Jobs
Jobs (older dbWatch versions Tasks and alerts) are the cornerstone of the dbWatch Monitoring module. Jobs perform the actual monitoring of the database instance. There are two types of Monitoring in dbWatch. The Basic and Standard monitoring. To see each monitoring…
Properties
Customization » Monitoring » Editor for engine jobs » Properties
The properties section defines the main settings for the job. Once a job is created the “Task name”, “Company” and “Compatibility” is specified. “Task name” is the visible job name when you install a job or when its…
Using OS Authentication
Using Control Center » Instance management » Adding a SQLServer Instance » Using OS Authentication
When connecting to Microsoft SQL Server instances it is possible to login with Windows Authentication (called OS Authentication in dbWatch). The accout used is the same account as the dbWatch Control Center service runs as. Per default the dbWatch Control Center…
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…
Monitoring Engine
Using Control Center » Instance management » Instance Configuration » Monitoring Engine
The monitoring section of the Configure Instance view looks different depending on if you have a monitoring engine (i.e a database) defined on the instance. With engine: Without engine: Text may vary a bit depending on the database type. Button…
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…
High activity monitor
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » High activity monitor
Name: High activity monitor Platform: Sqlserver Category: Performance Description: Collects SQL instance CPU usage, CPU usage of other processes, logical and physical reads, and active processes count on the SQL Server…
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…
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…
Cloud router
Product Overview » Architecture » Cloud router
Introduction The dbWatch Control Center is structured around a network of nodes dedicated to managing server infrastructure. While these nodes effectively communicate within a single network, cross-network communication poses a unique challenge. To address this, we…
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…
High activity monitor (MS2005)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » High activity monitor (MS2005)
Name: High activity monitor Platform: Sqlserver Category: Performance Description: Collects SQL instance CPU usage, CPU usage of other processes, logical and physical reads, and active processes count on the SQL Server…
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…
The property file format
Customization » Property System » The property file format
Any queriable node in the dbwatch server can have properties. These can be statically set values or dynamically created. This document describes the format used to define dynamic properties. The file header Oracle…
Customization
Customization
dbWatch Control Center is designed to be customizable and much of the contents are developed inside the product In this section, we will go over how you can customize different parts of the product. To proceed, click on of the topics below: Customize dbWatch Views…
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…
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…
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…
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…
dbWatch engine alert
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » dbWatch engine alert
Name: dbWatch engine alert Platform: Sqlserver Category: Internal Internal Description: This procedure gathers statistics per database. Long description: This alert returns warning/alarm if there are several…
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…
Filegroups growth rate (MS2000)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Filegroups growth rate (MS2000)
Name: Filegroups growth rate Platform: Sqlserver Category: Capacity Description: This procedure collects space usage in all filegroups defined in each database. The undocumented ‘sp_MSforeachdb’ Stored Procedure…
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 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 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…
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…
capitalize function
Advanced Topics » FDL – Farm Data Language » Functions » capitalize function
Description Capitalizes a string Example Get and capitalize all instance names instance/name/capitalize() instance/capitalize(name) Syntax capitalize(expression) value/capitalize() ← concat function / distinct function →
Transaction log space usage (noschema)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Transaction log space usage (noschema)
Name: Transaction log space usage Platform: Sqlserver Category: Capacity Description: This procedure collects space usage in all filegroups defined in each database. The undocumented ‘sp_MSforeachdb’ Stored…
Failover cluster host switch
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Failover cluster host switch
Name: Failover cluster host switch Platform: Sqlserver Category: Cluster and Replication Description: Checks if an instance switched to a differen host i a Windows Server Failover Cluster (WSFC). Long…
Installation of SQL Performance package
Installing and using premium packages » SQL Performance package » Installation of SQL Performance package
Requirements for installation dbWatch Control Center release 2022-09-29 / 501 or newer License that includes SQL Performance module. It can be as the separate “SQL Performance Package” license or as part of a larger licence package. It is included in…
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…