Azure Classroom Series – 04/Dec/2019

Azure SQL Failover Groups

  • Failover is making the secondary database primary in the cases of failure.
  • Refer Here for failover steps.

Azure SQL Pricing Model

  • DTU:

    • Database Tranasaction Unit:
      • Each DTU reprsents cpu,ram and storage
      • To estimate number of DTUs required for your on-premise Database, use Calculator from here
  • vCore:

    • Measured in vCores
  • Refer Here for resource limits and also use Azure Pricing Calculator.

Azure SQL for mySQL and Postgres

Exercise

  • Create Azure SQL Single Database.
  • Create a Read Replication of this Database
  • Create a failover group.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

About continuous learner

devops & cloud enthusiastic learner