Topic

Database Performance

16 resources on database performance

PostgreSQL MonitoringOracle Enterprise ManagerOpenTelemetryObservabilityOracle CloudLogging AnalyticsDatabase PerformanceCloud MonitoringCost OptimizationGetting StartedCase StudyStorage MonitoringVirtualizationSimulation TestingAIOps
Is This Database Slower Than Last Month? Workload History and the Agent-Local History Store
Blog

Is This Database Slower Than Last Month? Workload History and the Agent-Local History Store

pg_stat_statements counts everything since its last reset, which answers what is expensive overall but not what changed this week. Workload History snapshots those counters into a per-target store on the Enterprise Manager agent and replays them over any window you choose, from the whole workload down to one statement. Wait-event sampling adds what each statement was waiting on, and the Retention Policies page sets how long each kind of history is kept. Part four of four on the advisory features in the PostgreSQL Plug-in for Oracle Enterprise Manager.

Oct 6, 2026

Webinar – Introducing the SQL Server Plug-in for Oracle Enterprise Manager
Upcoming Webinar

Webinar – Introducing the SQL Server Plug-in for Oracle Enterprise Manager

November 10, 2026 at 1:00 PM ET. A live walkthrough of the general release: SQL Server 2016 through 2025 monitored and managed from the Oracle Enterprise Manager console, with Always On failover readiness, query history, and backups and failovers run as Oracle EM jobs. 60 minutes with live Q&A. Register and the recording and slides come to you either way.

Nov 10, 2026

Why Isn't Autovacuum Keeping Up? The Vacuum Advisor and the xmin Horizon
Blog

Why Isn't Autovacuum Keeping Up? The Vacuum Advisor and the xmin Horizon

When a table keeps growing while autovacuum is running, the cause is usually one of three things: the table's own storage parameters moved its trigger point, cleanup runs too rarely for the churn, or something is holding the transaction horizon so no vacuum can remove dead rows. The Vacuum Advisor recomputes each table's trigger point from its effective settings, estimates avoidable growth with pgstattuple, names whatever is holding the xmin horizon with the command that releases it, and tracks transaction-ID age against the wraparound limit. Part three of four on the advisory features in the PostgreSQL Plug-in for Oracle Enterprise Manager.

Oct 2, 2026

Webinar – What's New with the PostgreSQL Plug-in for Oracle Enterprise Manager
▶
Webinar

Webinar – What's New with the PostgreSQL Plug-in for Oracle Enterprise Manager

Recorded September 23, 2026. Plan Analysis, the Plan Drift Advisor, the Index Advisor, the Vacuum Advisor, and Workload History, demonstrated live in the Enterprise Manager 24ai console, plus how their findings become Enterprise Manager alerts.

Sep 23, 2026

Is This Query Still Running the Baseline Plan? Plan Analysis and the Plan Drift Advisor
Blog

Is This Query Still Running the Baseline Plan? Plan Analysis and the Plan Drift Advisor

When a query that was fine last week turns slow, the evidence you need is the plan it actually ran, and that plan is usually gone by the time anyone looks. Plan Analysis keeps it, captured by auto_explain during the query's own execution with nothing re-run, and checks it against five detection rules. The Plan Drift Advisor keeps each query's accepted baseline plans and tells you when a query leaves them. Part two of four on the advisory features in the PostgreSQL Plug-in for Oracle Enterprise Manager.

Sep 21, 2026

Which Index Should You Actually Create? HypoPG, pg_qualstats, and the PostgreSQL Index Advisor
Blog

Which Index Should You Actually Create? HypoPG, pg_qualstats, and the PostgreSQL Index Advisor

Most index advice is a hunch with a table name attached: this table gets scanned a lot, so maybe index something on it. The Index Advisor in the August 2026 release of the PostgreSQL Plug-in for Oracle Enterprise Manager replaces the hunch with two kinds of evidence. HypoPG prices a candidate index by planning against it without building it, and pg_qualstats reports the predicates your workload actually ran that no index served. Part one of four on the release's advisory features: how each layer works, where each one stops, why they deliberately disagree, and what it takes to install them.

Sep 9, 2026

Now in Open Beta: MySQL, SQL Server, and Db2 Plug-ins for Oracle Enterprise Manager
Blog

Now in Open Beta: MySQL, SQL Server, and Db2 Plug-ins for Oracle Enterprise Manager

As of September 1, 2026, all three Integration Plumbers database plug-ins for Oracle Enterprise Manager are in Open Beta: MySQL, Microsoft SQL Server, and IBM Db2. Each one makes its engine a first-class target in the console you already run, collects with a read-only account over an encrypted connection, and ships thresholds and compliance rules that work on day one. Here's what each plug-in covers, what Open Beta means in practice, and the four steps to get a license key, install it against your own estate, and tell us what you find before general availability.

Sep 1, 2026

Was That Query Always This Slow? The Query-History Gap in MySQL, SQL Server, and DB2
Blog

Was That Query Always This Slow? The Query-History Gap in MySQL, SQL Server, and DB2

