dbWatch Features

dbWatch - Database Monitoring

SIMPLE AND SCALABLE DATABASE MONITORING AND MANAGEMENT

Being a DBA is challenging at best of times. As the number of database instances keep growing and new platforms keep appearing, your job is not getting any easier. Maintaining performance and availability is your top responsibility and the job is not getting any easier. You can use all the help you can get in order to stay on top of the task.

dbWatch is designed from the bottom up to be a secure, scalable multi-platform database monitoring and management platform for demanding environments. Whether you have ten or a thousand instances, you will find a dbWatch solution that will let you manage performance, monitor resources and provide you with more complete overview of your installations, a deeper insight into performance and health of each instance, giving you more control with a dramatically reduced effort.

Whether you run SQL Server only, or have a mix of many platforms, you will find dbWatch gives you the perfect all-in-one tool you need to be effective. With overview and analytics, you will see the total situation across all instances, see where your attention is most required, and can directly manage any instance. No need for many tools and windows – in dbWatch you can do it all in the same user interface.

If you have special requirements or simply want to do things “your way”, with dbWatch you can modify or extend any task, any procedure or any report to suit your specific requirements. It’s simply the most powerful, complete, flexible and affordable database management platform in the market today.

Multi-platform, agent-less support. No need for multiple tools for separate platforms. dbWatch supports all versions of Oracle, MS SQL Server, Postgres, Sybase, MariaDB and MySQL, including advanced options like RAC and Data Guard. Manage all of your servers in a single solution.

Scalability. Whether you have tens, hundreds or even thousands of instances, dbWatch will deliver. Its unique, scalable architecture offers a complete platform for customisation and extension. With fast deployment and a small resource footprint, it all adds up to the most flexible database manager on the market.

DATABASE MONITORING

Pro-actively and manage any SQL Server, Oracle, Sybase, PostgreSQL or MariaDB database server. Fast, easy agent-less installation. Customizable views for easy and simple monitoring.

MANAGE DIRECT FROM MONITOR

Now you can manage any instance directly from the monitor view. See a problem – fix it directly in the same user interface. No longer need to have multiple windows, tools and logins to manage your instances.

SCALABLE MONITORING AND REPORTING

No other solution will scale up like dbWatch. Whether you have ten or thousands of instances, dbWatch scales up and gives you the overview and insight you need to be productive and on top of the situation.

CUSTOMIZABLE AND EXTENDABLE

Regardless of how many checks, tasks and alerts we include, there are always those special cases not covered. So we give you the tools to create your own, or extend or modify those we supply. dbWatch is the most customizable, flexible and scalable enterprise DBA solution available today.

SECURITY

With fine-grained, role-based access control dbWatch give you the security functionality you will need, whether you are in healthcare, government, defense or finance. Full AD and Kerberos integration with certificates and encrypted connections and tunneling supported.

FULLY CUSTOMIZABLE FILTERING AND GROUPING

You can sort or group your instances any way you like. Create your own groups, add tags and properties to any instance and sort or group as you wish. Extremely flexible and powerful and a must-have in large environments.

EXTENSIVE REPORTING AND DISTRIBUTION

dbWatch provides a comprehensive set of reports, from basic reports over backup, uptime and health status via complete analytics on performance, resource usage, growth rates to license analytics and server consolidation recommendations. And if you need more, create your own or modify or extend any of the standard reports. All reports can be configured for automatic scheduling and distribution, fully automating report production and distribution.

LICENSE MANAGEMENT

Monitor, analyze and report your license usage for SQL Server or Oracle. For Oracle, avoid costly license audit surprises by preventive license usage analytics. Discover whether you need Enterprise or standard database server licenses and save on licensing.

MULTI-SITE SUPPORT

Monitor and manage complex networks and sites with distributed dbWatch servers. Efficiently manage multi-site installations, protected subnets or hybrid cloud environments.

DATABASE AUTODISCOVER

Autoscanning of networks to discover new database instances help you catch all those new instances appearing all the time in development, marketing or other departments.

SERVER CONSOLIDATION SUPPORT

With many database servers in use, its hard to optimize usage. The server consolidation package provide continuous monitoring of servers and usage, and provide analytics and assistance in locating candidates for consolidation or finding which servers are no longer in use and can be decommissioned.

CROSS PLATFORM

dbWatch will work with almost any version of MS SQL Server, Azure, Oracle, Postgres, mySQL, MariaDB or Sybase.

