YugabyteDB Performance Monitoring: Kill Slow SQL in 6 Steps

At 02:14 the p99 alert fires. Dashboards show the cluster is up, CPU looks unremarkable and every node is healthy. Yet checkout queries that took 8 ms now take 400. In a single-node database you [...]

YugabyteDB Performance Tuning: 15 Powerful, Proven Tips

In a single-node PostgreSQL server, a slow query usually means a slow plan. In a distributed SQL database, a slow query usually means too many network round trips. That one difference changes almost every rule [...]

Valkey consulting and support view of Valkey 9.1.2: release changes from the Valkey project mapped to the configuration block that protects each gain

Valkey 9.1.2 Performance and Scalability Improvements: 7 Proven Tuning Blocks and the Configuration That Keeps Them

Valkey 9.1.2 performance and scalability: what the release changed, an annotated valkey.conf in seven blocks (I/O threads, memory, persistence, clients, cluster, kernel, measurement) and a staged rollout plan.

[...]

Data Analytics

Databricks Long-Running Queries: 6-Step Troubleshooting Guide

Databricks long-running queries are rarely one problem. When a statement that used to finish in forty seconds starts taking nine minutes, the nine minutes are usually spread across a cold warehouse, a queue, a compilation [...]

Expensive SQL on Exadata 26.1: Read the Offload Numbers Before You Build the Index

The Exadata ticket we see most often is not about a slow query. It is about a cluster that runs hot for hours, an IORM plan that somebody keeps re-tuning, and a licence conversation about [...]

SQL Server 2025 Expensive Queries: 7 Proven Ways to Find and Fix Them by Latency and Resource Cost

"Expensive queries" is a phrase that hides two different problems. One is response time: a statement the application waits too long for. The other is resource efficiency: a statement that burns CPU, logical reads and [...]

Db2 13 for z/OS Index Efficiency: 8 Proven Troubleshooting Techniques

Most index efficiency problems on Db2 13 for z/OS are not I/O problems. They are CPU problems that look like I/O problems from a distance. Index efficiency is measured in getpages, and a four-level index [...]

Valkey 9.1 Performance: What Changed Inside the Engine and How to Measure It

Valkey 9.1 performance work is the reason the 9.1 line exists. The 9.1.0 release (2026-05-19) reworked the I/O threading queues, doubled the embedded-string threshold, turned the processor clock on by default, embedded sorted-set elements in […]

MongoDB Performance Troubleshooting: 7 Proven Fixes for 8.3

MongoDB performance troubleshooting changed materially with MongoDB 8.3 (GA 2026-05-04, current patch 8.3.8): the Cost-Based Ranker (CBR) is now part of the default plan-selection mechanism, query memory is finally a first-class measurable quantity, and slow [...]

Optimizing Redis for Mixed Read/Write Workloads

Optimizing Redis for mixed read/write workloads is one of the most critical challenges in modern high-performance system design. Redis is widely used as an in-memory data store for its exceptional speed, but production environments rarely [...]

MinervaDB

Enterprise Database Consulting, 24x7 Support and Remote DBA

Performance Engineering