Real database problems. Clean solutions.
Short, practical notes on monitoring, SQL safety, and production access.
Slow Queries with pg_stat_statements
Prioritize slow queries by total time, calls, and mean time. Continuously monitor statement behavior with low overhead.
PostgreSQL Replication Lag Analysis
Separate replication lag into send, write, flush, and replay stages. Continuously monitor trends across primary and standby.
PostgreSQL Lock Wait Analysis
Safely map blocked sessions to their blockers. Continuously monitor lock-wait duration and recurrence across workloads.
MongoDB COLLSCAN Production Impact
Evaluate `COLLSCAN` plans in the context of query intent and collection size. Continuously monitor recurring scans.
Diagnosing PostgreSQL WAL Growth
Separate WAL generation rate from retention causes. Continuously monitor disk impact to catch abnormal growth early.
SQL Server VLF Count Health
Inspect transaction-log `VLF` counts and status. Use moon to track the growth patterns that can produce unhealthy log layouts.
PostgreSQL Table and Index Bloat
Review table and index growth in workload context. Continuously monitor size changes to prioritize investigation candidates.
SQL Server CPU Pressure Analysis
Correlate CPU pressure with active requests, scheduler queues, and query cost. Use moon to monitor production trends continuously.
Detect SQL Server Plan Regression
Compare queries that slowed after a plan change using Query Store data. Use moon to track regression signals across production periods.
SQL Server Connection Storms
Break down sudden session growth by application and client source. Use moon to monitor production connection storms continuously.
SQL Server Query Store Health
Check Query Store state, size, and read-only reason. Use moon to continuously monitor whether performance history remains available.
Replication Slot WAL Retention
Inspect WAL retained by slots and consumer state. Continuously monitor disk risk to identify abandoned replication slots.
SQL Server Backup Verification
Review backup history together with verification evidence. Use moon to expose failed or overdue SQL Server backups continuously.
MongoDB Write Concern Configuration
Compare default `writeConcern` settings with durability expectations. Continuously monitor timeouts and acknowledgement behavior.
SQL Server Statistics Freshness
Review statistics age and modification counts in table context. Use moon to continuously track freshness and related query risk.
MongoDB Document Growth and Storage
Track changes in average document size and storage ratios. Detect schema growth effects on cache, disk, and network early.
MongoDB Election Instability
Investigate frequent primary changes with replica set evidence. Continuously monitor election trends to expose availability risk.
MongoDB Page Fault Analysis
Correlate operating-system page faults with disk and cache behavior. Continuously monitor sudden increases to preserve context.
SQL Server Replication Latency
Review transactional replication tracer history with agent state. Use moon to continuously track changes in delivery latency.
SQL Server Identity Exhaustion Risk
Compare identity consumption with data-type limits. Use moon to track exhaustion risk before inserts begin to fail in production.
tempdb Sizing and Contention
Review `tempdb` file sizing, growth, and page contention together. Use moon to track pressure as production workloads change.
SQL Server Memory Grant Pressure
Inspect waiting and oversized memory grants by query. Use moon to monitor workspace-memory pressure as workloads change.
SQL Server Implicit Conversions
Review implicit data-type conversions and their effect on access paths. Use moon to track the related query cost over time.
PostgreSQL Connection Saturation
Detect clusters approaching `max_connections` early. Use continuous monitoring to manage capacity and memory risk safely.
MongoDB Ticket and Queue Pressure
Review WiredTiger ticket use alongside queued operations. Identify sustained capacity pressure through continuous trends.
Investigate PAGEIOLATCH Waits
Correlate `PAGEIOLATCH` waits with file latency and query read volume. Use moon to track changing I/O pressure continuously.
PostgreSQL Connection Pool Health
Assess connection pools through queueing and backend use. Continuously monitor their database-side effects and capacity.
PostgreSQL Deadlock Investigation
Analyze deadlocks through transaction order and query context. Monitor recurrence continuously to isolate the root cause.
Investigate SQL Server WRITELOG Waits
Compare `WRITELOG` waits with log-file latency and transaction volume. Use moon to monitor changing write pressure continuously.
MongoDB Jumbo Chunk Problems
Safely inspect jumbo chunk metadata and investigate migration blockers. Continuously monitor distribution impact as data grows.
Always On AG Configuration Monitoring
Keep Always On availability group roles and operating modes visible. Use moon to track unexpected configuration drift.
Idle-in-Transaction Sessions
Identify the cause of `idle in transaction` sessions. Continuously track transaction age and application ownership.
MongoDB WiredTiger Cache Pressure
Review WiredTiger cache use, eviction activity, and read load together. Use continuous monitoring to distinguish sustained pressure.
PostgreSQL Disk Growth and Capacity
Separate disk growth into tables, indexes, WAL, and temporary files. Continuously monitor capacity trends and acceleration.
PostgreSQL work_mem Memory Pressure
Review `work_mem` risk at connection and plan level. Continuously monitor temporary-file trends before memory pressure grows.
SQL Server Wait Statistics Baseline
Interpret cumulative wait statistics in uptime context. Use moon to track changes in the production wait profile over time.
Vacuum Lag and Dead Tuples
Examine dead-row accumulation with vacuum history. Continuously monitor table-level change and cleanup rates over time.
How to Detect SQL Server Blocking
Find the blocking session, wait duration, and affected requests with safe SQL Server DMV queries, then build an alert that avoids noise.