SITE PERFORMANCE MANAGEMENT

View performance and capacity analytics of all your instances in global views, allowing you to compare performance and capacity across instances and prioritize your efforts where it is most needed.

DRILL-DOWN PERFORMANCE ANALYTICS

Select any instances and drill down to desired level in order to analyze performance, wait states and locks,, find heavy SQL queries or poor code like full table scans. View the underlying hardware resources or application behavior like too frequent executes, number of users and load over time or data model complexity. All the tools you need for a structured, systematic approach to performance analysis and optimization.

WEB DASHBOARD

Customize views and dashboards and publish on the webserver

AUTOMATION

Automatic maintenance with predefined jobs or add your own to schedule and automate all the routine tasks.

CLUSTER SUPPORT

dbWatch supports AlwaysOn, RAC cluster, Dataguard and other cluster technologies so you can view and manage clusters efficiently.

3^RD PARTY INTEGRATION

dbWatch connects to SCOM, Tivoli, Openview, Nimsoft, Nagios and many other tools

ADVANCED SECURITY

Active directory integration, dbWatch DBA audit, Kerberos support, SSL certificate based tunneling

CUSTOMIZABLE AND EXTENDABLE

If what we provide is not enough, you can customize and extend dbWatch almost endlessly. Customize tasks, schedules, reports, views, web dashboards or use the command-line scripting engine.

EXCEL INTEGRATION

Delivering cross database and cross platform statistics and data for easy Excel reporting and trend analysis

SERVICE PROVIDER EXTENSIONS

Enable customer separation in dashboards, reporting, monitoring, security and management. Ideal for managed service providers and others serving multiple clients.

Use dbWatch to consolidate servers, optimise hardware requirements, minimise costly database server licenses and reduce the routine workload on your database administrators. No other single solution gives you all the information and tools you need to run a lean and efficient database environment.

Stay in total control of your database environment by using dbWatch to monitor, manage and report. Automation of monitoring and alerts saves you time and money. Extensive and detailed reports and health checks keep you informed and prepared. Take advantage of real-time monitoring of performance and resource usage... go from reactive to pro-active with dbWatch.

For full product details see dbWatch product specification and licensing

Customize any procedure, task or report to suit your specific needs. Source included. An inbuilt development environment to manage versions, deployment and upgrades. Full command line interface (CLI) included.

Manage security. Role based access control, certificates, encryption, Active Directory and Kerberos are all standard features in dbWatch.

Connect to Nimsoft, Openview or any other infrastructure management platform through built-in connectors.

dbWatch Product Tour

Want to see more?

You find the complete set of dbWatch product documentation in our dbWatch product wiki or on the support pages.

If you need help with licensing, pricing, quotes or anything else you can contact sales.

Learn More About dbWatch

Our latest posts

Monitoring SQL Server error logs

As a data platform expert who manages and maintains hundreds or maybe thousands of database instances, you may be thinking of a better way in managing these number of servers more efficiently. An environment this huge with a lot of vital applications relying on those databases can be quite difficult to keep track of. Especially when you’re too busy with a lot of administration work, with little resources and time you might have difficulties prioritizing your daily tasks.

May 12, 2020

Assigning user roles in dbWatch

young engeneer business man with thin modern aluminium laptop in network server room

As a busy database administrator managing and monitoring tens or hundreds of database instances, you are plenty busy enough as it is. While you’re busy with your daily routine, sometimes your manager or developers would ask for your assistance regarding the status of a certain database you’re in charged with. As they were experiencing slow running queries, blocking sessions or deadlocks within the staging environment.

April 7, 2020

Performance alerts configuration with dbWatch

In an enterprise with multiple systems across various departments, database administrators find not only multiple database platforms such as Oracle and SQL Server, MySQL, PostgreSQL but also different versions of each platform. DBA's usually manage tens to hundreds up to thousands of database instances of different platforms and versions within the company.

Each database platform and sometimes each version come with their own set of tools, it is a waste of time switching through multiple applications just to monitor and manage hundreds of database instances.

dbWatch is the perfect solution to monitor and track all your instances for you. The dbWatch alert module is powerful and flexible, so you can configure precisely how you receive alerts, what alerts you receive, who receives them and at what time of the day or week. In this way you can create alert rules to match work schedules with different alert schemes for office hours, nighttime and weekends.

See the example below.

March 18, 2020

dbWatch Features

dbWatch - Database Monitoring