We’ll give you list of client requirements, and you pick the right hardware size, VM vs physical, local or shared storage, SQL Server version and edition for each client.

5 Comments. Leave new

  • Hi Brent.

    It is September 2020, 200 GB single database in Azure VM.

    Would you still recommend a combination of Failover cluster which writes to a shared storage + Synchronous Storage Replication that writes to another location as a solution for problem number 2?

    Thanks.

    Reply
    • Nikola – no, this exercise wasn’t about Azure, but about a real physical environment. If you have different project requirements, that’s where you have to evaluate the options in the 1.3 module for architecture.

      If you need my custom advice, that’s where my consulting comes in. You can click Consulting at the top of the site if you’d like me to help design your infrastructure. Thanks!

      Reply
    • Ooo, looking at the requirements though – they wanted 1-minute failover, and you definitely can’t get that with synchronous storage replication alone. AGs would be a better fit, like I describe in the video.

      Reply
  • hiram.thompson
    May 26, 2021 5:12 pm

    Flash Notice:
    When I click “Mark as Complete” for this video, it does not take me to the next video.

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.