3.5 Homework Part 2: Answers (28m)
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.
- 1.1 Intro and DBA Skills Quiz (33m)
- 1.2 Building and Testing Reliable SQL Servers Part 1 (25m)
- 1.2 Building and Testing Reliable SQL Servers Part 2 (21m)
- 1.3 Architecture for HA and DR Part 1
- 1.3 Architecture for HA and DR Part 2
- 1.4 Design Quorum for Failover Clusters (23m)
- 1.5 Triaging Failure in Availability Groups (32m)
- 1.6 Recovering from Failover Part 1 (40m)
- 1.6 Recovering from Failover Part 2 (12m)
- 1.7 Building an Inventory and a Support Matrix (39m)
- 2.1 Database Mirroring Field Medic Guide (40m)
- 2.2 Transaction Log Shipping Tips and Tricks (45m)
- 2.3 Troubleshooting Backup and Restore Problems (35m)
- 2.4 Optimizing DBCC CHECKDB (53m)
- 2.5 Availability Group Backup and CHECKDB Part 1 (8m)
- 2.5 Availability Group Backup and CHECKDB Part 2 (32m)
- 2.6 Cloud for the Senior DBA (38m)
- 2.7 Homework: Deciding Between Availability Solutions Part 1 (11m)
- 2.7 Homework: Deciding Between Availability Solutions Part 2 (27m)
- 3.1 Shared Storage Part 1 (28m)
- 3.1 Shared Storage Part 2 (32m)
- 3.2 Advanced SAN Features – Storage Tiering and Snapshots (31m)
- 3.3 Virtualization Management and Troubleshooting (61m)
- 3.4 Server Hardware Sizing (36m)
- 3.5 Homework Part 1 (11m)
- 3.6 Index Maintenance for Enterprise Environments (43m)
- 3.7 Recap and Q&A (28m)
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.
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!
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.
Flash Notice:
When I click “Mark as Complete” for this video, it does not take me to the next video.
Sorry about that – I’m moving away from that, and you’ll have to go to the next video yourself. Sorry about the inconvenience!