Search
Related topics are listed below.
Database operations philosophy
Product Overview » Database operations philosophy
The reasons for database operations The value of database operations comes from the value of the systems the databases support. . In a typical operation, the value of the managed systems is much greater than the resources used on the operations side. Running a…
[Database 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) →
Database load
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MySQL » Database load
Name: Database load Platform: Mysql Category: Performance Description: Provides information on the server load Long description: Task provides infomation on the server load in the database…
Database status
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database status
Name: Database status Platform: Sqlserver Category: Availability Description: Checks if all databases have status ONLINE Long description: A database state specifies the current running mode of that database.…
Database backup
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database backup
Name: Database backup Platform: Sqlserver Category: Availability Description: This procedure analyzes the backup statistics (type D and I) from the msdb.dbo.backupset table (excluding the system databases: master, model and…
Database mirroring
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database mirroring
Name: Database mirroring Platform: Sqlserver Category: Cluster and Replication Description: Checks state information of all mirrored databases. Long description: Checks state information of all mirrored…
Database statistics
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database statistics
Name: Database statistics Platform: Sqlserver Category: Availability Description: This procedure gathers statistics per database. Long description: Version: 1.8 Default schedule: 0 5 6…
Database load
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » Database load
Name: Database load Platform: Mariadb Category: Performance Description: Provides information on the server load Long description: Task provides infomation on the server load in the database…
Database backup
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Sybase » Database backup
Name: Database backup Platform: Sybase Category: Availability Description: Checks backup status of all databases. Long description: Version: 1.1 Default schedule: 50 5 *…
Database status
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Sybase » Database status
Name: Database status Platform: Sybase Category: Availability Description: Checks status of all databases defined on the system. The following incidents triggers a warning or an alarm: Long…
Database uptime
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Database uptime
Name: Database uptime Platform: Oracle Category: Availability Description: Collects database uptime statistics for all instances mounted on the database. Long description: Collects database uptime statistics for…
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…
Database status (MS2000)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database status (MS2000)
Name: Database status Platform: Sqlserver Category: Availability Description: Checks if all databases have status ONLINE Long description: Version: 2 Default schedule: 0 * *…
Database server uptime
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database server uptime
Name: Database Server uptime Platform: Sqlserver Category: Availability Description: Collects database server uptime statistics. Long description: Version: 2.2 Default schedule: * *…
Database backup (noschema)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database backup (noschema)
Name: Database backup Platform: Sqlserver Category: Availability Description: This alert checks if the instance has been restarted since the last check Long description: This job checks the backup statistics…
Database status (noschema)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database status (noschema)
Name: Database status Platform: Sqlserver Category: Availability Description: This alert checks if the instance has been restarted since the last check Long description: Version: 2 Default…
Database disk capacity
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database disk capacity
Name: Database disk capacity Platform: Sqlserver Category: Capacity Description: Checks free space on drives where data and transaction log files are defined. An alarm (or warning) is raised if the percentage limit is…
Database backup (MS2000)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database backup (MS2000)
Name: Database backup (2000) Platform: Sqlserver Category: Availability Description: This procedure analyzed the backup statistics from msdb.dbo.backupset table (excluding system databases: master, model and…
Database session load
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database session load
Name: Database session load Platform: Sqlserver Category: Performance Description: Shows the number of connections over time per database, host and application. Long description: Each time the procedure is…
Sessions per database
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Sessions per database
Name: Sessions per database Platform: Sqlserver Category: Performance Description: This task returns aggregate performance statistics based on sessions connected to the SQL Server instance. Long…
Database load (old)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » Database load (old)
Name: Database load Platform: Mariadb Category: Performance Description: Provides information on the server load Long description: Task provides infomation on the server load in the database…
Database space check
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Sybase » Database space check
Name: Database space check Platform: Sybase Category: Capacity Description: Checks the amount of free space in all databases. Long description: Version: 2.1 Default schedule: 10 5,17 *…
Database backup (SIMPLE)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database backup (SIMPLE)
Name: Database backup (SIMPLE) Platform: Sqlserver Category: Availability Description: This procedure analyzes the backup statistics (type D) from the msdb.dbo.backupset table for databases in SIMPLE recovery model…
Database log backup
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database log backup
Name: Database Log backup Platform: Sqlserver Category: Availability Description: This procedure checks the database transaction log backups from the msdb.dbo.backupset table (excluding system databases: master, model and…
Database mount state
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Database mount state
Name: Database mount state Platform: Oracle Category: Availability Description: Checks the ‘soft limit’ and the ‘hard limit’ of the maximum number of physical OS files, that can be mapped to an…
Database link check
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Database link check
Name: Database link check Platform: Oracle Category: Availability Description: Checks database links. Long description: In order to check private database links you have to create a following view ‘create…
Database growth rate (aggregated)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MySQL » Database growth rate (aggregated)
Name: Database growth rate (aggregated) Platform: Mysql Category: Capacity Description: Collects database size and visualizes the growth rate of the server. Long description: Collects database size and…
Database growth rate (detailed)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MySQL » Database growth rate (detailed)
Name: Database growth rate (detailed) Platform: Mysql Category: Capacity Description: Collects detailed growth rate information. Long description: Collects detailed information on the growth rate of the database…
Check database recovery mode
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Check database recovery mode
Name: Check database recovery mode Platform: Sqlserver Category: Availability Description: Checks if all databases are running in FULL or SIMPLE recovery mode. Long description: Checks if all databases are…
Database Server uptime (MS2000)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database Server uptime (MS2000)
Name: Database Server uptime Platform: Sqlserver Category: Availability Description: Collects database server uptime statistics. Long description: Version: 1.9 Default schedule: * *…
Database server uptime (MS2005)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database server uptime (MS2005)
Name: Database Server uptime Platform: Sqlserver Category: Availability Description: Collects database server uptime statistics. Long description: Version: 2.2 Default schedule: * *…
Database log backup (noschema)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database log backup (noschema)
Name: Database log backup Platform: Sqlserver Category: Availability Description: This alert checks if the instance has been restarted since the last check Long description: This job checks the transaction log…
Missing database backup (noschema)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Missing database backup (noschema)
Name: Missing database backup Platform: Sqlserver Category: Availability Description: This alert checks if the instance has been restarted since the last check Long description: This job checks for each database…
Database growth rate (aggregated)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database growth rate (aggregated)
Name: Database growth rate (aggregated) Platform: Sqlserver Category: Capacity Description: Collects size of all database files (including transaction log files) to visualize the growth rate for all databases. Long…
Database growth rate (detailed)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database growth rate (detailed)
Name: Database growth rate (detailed) Platform: Sqlserver Category: Capacity Description: Collects size of database files (including transaction log files) to visualize the growth rate for the largest…
Database disk space usage
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database disk space usage
Name: Database disk space usage Platform: Sqlserver Category: Capacity Description: Checks free space on drives where all data and transaction log files are defined. Drives where no data files exist will be…
Database disk capacity (noschema)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database disk capacity (noschema)
Name: Database disk capacity Platform: Sqlserver Category: Capacity Description: This procedure collects space usage in all filegroups defined in each database. The undocumented ‘sp_MSforeachdb’ Stored Procedure…
Temporary database space usage
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Temporary database space usage
Name: Temporary database space usage Platform: Sqlserver Category: Capacity Description: Checks space usage in tempdb database, and collects statistics including size of data and transaction log files. Long…
Database backup (system dbs)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database backup (system dbs)
Name: Database backup (system dbs) Platform: Sqlserver Category: Availability Description: This procedure analyzed the system database backups statistics from msdb.dbo.backupset table. Long…
AlwaysOn database backup alert
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » AlwaysOn database backup alert
Name: AlwaysOn database backup alert Platform: Sqlserver Category: Cluster and Replication Description: Checks the status of each member node of the current WSFC cluster based on Dynamic Management Views…
Database growth rate (aggregated)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » Database growth rate (aggregated)
Name: Database growth rate (aggregated) Platform: Mariadb Category: Capacity Description: Collects database size and visualizes the growth rate of the server. Long description: Collects database size and…
Database growth rate (detailed)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » Database growth rate (detailed)
Name: Database growth rate (detailed) Platform: Mariadb Category: Capacity Description: Collects detailed growth rate information. Long description: Collects detailed information on the growth rate of the…
Database space check (12)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Sybase » Database space check (12)
Name: Database space check Platform: Sybase Category: Capacity Description: Checks the amount of free space in all databases. Long description: Version: 2.1 Default schedule: 10 5,17 *…
Database growth rate (detailed)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Sybase » Database growth rate (detailed)
Name: Database growth rate (detailed) Platform: Sybase Category: Capacity Description: Collects database growth rates statistics. Long description: Version: 1.3 Default schedule: 10 6…
Database backup (system databases)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database backup (system databases)
Name: Database backup (system databases) Platform: Sqlserver Category: Availability Description: This procedure analyzes the FULL backup statistics for the system databases (master, model and msdb) using data from the…
Database 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…
Database network statistics (SQL*NET)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Database network statistics (SQL*NET)
Name: Database network statistics (SQL*NET) Platform: Oracle Category: Performance Description: Checks database network SQL*NET statistics. Long description: Task checks database network SQL*NET…
Missing database log backup (noschema)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Missing database log backup (noschema)
Name: Missing database log backup Platform: Sqlserver Category: Availability Description: This alert checks if the instance has been restarted since the last check Long description: This job checks for each…
Database growth rate (aggregated) (MS2000)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database growth rate (aggregated) (MS2000)
Name: Database growth rate (aggregated) Platform: Sqlserver Category: Capacity Description: Collects size of all database files (including transaction log files) to visualize the growth rate for all databases. Long…
Database growth rate (detailed) (MS2000)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database growth rate (detailed) (MS2000)
Name: Database growth rate (detailed) Platform: Sqlserver Category: Capacity Description: Collects size of all database files (including transaction log files) to visualize the growth rate for all databases. Long…
Buffer cache reads per database
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for PostgreSQL » Buffer cache reads per database
Name: Buffer cache reads per database Platform: Postgres Category: Performance Description: Collects the number of block fetch requests for table or index per database. Long description: Collects the number of…
Disk block reads per database
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for PostgreSQL » Disk block reads per database
Name: Disk block reads per database Platform: Postgres Category: Performance Description: Collects the number of disk block fetch requests for table or index per database. Long description: Collects the number…
Check database and server principal mapping
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Check database and server principal mapping
Name: Check database and server principal mapping Platform: Sqlserver Category: Maintenance Description: Checks if the database owner (dbo) is maped into any Server Login (server principal). Long…
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 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…
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 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…
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…
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…
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…
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…
Supported Web Browsers for dbWatch Dashboard
Customization » Web server » Supported Web Browsers for dbWatch Dashboard
As of the current version, dbWatch Dashboard supports the following web browsers: Google Chrome Microsoft Edge Firefox Why These Browsers? Our focus on Google Chrome and Microsoft Edge is driven by several factors: Advanced Features and Standards These…
Configuring email extension for Service Now
Customization » Extensions and 3rd party integrations » Email and SMS » Configuring email extension for Service Now
Integration with Servicenow In this example we will configure dbWatch and Servicenow so that alarms from dbWatch, can create incidents in Servicenow. To integrate the alerts from dbWatch with Servicenow incident creation, there are two parts that needs to be setup.…
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…
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…
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…
Product Description
Advanced Topics » Product Security » Product Description
Product Description dbWatch Control Center is a database operations software intended to monitor, manage, maintain and report on database instances across multiple database platforms and physical locations. A dbWatch Control Center environment has at its core a…
Product Overview
Product Overview
Product Overview In Product Overview, we will look into architecture and structure and give an overview of how the application operates. Chapters: Architecture File Structure Network and communications Database Operations Philosophy Monitor Dashboards and…
Security and Compliance package
Installing and using premium packages » Security and Compliance package
Security and Compliance package The Security and Compliance package is an optional extra cost module in dbWatch Control Center that allows automated detection and reporting on security and compliance-related issues where database instances are not conforming to best…
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…
Autogrow settings
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Autogrow settings
Name: Autogrow settings Platform: Sqlserver Category: Maintenance Description: Checks database files auto-growth settings. Long description: The default auto-grow settings associated with the model database are…
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…
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…
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…
Availability
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by category » Availability
Jobs in the Availability category Control Center Jobs Description Oracle 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…
Capacity
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by category » Capacity
Jobs in the Capacity category Control Center Jobs Description Oracle ASM disk statistics Checks ASM disks for status and statistics. ASM diskgroup space Checks ASM diskgroups space statistics. Monitor SYS.AUD$…
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…
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…
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…
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…
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.…
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…
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…
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…
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,…
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…
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…
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…
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…
Report
Customization » Monitoring » Editor for engine jobs » Report
The report section of a job is a lightweight version of the reporting engine in Control Center. It supports SQL queries that can be used in multiple output formats, such as graphs and tables. You can right-click on the “Report” item, add new…
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…
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…
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…
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”…
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…
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…
Segment size collector (large segments -- detail)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Segment size collector (large segments -- detail)
Name: Segment size collector (large segments — detail) Platform: Oracle Category: Capacity Description: Collects size and extent number info for larger segments in the database. Long description: Task…
Truncate transaction log
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Truncate transaction log
Name: Truncate transaction log Platform: Sqlserver Category: Capacity Description: This procedure truncates the transaction log for the dbWatch database. Long description: This procedure truncates the…