Articles tagged performance. View all articles
A practical guide to diagnosing MongoDB performance problems using serverStatus, mongostat, mongotop, currentOp and other built-in tools — with diagnostic queries and fix recommendations.
Step-by-step guide to finding MongoDB slow queries using the profiler and explain plans, understanding COLLSCAN vs IXSCAN, and fixing performance with the right indexes.
A practical step-by-step guide to reading and analyzing Oracle AWR reports: which sections to read first, what the numbers mean, how to identify root causes, and common patterns.
A complete guide to Oracle AWR (Automatic Workload Repository): what it is, how it works, what data it collects, how to use it for performance tuning, and its limitations.
Step-by-step guide to generating Oracle AWR reports in SQL*Plus: finding snapshots, choosing the right window, HTML vs text format, RAC environments, common errors, and how to read the output.
What Oracle wait events are, the 10 most common ones you'll see in AWR/ASH reports, diagnostic SQL queries for each, and step-by-step fixes.
A practical guide to pg_stat_statements: what it is, how to install it, the columns that matter, and example queries to find your slowest SQL.