Data Monitoring
A synchronized-looking replica has an untested application reconnect path. Review replica health alongside listener connectivity, login dependencies and a documented failover exercise.
SQL Server Availability & Capacity2 min read
Read article : SQL Server: Failover readiness
Data Monitoring
Integrity checks return an error while reports still load. Preserve check output, affected object scope and backup availability.
SQL Server Availability & Capacity1 min read
Read article : SQL Server: Database corruption response
Data Monitoring
A database volume is above a static warning level but growing rapidly. Compare free bytes, recent growth rate and planned batch expansion.
SQL Server Availability & Capacity2 min read
Read article : SQL Server: Disk free-space forecasting
Data Monitoring
A nearly full data file still has room to grow on disk, while another file cannot. Measure used file space, allocated file size, maximum size and volume free space separately.
SQL Server Availability & Capacity2 min read
Read article : SQL Server: Database file space versus volume space
Data Monitoring
Authentication failures increase after a service account rotation. Group error evidence by account, client and first occurrence while protecting credentials.
SQL Server Availability & Capacity1 min read
Read article : SQL Server: Login failure patterns
Data Monitoring
A monitoring chart shows a dramatic improvement after a restart. Compare instance uptime with cumulative counter reset boundaries.
SQL Server Availability & Capacity2 min read
Read article : SQL Server: Server restart counter resets
Data Monitoring
A collector returns fewer rows after a database upgrade. Compare collector errors, documented DMV permissions and the effective monitoring identity.
SQL Server Availability & Capacity2 min read
Read article : SQL Server: Monitoring permission changes
Data Monitoring
A hardware upgrade is proposed without a demonstrated resource bottleneck. Correlate CPU, waits, I/O, memory pressure and user latency over the same workload period.
SQL Server Availability & Capacity2 min read
Read article : SQL Server: Capacity change evidence
Data Monitoring
A PostgreSQL application slows while the database remains reachable. Inspect pg_stat_activity with state, wait event, query start and application identity.
PostgreSQL Monitoring2 min read
Read article : PostgreSQL: Active session triage
Data Monitoring
An apparently idle connection keeps a transaction open for a long time. Compare xact_start, state and application ownership with blocking and cleanup symptoms.
PostgreSQL Monitoring2 min read
Read article : PostgreSQL: Idle-in-transaction sessions
Data Monitoring
Many PostgreSQL sessions wait on locks during a deployment. Use pg_blocking_pids with activity evidence and capture the head transaction's context.
PostgreSQL Monitoring2 min read
Read article : PostgreSQL: Blocking session relationships
Data Monitoring
A query performance dashboard is empty on a new PostgreSQL host. Check whether pg_stat_statements is installed and configured for the intended collection scope.
PostgreSQL Monitoring2 min read
Read article : PostgreSQL: Statement statistics coverage