← Home

#performance

26 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
• Party with Partitions
  2026-02-17 — Data Architecture
• Storage isn't always about Money
  2026-02-21 — Data Architecture
• Global Shock Part 3: It's Just One Pipeline — But You Should Still Architect
  2026-03-02 — 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 - 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 - 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 - 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 - 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 - 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.
• 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 - 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 - 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.