dbWatch Features

Monitoring

• Monitor all instances in a single view: Oracle, MS SQL Server, Sybase, Postgres and MySQL. Any mix of versions and platforms can be gathered in a single view for fast, efficient monitoring. dbWatch supports standard, enterprise and cluster configurations equally well.
• Monitor performance, uptime, backup, load, connections, disk space, growth rates, table scans, logical reads, cache hit ratios, SQL statements and other critical info.
• Drill down from monitor overview to check admin issues in more detail with single click – all within the dbWatch tool.
• dbWatch can match your preferences – sort, group, filter and give names to servers and groups to adjust what you view.
• Automate all monitoring and routine maintenance tasks.
• Create custom dashboards and reports for performance monitoring.

Administration and analysis

• Full capabilities to manage all database instances.
• Go direct into administration mode from monitoring. No need to switch tools.
• Manage all platforms from one unified view. No need for multiple tools.
• Analyse performance, resource usage, load and growth rates.
• Create custom dashboards.
• Perform full system health checks and reporting.
• Automate admin maintenance tasks.
• Bulk import or automatic scanning of subnetworks for new servers to include.

Resource and licence management

• Full overview of all resources, including hardware, operating systems and database server licences.
• Full Oracle licence reporting allows you to prepare for and prevent licence audit surprises, and evaluate your usage.
• Complete statistics for all instances.
• Support for server consolidation through detailed reports and views.

SQL Worksheet

• Perform SQL queries on any server.
• Perform queries across all servers or on a selection.
• Works across all database platforms.

Platform for customisation

• dbWatch provides a complete platform for customisation and extension.
• All supplied tasks and procedures are written in native database language and supplied in source form.
• Customize or create new tasks and procedures in our Integrated Development Environment.
• Full version control and handling across upgrades.
• Easy to deploy on single, multiple or all servers with one click.

Security

• Supports Active Directory and Kerberos.
• Supports encrypted connections and certificates.
• Allows role-based access profiles and fine-grained control over privileges.
• dbWatch’s security makes it suitable for finance, defence, police, government and healthcare sectors.