Monitor applications and infrastructure running on-premises and in the cloud with comprehensive, built-in expertise for Oracle and MySQL databases.
Start monitoring targets after discovery. Get alerted on critical conditions and monitor performance in homepages. Customize thresholds to meet SLAs. Reduce downtime and prevent incidents by automating alert resolution with corrective actions. Effectively manage incidents with event compression. Use Dynamic Runbooks for faster incident resolution.
Monitor all aspects of database health—status, load, response, and performance—using more than 500 metrics. Monitor at scale using database fleet views to identify performance hotspots and open incidents. Drilldown to homepages to view active sessions, resource usage, and long running SQLs. Auto-resolve database down and tablespace full alerts with Corrective Actions.
Monitor MySQL status, response, and performance. View group replication metrics for InnoDB Clusters. Use homepages to monitor status, database activity, and critical incidents. Run explain plans to triage poor-performing queries that impact app performance. Safeguard MySQL by checking compliance against replication and security best practices.
Agents are used to collect metrics on targets and evaluate them against thresholds to generate alerts. The agents then send the alerts over to Enterprise Manager where an incident can be created from the alert. Once an incident is created, Enterprise Manager can notify DBAs and IT Ops teams via email, Webhooks, Slack, OS Commands, or SNMP Traps. These incidents can be managed directly within the Incident Manager console, or you can open tickets with systems such as ServiceNow and PagerDuty.
Define monitoring settings against different types of targets, such as production and test targets, using Monitoring Templates: one for production targets and another for test targets. Specify metric thresholds, add custom metrics (Metric Extensions), and attach Corrective Actions, which are scripts to auto-resolve alerts.
Use Monitoring Templates with Administration Groups to automatically apply monitoring settings.
Streamline database fleet monitoring using remote agents instead of local agents on each host. Auto-discover the full database system including RAC database, pluggable databases, listener, and ASM for immediate monitoring.
Use database fleet views to review open incidents and identify heavily loaded databases. Drilldown to specific databases to view active sessions, resource usage, long running SQLs, and access Performance Hub.
Customize metric threshold alerts. Use Corrective Actions, such as Add Space to Tablespace, when full and Startup Database when down. Use Metric Extensions based on custom SQL queries to meet unique database requirements.
Discover and monitor MySQL and InnoDB cluster environments. Use homepages to view current status, response time, database activity, and critical incidents.
Use Query Analyzer to identify poor-performing queries and triage by running explain plans.
Evaluate compliance of MySQL fleet against replication and security best practices. Monitor compliance violations in the Compliance Dashboard and review remediation recommendations.
Use Incident Rules to create incidents from actionable events, send notifications through communication tools, such as email and Slack, and open tickets with systems such as ServiceNow and PagerDuty.
Reduce incident volume with Event Compression Policies.
Use Incident Manager to track the lifecycle of your incident from creation to resolution. Use Dynamic Runbooks to capture your team's incident resolution steps and make these accessible to your IT Ops teams in Incident Manager as they work on resolving the incident.
Monitor conditions specific to your environment by creating your own metrics using Metric Extensions. Use the full development and test lifecycle to create Metric Extensions from scripts. Once tested, publish and deploy the Metric Extensions to individual targets or in bulk to many targets using Monitoring Templates.
Enterprise Manager Tech Forum 2024 replay.
Get started with Enterprise Manager Fundamentals: Monitoring Quick Tour.
Subscribe to the Observability and Management YouTube channel to get overviews about using Enterprise Manager for monitoring.
Interested in learning more about enterprise monitoring? Let one of our experts help.