1.3 Architecture for HA and DR Part 2
You’re building a new SQL Server, and you need to protect it. You want to learn when it’s right to use clustering, AlwaysOn Availability Groups, virtualization, or storage replication. You don’t have an unlimited budget, either, so you need to learn how 2014-2016 licensing impacts these choices.
Note: this class is from 2017, and I no longer update it. I’ve made it freely available since I no longer do production DBA work, and I don’t intend to keep this course up to date. You’re welcome to leave comments for other viewers here, but I don’t answer questions on this material, nor do I update it to reflect changes in Microsoft SQL Server. Thanks for understanding, and enjoy the free videos! Hope they help.
- 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.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.5 Homework Part 2: Answers (28m)
- 3.6 Index Maintenance for Enterprise Environments (43m)
- 3.7 Recap and Q&A (28m)
4 Comments. Leave new
So if I have a VM host that has 16 cores, I have to buy EE if I want to run any guest instances of SQL, even if the guest instances are restricted to 8 cores each?
Close! If you license by the guest, you can use Standard Edition up to 16-24 cores (depending on your version of SQL Server.) There’s no 8-core limit on Standard Edition.
If you license by the host, you must use Enterprise Edition to license all of the physical cores on the host, but then you can run as many guests as you want.
Hello Brent
If I have 16 core host server, how many I can create Virtual core per guest server.
Jitesh – watch this course: https://www.brentozar.com/training/hardware-storage-virtualization/09-virtualization-configuring-sql-server-virtualization-47m/