Database Monitoring
Everything on SkillVeris tagged Database Monitoring — collected across the glossary, study notes, blog, and cheat sheets.
4 resources across 1 library
Interview Questions(4)
What Causes Replication Lag and How Do You Reduce It?
Replication lag is the delay between a write committing on the primary and that same write becoming visible on a replica, and it is typically caused by network…
How Do You Analyze a Slow Query Log to Find Optimization Targets?
Analyzing a slow query log means aggregating logged queries by their normalized pattern and ranking them by total cumulative time, not by the single slowest in…
What Key Metrics Should You Monitor for a Database?
The core database metrics to monitor are query latency and throughput, connection pool saturation, replication lag, cache hit ratio, disk I/O and space usage,…
How Do You Detect a Query Performance Regression?
You detect a query performance regression by continuously capturing query execution plans and timing statistics, comparing them against a historical baseline,…