← Home

#dba

42 posts, oldest → newest

• MSSQL - DBA Toolkit - Active Sessions
  2026-02-01 — Database Administration
• MSSQL - DBA Toolkit - Blocks Waits locks
  2026-02-01 — Database Administration
• MSSQL - DBA Toolkit - Cached Plans by CPU
  2026-02-01 — Database Administration
• Running Backups + ETA
  2026-02-01 — Database Administration
• PostgreSQL - DBA Toolkit - Active Sessions
  2026-02-01 — Database Administration
• On-Prem V Cloud: Opinions, Love, Distrust Vs Use Cases
  2026-02-12 — Data Architecture
• Choosing the Right Database: There is no such thing as “the best database.”
  2026-02-13 — Data Architecture
• Data Governance: It’s Not About Saying No
  2026-02-15 — data-governance
• Party with Partitions
  2026-02-17 — Data Architecture
• Storage isn't always about Money
  2026-02-21 — Data Architecture
• MSSQL - DBA Toolkit - Availability Group Health
  2026-03-29 — Database Administration
• MSSQL - DBA Toolkit - CPU and Memory Pressure
  2026-03-29 — Database Administration
• MSSQL - DBA Toolkit - Database Growth Trends
  2026-03-29 — Database Administration
• MSSQL - DBA Toolkit - DBCC CHECKDB and Corruption Checks
  2026-03-29 — Database Administration
• MSSQL - DBA Toolkit - Deadlock History
  2026-03-29 — Database Administration
• MSSQL - DBA Toolkit - Index Fragmentation and Health
  2026-03-29 — Database Administration
• MSSQL - DBA Toolkit - Log File Usage and VLFs
  2026-03-29 — Database Administration
• MSSQL - DBA Toolkit - Missing and Unused Indexes
  2026-03-29 — Database Administration
• MSSQL - DBA Toolkit - SQL Agent Job Health
  2026-03-29 — Database Administration
• MSSQL - DBA Toolkit - TempDB Usage and Contention
  2026-03-29 — Database Administration
• MSSQL - DBA Toolkit - Top Queries by Resource
  2026-03-29 — Database Administration
• MSSQL - DBA Toolkit - Query Plan Cache
  2026-04-03 — Database Administration
• MySQL - DBA Toolkit - Binary Log Health
  2026-04-04 — Database Administration — Monitor binary log status, current log file, position, and retention to ensure replication and point-in-time recovery are healthy.
• MySQL - DBA Toolkit - Connection Usage and Limits
  2026-04-05 — Database Administration — Check current connection counts, max_connections limits, and identify who is consuming connections before you hit the wall.
• MySQL - DBA Toolkit - Deadlocks
  2026-04-06 — Database Administration — Detect and investigate MySQL deadlocks using InnoDB status, performance_schema, and the last deadlock report.
• MySQL - DBA Toolkit - Active Sessions and Threads
  2026-04-07 — Database Administration — See every active session and thread at a glance — who is running what, for how long, and where your connection headroom sits.
• MySQL - DBA Toolkit - Index Usage and Missing Indexes
  2026-04-07 — Database Administration — Identify unused indexes wasting write overhead and large tables with no useful indexes that will cause full scans under load.
• MySQL - DBA Toolkit - InnoDB Buffer Pool Health
  2026-04-07 — Database Administration — Check InnoDB buffer pool hit rate, utilization, and dirty page pressure to understand whether your working set fits in memory.
• MySQL - DBA Toolkit - Lock Waits
  2026-04-07 — Database Administration — Surface active InnoDB lock waits and long-running transactions to identify what is blocking and how long it has been doing so.
• MySQL - DBA Toolkit - Replication Lag and Status
  2026-04-07 — Database Administration — 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 Toolkit - Slow Query Analysis
  2026-04-07 — Database Administration — Find the queries consuming the most cumulative time using performance_schema digest statistics, without needing the slow query log.
• MySQL - DBA Toolkit - Table Size and Growth
  2026-04-07 — Database Administration — Identify your largest tables, compare data versus index footprint, and spot fragmentation that can be reclaimed with a table rebuild.
• PostgreSQL - DBA Toolkit - Blocking and Lock Waits
  2026-04-17 — Database Administration — Find exactly who is blocking who in PostgreSQL — the blocking session, the waiting session, and the query that started the pile-up.
• PostgreSQL - DBA Toolkit - Checkpoint and WAL Health
  2026-04-17 — Database Administration — Monitor PostgreSQL checkpoint frequency, WAL generation rate, and background writer pressure to catch I/O storms before they hit.
• PostgreSQL - DBA Toolkit - Connection Limits and Pooling
  2026-04-17 — Database Administration — Check connection usage against limits, spot idle connections burning slots, and know when you are close to refusing new clients.
• PostgreSQL - DBA Toolkit - Database Size and Growth
  2026-04-17 — Database Administration — See database and table sizes at a glance, identify the biggest objects, and spot growth before it fills the disk.
• PostgreSQL - DBA Toolkit - Deadlocks
  2026-04-17 — Database Administration — Track deadlock counts per database, identify tables with active lock contention, and surface the transactions involved.
• PostgreSQL - DBA Toolkit - Index Bloat and Health
  2026-04-17 — Database Administration — Find bloated, unused, and duplicate indexes in PostgreSQL — the silent performance killers that accumulate over time.
• PostgreSQL - DBA Toolkit - Long Running Queries
  2026-04-17 — Database Administration — Spot long-running queries and idle transactions in PostgreSQL before they block autovacuum, hold locks, and cause a cascade of timeouts.
• PostgreSQL - DBA Toolkit - Query Performance with pg_stat_statements
  2026-04-17 — Database Administration — 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 Toolkit - Replication Lag
  2026-04-17 — Database Administration — Check streaming replication lag on all standby servers, WAL send and replay positions, and whether replicas are keeping up with the primary.
• PostgreSQL - DBA Toolkit - Table Bloat and Vacuum Health
  2026-04-17 — Database Administration — Find tables with high dead tuple counts, stalled autovacuum, and growing bloat before they degrade query performance and threaten transaction ID wraparound.