Blog

SAP HANA
Database Consulting

How to Diagnose Slow Queries in SAP HANA: A Step-by-Step Guide

A repeatable 8-step workflow for diagnosing slow SAP HANA queries — from baseline to root cause to validated fix — using the SQL Plan Cache, Expensive Statements Trace, EXPLAIN PLAN, PlanViz and the column-store and delta-merge views, with runnable SQL. Need it fixed now? MinervaDB delivers expert SAP HANA performance tuning, consulting and 24×7 Remote DBA.

[…]

PostgreSQL Checkpoint Tuning
Data Strategy

PostgreSQL Checkpoint Tuning: Eliminating I/O Spikes and Recovery Risk

Default PostgreSQL checkpoint settings create latency spikes, inflate WAL volume, and put crash recovery at risk. This MinervaDB guide walks through every parameter, the new pg_stat_checkpointer view, and reference configurations for OLTP, write-heavy, and analytical workloads on PostgreSQL 16 and 17.

[…]

PostgreSQL RPO & RTO
Backup & DR

RPO/RTO planning for PostgreSQL

Production-ready PostgreSQL rpo rto playbook covering PostgreSQL diagnostics, parameter tuning, validation workflows, and monitoring that keep clusters fas.

[…]

Extensions

Hydra and columnar PostgreSQL

Hydra PostgreSQL guide for production PostgreSQL: diagnostic SQL, configuration tuning, validation steps, and monitoring practices for PostgreSQL 14, 15, 1.

[...]