Search
Related topics are listed below.
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…
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,…
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…
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…
Customize View using FDL
Customization » Monitoring » Customize View using FDL
Before proceeding to this section, you must be familiar with Farm Data Language. To give you an overview, Farm Data Language is a type of query dbWatch uses to read and display data to its user. Think of it as your query tool when using dbWatch. How to edit…
Pause
Using Control Center » Monitoring » Pause
Monitoring in dbWatch have two “levels” of pause. You can pause the monitoring on an instance altogether, meaning that the monitoring jobs will not execute. Or you can pause the alert forwarding, meaning that the jobs will execute but dbWatch will not send…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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”…
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 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…
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…
No-engine jobs
Customization » Monitoring » No-engine jobs
No-engine jobs No-engine jobs are monitoring jobs that does not run in the database engine. No-engine jobs are jobs that run on the dbWatch Server, and typically run a SQL statement and process the result of this statement in javascript. Example code for different…
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…
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…
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…
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…
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…
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…
Importing resources
Customization » Importing resources
Much of the functionallity in dbWatch is defined in xml files, including report specifications, task specifictions and management specifications. That means that functionallity can be modified by supplying new xml files to dbWatch. There are two ways of doing…
Installation of the Security and Compliance package
Installing and using premium packages » Security and Compliance package » Installation of the Security and Compliance package
Installation of the Security and Compliance package The Security and Compliance package is a premium package that comes with extra cost. If you want to get this package and its not part of your current license, please contact sales@dbwatch.com. To install the…
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…
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…
Release notes
About dbWatch Control Center » Release notes
dbWatch Control Center (2024-03-11) Download Important note Linux release is available as an apt repository, see Linux install guide All clients and servers need to be upgraded in a multi-server setup before the connection will resume due to network…
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…
Disclaimer
Advanced Topics » Product Security » Disclaimer
Disclamer The information contained in this Product Security Wiki is for reference purposes only. Nothing contained in this document or relayed verbally to any customer will be deemed to amend, modify or supersede the terms and conditions of any written agreement…
Job concepts
Using Control Center » Monitoring » Job concepts
This section will try to explain more in-depth some of the concepts used in monitoring jobs in Control Center. There are currently two types of jobs, engine jobs, and no-engine jobs. The main difference between them is where processing occurs. Engine jobs do the…
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…
Troubleshooting issues in SQL Performance package
Installing and using premium packages » SQL Performance package » Repository management and monitoring » Troubleshooting issues in SQL Performance package
Graph issues with monitoring has been switched off If for some reason dbWatch Control Center has not been connected to a database instance running SQL Performance package for an extended time, you can get odd statistics errors in the graphs. It will look like a linear…
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…
Jobs grouped by category
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by category
Jobs by category Jobs in Control Center are grouped by category to make it easier for users to locate the right monitoring job. The categories are: Availability Jobs that checks that the database and database related processes are functioning Capacity – Jobs…
SQL Performance package
Installing and using premium packages » SQL Performance package
SQL Performance package SQL Performance module is an optional extra cost 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…
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…
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.…
Job menus
Using Control Center » Monitoring » Job menus
Each job has a set of menus. They can be accessed if you right-click on a job. This gives you several options. “Run now” will trigger the job now, outside of the normal schedule. “Details” will open the job report, providing details about…
Using SQL Performance package on MySQL
Installing and using premium packages » SQL Performance package » Using SQL Performance package on MySQL
Navigating to the SQL Performance package dashboard Once the SQL statistics job is installed and have collected data, you can navigate to the dashboard. It is located in the management interface for that database instance. The pictures and descriptions are from…
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…
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…
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…
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…
Data Guard Archive Status Check (10g & 9i)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Data Guard Archive Status Check (10g & 9i)
Name: Data Guard Archive Status Check Platform: Oracle Category: Availability Description: Checks that the standby database is receiving archive files from master database. Long description: Task checks that the…
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…
Dataguard Archive Status
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Dataguard Archive Status
Name: Data Guard Archive Status Platform: Oracle Category: Availability Description: Checks that the standby database is receiving archive files from master database. Long description: Task checks that the…
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…
Buffer cache statistics
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for PostgreSQL » Buffer cache statistics
Name: Buffer cache statistics Platform: Postgres Category: Performance Description: Gets data cache statistics from pg_stat_database view. Long description: Task gets data cache statistic from pg_stat_database…
Table and index scan statistics
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for PostgreSQL » Table and index scan statistics
Name: Table and index scan statistics Platform: Postgres Category: Performance Description: This task gathers scan statistics on tables and indexes from pg_stat_all_tables view. Long description: Statistics from…
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…
Wait statistics
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Wait statistics
Name: Wait statistics Platform: Oracle Category: Performance Description: Collects waits statistics encountered by threads that executed. This task is based on the v$system_event dynamic performance view. Long…
User integration with Active Directory
Using Control Center » Domain Configuration » Managing users » User integration with Active Directory
The user integration with Active Directory offloads the password verification and storage from the dbWatch Control Center domain controller to Active Directory. Port openings To allow the correct communications between the dbWatch Server and the Active Directory…
Disk read statistics
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Disk read statistics
Name: Disk read statistics Platform: Oracle Category: Performance Description: Collects disk read statistics from v$system_event performance view for db file sequential and dbfile scattered read event. Long…
Wait statistics
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Wait statistics
Name: Wait statistics Platform: Sqlserver Category: Performance Description: Collects statistics about all waits encountered by threads that executed. This task is based on the sys.dm_os_wait_stats dynamic performance…
Platforms supported
About dbWatch Control Center » Platforms supported
Platforms supported for the main product. Current release supports the following platforms, versions, and setups: On-premise support Supports* Express edition, Standard edition, Standard edition one, Standard edition two, and Enterprise edition of the following…
Server memory statistics
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Server memory statistics
Name: Server memory statistics Platform: Sqlserver Category: Performance Description: This tasks collects statistics from the sys.dm_os_sys_info performance view about the memory resources available to and consumed by the…
RMAN incremental backup status
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » RMAN incremental backup status
Name: RMAN incremental backup status Platform: Oracle Category: Availability Description: Checks the status of RMAN incremental backup (input_type ‘DB INCR’) from V$RMAN_BACKUP_JOB_DETAILS performance view.…
Job scheduling check
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Job scheduling check
Name: Job scheduling check Platform: Oracle Category: Availability Description: Detecting failed scheduled jobs. The STATUS column in the Oracle dictionary view DBA_SCHEDULER_JOB_RUN_DETAILS is used to detect scheduled jobs…
RMAN recovery area backup status
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » RMAN recovery area backup status
Name: RMAN recovery area backup status Platform: Oracle Category: Availability Description: Checks the status of RMAN recovery area backup (input_type ‘RECVR AREA’) from V$RMAN_BACKUP_JOB_DETAILS performance…
Acknowledgement system
Using Control Center » Monitoring » Job concepts » Acknowledgement system
The acknowledgment system is designed to make sure that jobs that have had alarms in the past, but now have changed status, is known to the DBA. By default we list all un-acknowledged warnings or alarms in the “Alert Acknowledgement History” view. If…
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…
RMAN backup status (9)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » RMAN backup status (9)
Name: RMAN backup status Platform: Oracle Category: Availability Description: Checks the status of RMAN backup from V$RMAN_BACKUP_JOB_DETAILS performance view. Long description: Checks the status of RMAN backup…
RMAN backup status (8)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » RMAN backup status (8)
Name: RMAN backup status Platform: Oracle Category: Availability Description: Checks status of RMAN backup from V$RMAN_BACKUP_JOB_DETAILS performance view. Long description: Task checks the status of RMAN backup…
RMAN backup status
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » RMAN backup status
Name: RMAN backup status Platform: Oracle Category: Availability Description: Checks the status of RMAN full backup from V$RMAN_BACKUP_JOB_DETAILS performance view for input_type ‘DB FULL’. The procedure can…
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 →
RMAN backup status (10.1)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » RMAN backup status (10.1)
Name: RMAN backup status Platform: Oracle Category: Availability Description: Checks the status of RMAN backup from V$RMAN_BACKUP_JOB_DETAILS performance view. Long description: Checks the status of RMAN backup…
DBA jobs check
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » DBA jobs check
Name: Dba Jobs check Platform: Oracle Category: Availability Description: Detecting failed scheduled jobs in old style dba_jobs. Long description: The BROKEN column in the Oracle dictionary view DBA_JOBS is used…
SQL Server Error logs
Using Control Center » Management » Management on SQL Server » SQL Server Error logs
This view allows you to look at the SQL Server error logs and search and filter data. ← Backups / Databases →
Databases
Using Control Center » Management » Management on SQL Server » Databases
This view allows you to drill down into each database and its underlying data. ← SQL Server Error logs / Security →
RMAN backup status (10.2)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » RMAN backup status (10.2)
Name: RMAN backup status Platform: Oracle Category: Availability Description: Checks the status of RMAN backup from V$RMAN_BACKUP_JOB_DETAILS performance view. Long description: Checks the status of RMAN backup…
RMAN backup status (11)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » RMAN backup status (11)
Name: RMAN backup status Platform: Oracle Category: Availability Description: Checks the status of RMAN backup from V$RMAN_BACKUP_JOB_DETAILS performance view. Long description: Checks the status of RMAN backup…
Locks
Using Control Center » Management » Management on SQL Server » Server activity » Locks
Locks view current locks in the database and statistics. There is also a menu to get more session details. ← Blocking sessions history / Active processes →
File IO statistics
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » File IO statistics
Name: File IO statistics Platform: Oracle Category: Performance Description: Collects I/O statistics for data files. Long description: Returns I/O statistics for data files baseed on dynamic performance view…
Server activity
Using Control Center » Management » Management on SQL Server » Server activity
Server activity is a dashboard to get an overview of current sessions and statistics from multiple performance counters viewed together. There is also a menu to kill sessions or view last sql statements. ← Internal repository / Blocking sessions…
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…
Sessions performance
Using Control Center » Management » Management on SQL Server » Sessions performance
The Sessions performance view is part of the SQL performance package, which is an extra cost module, that might not be available if your license has not enabled it. For more details look at the documentation for this module here ← Sessions history / Disk…
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…
Monitor dashboards and overview screens
Product Overview » Monitor dashboards and overview screens
Being effective in database operations are one of the key focus areas for the dbWatch database operations team. This chapter will focus on the dashboards or overview screens used by our internal database operations team, what information they show, how they are used…
CPU load
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » CPU load
Name: CPU load Platform: Oracle Category: Performance Description: Checks CPU load using Oracle performance view v$osstat. Long description: Checks and collects CPU load statistics. The task also aggregates…
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…
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…
Query store status
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Query store status
Name: Query Store status Platform: Sqlserver Category: Capacity Description: Checks Query Store space usage in every database where it is enabled. Long description: Checks Query Store space usage in every…
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…
Email and SMS
Customization » Extensions and 3rd party integrations » Email and SMS
Configure In the dbWatch Monitor, go to the “Server”->”Server Extensions” menu. An item called “E-mail extension” should now be visible (v 5.2 or later). To configure the extension, select it and click “Configure”. You should now see the initial…
RMAN archivelog backup status
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » RMAN archivelog backup status
Name: RMAN archivelog backup status Platform: Oracle Category: Availability Description: Checks the status of RMAN archivelog backup from V$RMAN_BACKUP_JOB_DETAILS performance view. Long description: Checks…
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…
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…
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. …
Dashboards
Customization » Web server » Dashboards
Dashboard overview The main page for the dashboards: User and login To view dashboards, you need to login with a user that has at least read privileges on web. Default dashboards These are the default dashboards: Instance status: This dashboard…
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.…
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…
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…
Implementation
Customization » Monitoring » Editor for engine jobs » Implementation
The implementation steps are the most important section. It consists of code blocks that creates the contents of the job. Typically at least one table and a procedure. You can right-click on the “Implementation” tree element to add new code blocks. You…
Edit Report Templates
Using Control Center » Reporting » Edit Report Templates
Report Selection When you click on Server -> “Reporting” on the toolbar and then select “Edit Report Template”, you will see a list of all available report templates. Select the report template you wish to edit and click “OK”.…
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…
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…