Database Monitor centrally monitors database health and business statistics for your SQL databases. By combining deep monitoring with the agentless architecture of WatchTower®, Database Monitor takes action on the result of any SQL query using the strong operational model of WatchTower so you can use thresholds, notifications, and role-based dashboards to be proactive instead of reactive.

Centralized Deep Monitoring

Database Monitor performs deep monitoring that is more than just a 'ping check' - it actually connects to your databases, runs SQL, analyzes the results, thereby checking the performance of each query. Database Monitor's centralized approach requires far less effort and expertise than setting up separate database agents to perform similar tasks.

Monitoring the Health of Applications and Business Processes

Database Monitor helps keep your business running smoothly by analyzing and acting on your database health statistics. SQL checks can be encapsulated with business logic to monitor business processes - with the results feeding the WatchTower dashboards and any/all associated services, service levels or notifications.

Best Practice Template Library

Database Monitor provides a library to store best practice templates for performing health checks on your databases, and it comes with pre-built templates for Oracle and PostgreSQL. You configure the templates to define performance management SQL queries, desired result sets and thresholds which, when violated, trigger appropriate notifications, alerts or dashboard updates.

How Database Monitor Works

• Database administrators define and test target database connection strings
• SQL query groups are customized from pre-built templates and associated with target databases
• SQL query groups query the Data Dictionary and System Catalogs for database health or query any database for business statistics you want to monitor
• Powerful substitution variables are available to simplify queries by enabling a single query to loop through multiple databases or schemas
• Query result sets are configured using Boolean expressions including < > = for numeric results or string comparisons for alphanumeric results
• Database Monitor executes query groups monitor response times and results
• Response times and results are analyzed with query result sets to update executive dashboards, business service views, and SLA calculations
• When a test result fails or trips a threshold; WatchTower triggers defined notifications and escalations

Database Monitoring - General node Info page displaying database targets under node services list. This page automatically updates itself at a configurable interval and will update if a critical outage is discovered. Health check query group for an Oracle target database Target database add/edit page, which allows users to add query groups and substitution variables.

Target database console displaying db targets by name, database type, organization and IP Interface. Query group response time report, displaying descriptions for failed queries. Category configuration page that allows you to select rules for filtering which IP addresses, services and database targets will be included in the category.

Learn More — Get the Database Monitor datasheet >>