- PostgreSQL - DBA Toolkit - Blocking and Lock Waits
2026-04-17 — Find exactly who is blocking who in PostgreSQL — the blocking session, the waiting session, and the query that started the pile-up.
#postgresql
#dba
#monitoring
#blocking
#locks
#troubleshooting
#tool-kit
- PostgreSQL - DBA Toolkit - Checkpoint and WAL Health
2026-04-17 — Monitor PostgreSQL checkpoint frequency, WAL generation rate, and background writer pressure to catch I/O storms before they hit.
#postgresql
#dba
#monitoring
#performance
#wal
#checkpoints
#tool-kit
- PostgreSQL - DBA Toolkit - Connection Limits and Pooling
2026-04-17 — Check connection usage against limits, spot idle connections burning slots, and know when you are close to refusing new clients.
#postgresql
#dba
#monitoring
#connections
#pooling
#tool-kit
- PostgreSQL - DBA Toolkit - Database Size and Growth
2026-04-17 — See database and table sizes at a glance, identify the biggest objects, and spot growth before it fills the disk.
#postgresql
#dba
#monitoring
#storage
#growth
#tool-kit
- PostgreSQL - DBA Toolkit - Deadlocks
2026-04-17 — Track deadlock counts per database, identify tables with active lock contention, and surface the transactions involved.
#postgresql
#dba
#monitoring
#deadlocks
#locking
#troubleshooting
#tool-kit
- PostgreSQL - DBA Toolkit - Index Bloat and Health
2026-04-17 — Find bloated, unused, and duplicate indexes in PostgreSQL — the silent performance killers that accumulate over time.
#postgresql
#dba
#monitoring
#indexes
#bloat
#performance
#tool-kit
- PostgreSQL - DBA Toolkit - Long Running Queries
2026-04-17 — Spot long-running queries and idle transactions in PostgreSQL before they block autovacuum, hold locks, and cause a cascade of timeouts.
#postgresql
#dba
#monitoring
#performance
#queries
#troubleshooting
#tool-kit
- PostgreSQL - DBA Toolkit - Query Performance with pg_stat_statements
2026-04-17 — Use pg_stat_statements to find the queries costing you the most — by total time, average time, and I/O — across your entire workload.
#postgresql
#dba
#monitoring
#performance
#queries
#pg_stat_statements
#tool-kit
- PostgreSQL - DBA Toolkit - Replication Lag
2026-04-17 — Check streaming replication lag on all standby servers, WAL send and replay positions, and whether replicas are keeping up with the primary.
#postgresql
#dba
#monitoring
#replication
#high-availability
#tool-kit
- PostgreSQL - DBA Toolkit - Table Bloat and Vacuum Health
2026-04-17 — Find tables with high dead tuple counts, stalled autovacuum, and growing bloat before they degrade query performance and threaten transaction ID wraparound.
#postgresql
#dba
#monitoring
#vacuum
#bloat
#autovacuum
#performance
#tool-kit
- MySQL - DBA Toolkit - Active Sessions and Threads
2026-04-07 — See every active session and thread at a glance — who is running what, for how long, and where your connection headroom sits.
#mysql
#dba
#monitoring
#tool-kit
- MySQL - DBA Toolkit - Index Usage and Missing Indexes
2026-04-07 — Identify unused indexes wasting write overhead and large tables with no useful indexes that will cause full scans under load.
#mysql
#dba
#monitoring
#performance
#tool-kit
- MySQL - DBA Toolkit - InnoDB Buffer Pool Health
2026-04-07 — Check InnoDB buffer pool hit rate, utilization, and dirty page pressure to understand whether your working set fits in memory.
#mysql
#dba
#monitoring
#innodb
#performance
#tool-kit
- MySQL - DBA Toolkit - Lock Waits
2026-04-07 — Surface active InnoDB lock waits and long-running transactions to identify what is blocking and how long it has been doing so.
#mysql
#dba
#monitoring
#locks
#innodb
#tool-kit
- MySQL - DBA Toolkit - Replication Lag and Status
2026-04-07 — Check replica status, seconds behind source, I/O and SQL thread health, and GTID consistency to catch replication problems before they become outages.
#mysql
#dba
#monitoring
#replication
#tool-kit
- MySQL - DBA Toolkit - Slow Query Analysis
2026-04-07 — Find the queries consuming the most cumulative time using performance_schema digest statistics, without needing the slow query log.
#mysql
#dba
#monitoring
#performance
#slow-queries
#tool-kit
- MySQL - DBA Toolkit - Table Size and Growth
2026-04-07 — Identify your largest tables, compare data versus index footprint, and spot fragmentation that can be reclaimed with a table rebuild.
#mysql
#dba
#monitoring
#storage
#tool-kit
- MySQL - DBA Toolkit - Deadlocks
2026-04-06 — Detect and investigate MySQL deadlocks using InnoDB status, performance_schema, and the last deadlock report.
#mysql
#dba
#monitoring
#deadlocks
#innodb
#locking
#troubleshooting
#tool-kit
- MySQL - DBA Toolkit - Connection Usage and Limits
2026-04-05 — Check current connection counts, max_connections limits, and identify who is consuming connections before you hit the wall.
#mysql
#dba
#monitoring
#connections
#performance
#tool-kit
- MySQL - DBA Toolkit - Binary Log Health
2026-04-04 — Monitor binary log status, current log file, position, and retention to ensure replication and point-in-time recovery are healthy.
#mysql
#dba
#monitoring
#replication
#binary-log
#tool-kit
- MSSQL - DBA Toolkit - Query Plan Cache
2026-04-03
#sql-server
#dba
#monitoring
#troubleshooting
#performance
#query-optimisation
#plan-cache
#tool-kit
- NoSQL, OLAP, Transactional and Flat Files: What They Actually Are
2026-04-02
#databases
#architecture
#storage
#olap
#nosql
#sql
#flat-files
#data-platforms
- MSSQL - DBA Toolkit - Availability Group Health
2026-03-29
#sql-server
#dba
#monitoring
#troubleshooting
#always-on
#high-availability
#performance
#tool-kit
- MSSQL - DBA Toolkit - CPU and Memory Pressure
2026-03-29
#sql-server
#dba
#monitoring
#troubleshooting
#performance
#memory
#cpu
#tool-kit
- MSSQL - DBA Toolkit - Database Growth Trends
2026-03-29
#sql-server
#dba
#monitoring
#capacity-planning
#storage
#performance
#tool-kit
- MSSQL - DBA Toolkit - DBCC CHECKDB and Corruption Checks
2026-03-29
#sql-server
#dba
#monitoring
#integrity
#corruption
#maintenance
#tool-kit
- MSSQL - DBA Toolkit - Deadlock History
2026-03-29
#sql-server
#dba
#monitoring
#troubleshooting
#deadlocks
#blocking
#locks
#tool-kit
- MSSQL - DBA Toolkit - Index Fragmentation and Health
2026-03-29
#sql-server
#dba
#monitoring
#indexes
#maintenance
#performance
#tool-kit
- MSSQL - DBA Toolkit - Log File Usage and VLFs
2026-03-29
#sql-server
#dba
#monitoring
#troubleshooting
#transaction-log
#maintenance
#performance
#tool-kit
- MSSQL - DBA Toolkit - Missing and Unused Indexes
2026-03-29
#sql-server
#dba
#monitoring
#troubleshooting
#indexes
#performance
#tool-kit
- MSSQL - DBA Toolkit - SQL Agent Job Health
2026-03-29
#sql-server
#dba
#monitoring
#troubleshooting
#sql-agent
#maintenance
#tool-kit
- MSSQL - DBA Toolkit - TempDB Usage and Contention
2026-03-29
#sql-server
#dba
#monitoring
#troubleshooting
#tempdb
#performance
#tool-kit
- MSSQL - DBA Toolkit - Top Queries by Resource
2026-03-29
#sql-server
#dba
#monitoring
#troubleshooting
#performance
#query-tuning
#tool-kit
- MSSQL - DBA Toolkit - Active Sessions
2026-02-01
#SQL Server
#dba
#monitoring
#troubleshooting
#sessions
#blocking
#waits
#locks
#backups
#always-on
#performance
#tool-kit
- MSSQL - DBA Toolkit - Blocks Waits locks
2026-02-01
#sql-server
#dba
#monitoring
#troubleshooting
#sessions
#blocking
#waits
#locks
#backups
#always-on
#performance
#tool-kit
- MSSQL - DBA Toolkit - Cached Plans by CPU
2026-02-01
#sql-server
#dba
#monitoring
#troubleshooting
#sessions
#blocking
#waits
#locks
#backups
#always-on
#performance
#tool-kit
- MSSQL - DBA Toolkit - Databases Don’t Shrink. They Betray Patterns.
2026-02-01
#sql-server
#monitoring
#capacity-planning
#dba-life
- Running Backups + ETA
2026-02-01
#sql-server
#dba
#monitoring
#troubleshooting
#sessions
#blocking
#waits
#locks
#backups
#always-on
#performance
#tool-kit
- PostgreSQL - DBA Toolkit - Active Sessions
2026-02-01
#Postgresdb
#dba
#monitoring
#troubleshooting
#sessions
#blocking
#waits
#locks
#backups
#always-on
#performance
#tool-kit