Cost of Geo-Replication and Read Scale-Out

• ebooklub

  Hall of Fame

  Points: 3905

  More actions

  May 25, 2018 at 9:11 am

  #405705

  Hi,
   am creating proof of concept for migration to Azure SQL databases 
  We have have 3 databases, I used Azure calculator for cost estimation 
  -------------------------------------
  Azure Single Database,
  DTU Purchase Model,
  Premium Tier, P4: 500 DTUs,
  500 GB included storage per DB,
  3 Database(s) x 730 Hours, 100 GB Retention
  Estimated Monthly Cost $5,557.46 (could be less expensive with hybrid licence...)
  -------------------------------------
  Premium Tier option chosen for Read Scale-Out

  "The Read Scale-Out feature allows you to load balance SQL Database read-only workloads using the capacity of the read-only replicas instead of sharing the read-write replica. This way the read-only workload will be isolated from the main read-write workload and will not affect its performance. The feature is intended for the applications that include logically separated read-only workloads, such as analytics, and therefore could gain performance benefits using this additional capacity at no extra cost" 

  I want to set up up High availability Using two Azure regions for business continuity with minimal downtime
  
  Few point confuse me about Geo-replication:
  1. Will be databases in second region be also used for read-only for  load balancing if both regions are in normal state?
  2. Additional Cost of setting Geo-replication?

  If I place databases only in Data Center A and  "meteorites hits a data center",  assuming I keep databases backup redundant storage , how long MS will take provide me with resources in new Data Center?