~/talk

Perfecting business continuity for Azure SQL DB

on YouTube 47m
Talkat SQLBits 2024 · 2024-03-19..03-23· [databases]

speaker

name:Rajesh Setlem
links:none on file

resources

video:https://youtu.be/zjM_ytwCACc
slides:none on file

summary

Covers concrete configs and demos: uses a 2 vCore Gen5 Hyperscale DB, simulates 28,000 requests/min with JMeter, and triggers a SQL database failover command showing automatic H-replica promotion in about 10–20 seconds (demo ~14–15s) while Power BI/Grafana trace the blip. Recommends enabling Zone redundancy for 99.995% HA, using failover groups with customer-managed policy for DR, notes standby replica gives ~40% cost savings, and reminds that Geo-restore backups replicate hourly so RPO ≈ 1 hour.

AI-written summary · about

chapters (10)

  1. 0:00Business continuity intro
  2. 3:19Availability and SLA
  3. 8:37RPO and RTO explained
  4. 13:13Resiliency scope
  5. 18:55High availability architectures
  6. 24:09HA demo with zone redundancy
  7. 31:43Disaster recovery options
  8. 38:22Geo-redundant backups
  9. 40:52Key takeaways checklist
  10. 47:00Q&A

related talks

~/search
type to search 6,249 conferences, 138,987 speakers and 185,172 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.