Your database can tell you which queries are slow right now. It usually can't tell you which ones got slower, because the per-query numbers it keeps are a running total with no time axis: reset on restart, or evicted as a cache fills. Here's the query-history gap in MySQL, Microsoft SQL Server, and DB2, why SQL Server is the exception that proves the point, and why the trend belongs in the Oracle Enterprise Manager repository, including the unglamorous work of making the subtraction honest.

Aug 24, 2026

Least-Privilege by Design: One Read-Only, TLS-First Way to Monitor DB2, SQL Server, and MySQL
Blog

Least-Privilege by Design: One Read-Only, TLS-First Way to Monitor DB2, SQL Server, and MySQL

Every database monitoring tool eventually meets the security team, and the answer is usually a broad-privilege account plus an agent installed on the database host. That's a design choice, not a law of nature. Here's the posture shared by all three Integration Plumbers plug-ins for Oracle Enterprise Manager: one read-only grant per engine, an encrypted connection that won't quietly downgrade, your choice of where collection runs, and why that same design reaches a managed cloud database without a rebuild.

Aug 13, 2026

No Cliff, No Drama: Db2 11.5 to April 2027, 12.1 Open-Ended, and the New Ground Ahead
Blog

No Cliff, No Drama: Db2 11.5 to April 2027, 12.1 Open-Ended, and the New Ground Ahead

While MySQL and SQL Server admins spent this summer watching end-of-support dates pass, DB2's is still ahead: IBM supports Db2 LUW 11.5 until April 30, 2027, and hasn't published an end-of-support date for 12.1 at all. Here's why that runway makes now the right time to fix DB2 monitoring rather than scramble at it, the compliance rule that flags your 11.5 estate the day the date passes, what the DB2 Plug-in for Oracle Enterprise Manager closes that even IBM's free Data Management Console leaves open, and the ground on the roadmap in Db2 for z/OS and the 12.1 AI Query Optimizer.

Jul 29, 2026

After MEM: The Next Chapter for MySQL Monitoring in Oracle Enterprise Manager
Blog

After MEM: The Next Chapter for MySQL Monitoring in Oracle Enterprise Manager

MySQL Enterprise Monitor reached end of life in January 2025, and Oracle guided customers to its Enterprise Manager plug-in as the path forward. Oracle has since published a deprecation notice for that plug-in through My Oracle Support. The MySQL Plug-in for Oracle Enterprise Manager from Integration Plumbers provides continuity: the same console, the MEM features the Oracle plug-in didn't include, and a collection layer built for MySQL 8.4.

Jul 16, 2026

SQL Server 2016 End of Support: What Your Monitoring Should Do About the July 14 Cliff
Blog

SQL Server 2016 End of Support: What Your Monitoring Should Do About the July 14 Cliff

On July 14, 2026, SQL Server 2016 leaves extended support, the same month Microsoft's surviving SQL tooling has gone paid, Azure-first, and Windows-only, with AWS force-upgrading any remaining RDS 2016 instances to 2019 that September. Here's what your monitoring should do about the version cliff, and how the Microsoft SQL Server Plug-in for Oracle Enterprise Manager flags what's stranded and follows your databases to 2017 through 2025 on Windows and Linux.

Jul 8, 2026

The DR-Readiness Gap: Why "Synchronized" Isn't "Safe" in MySQL, SQL Server, and DB2
Blog

The DR-Readiness Gap: Why "Synchronized" Isn't "Safe" in MySQL, SQL Server, and DB2

Every HA tool shows you a synchronization state. Almost none of them, by default, tells you how much data you'd lose or how long recovery would take if you failed over right now. Here's the DR-readiness gap in MySQL, SQL Server, and DB2, and why the answer belongs in the Oracle Enterprise Manager repository.

Jul 1, 2026

The Backup You Can't See: The Database Backup Blind Spot in MySQL, SQL Server, and DB2
Blog

The Backup You Can't See: The Database Backup Blind Spot in MySQL, SQL Server, and DB2

Your observability stack alerts on CPU, connections, and replication lag. Out of the box, it rarely tells you whether last night's backup succeeded — or whether you could actually recover. Here's the backup blind spot, and why it belongs in the Oracle Enterprise Manager console.

Jun 22, 2026

Why a Fortune 100 Bank Chose Integration Plumbers for PostgreSQL Monitoring at Scale
Blog

Why a Fortune 100 Bank Chose Integration Plumbers for PostgreSQL Monitoring at Scale

When a global bank needed to monitor 2,000+ PostgreSQL instances across 40 countries, every solution they evaluated fell short — except one. Here's why scale made the difference.

Feb 24, 2026

The Integration Plumbers' PostgreSQL Plug-in and The High Cost of Database Downtime
Blog

The Integration Plumbers' PostgreSQL Plug-in and The High Cost of Database Downtime

How the PostgreSQL plugin for Oracle Enterprise Manager helps prevent costly database downtime.

Feb 13, 2025

Not Sure Where to Start?

Take our free OTEL Maturity Assessment to identify gaps and get a personalized action plan.

Take the Free Assessment