Maps 9–12
Map 9 — Change and Copy Map
CDC → detect / move changed rows or deltas
REPLICATION → maintain same data on multiple nodes/devices
├─ Active vs Passive
└─ Mirroring (near-current) vs Log Shipping (periodic logs)
SHARDING → split one database into independent chunks
Source: pp. 188–193.
Map 10 — Continuity Chain
BUSINESS CRITICALITY
↓
SLA / BACKUP FREQUENCY
↓
SEPARATE + OFF-SITE COPY
↓
RECOVERY TEST
↓
RESTORE / FAILOVER CAPABILITY
Key: backup creation is not recovery proof.
Source: pp. 194–197.
Map 11 — Performance Triage
PERFORMANCE = AVAILABILITY + SPEED
↓
Baseline / monitor / diagnose
↓
Memory → locks/deadlocks → statistics → SQL/joins → indexes
→ server load/capacity → volatility → runaway queries
↓
least-disruptive effective remediation
Trap: denormalization is not the automatic first answer to a slow OLTP query.
Source: pp. 197–203.
Map 12 — Governance Measurement Map
STORAGE → capacity | objects | queues | usage
PERFORMANCE → transactions | queries | APIs
OPERATIONS → retrieval | backups | DQ | availability
SERVICE → issues | escalations | resolution time
Side rails:
ASSET TRACKING → licenses | support | TCO | obsolescence
AUDIT → compliance / methodological criteria
VALIDATION → quality / usability acceptance criteria
Source: pp. 203–208.