For the modern enterprise, monitoring multi-platform database performance should be considered a key capability.
Concern over the performance of business-critical databases extends far beyond the confines of the database team.
While the responsibility to address and resolve performance issues usually falls to an organization’s database administrators (DBAs), many other individuals may want or need to know the current state of an enterprise’s databases.
Incorporating the tracking of database performance as a component of comprehensive monitoring efforts puts all the information necessary to understand the state of enterprise computing resources in a centralized location.
This can only be seen as a good thing by the operations team since it reduces the difficulty of maintaining a complex and diverse environment.
IDERA’s Uptime Infrastructure Monitor provides the functionality required to identify potential database performance issues as part of an all-inclusive monitoring scheme.
Uptime enables monitoring of the complete physical, virtual, and cloud environment from a unified and fully customizable interface.
Teams can create custom dashboards that focus on the infrastructure elements that interest them, including groups of database servers or specific database instances. With color-coded alerts and status summaries, Uptime makes it easy to identify problems so they can be addressed promptly.
Uptime uses service monitors that check the availability and performance of infrastructure elements and services. The tool issues an alert if issues are discovered.
Uptime’s functionality is extended by advanced monitors that are available as plug-ins. The advanced monitors employ custom scripts and programs that don’t need to interact with an agent on monitored systems.
Uptime offers advanced monitors for major relational database management systems (RDBMS). It is compatible with Microsoft SQL Server, Oracle Database, MySQL and MariaDB, IBM Db2, PostgreSQL, and SAP (Sybase) ASE (Adaptive Server Enterprise).
Following is an overview of the specific monitors available for each database platform:
Uptime offers the following monitors for SQL Servers:
For Oracle databases, Uptime provides the following monitors:
The following monitors report on MySQL and MariaDB database instances:
For IBM Db2, the following monitors are available:
Monitors are also available for PostgreSQL and SAP that report on system availability, valid response, and response time to serve as an early warning system for database problems.
Download this IDERA solution brief for a more extensive look at monitoring database performance with Uptime. The document includes screenshots that illustrate the customized dashboards that can be created with the tool.
Try Uptime with a 30-day free trial.
Powered by IDERA