Hardware, Storage, and Virtualization
When you’re the one who has to plan, buy, set up, and troubleshoot production SQL Servers, you need to know about hardware, SAN storage, SSDs, virtualization, and more. This five-hour course has advanced modules on:
- How to choose if clustering, AlwaysOn Availability Groups, mirroring, log shipping, virtualization, or SAN replication is right for your new build
- What hardware to buy for SQL Server Standard Edition and Enterprise Edition
- How to configure SQL Server on a SAN or on virtualization (VMware or Hyper-V)
- Testing and comparing your storage to industry benchmarks
- Our one-month go-live checklist covering what to test before putting a new SQL Server in production
- 01. Architecture Design: Building a Strategy for RPO and RTO (18m)
- 02. Architecture Design: Tactics – Clustering, Always On, Mirroring, and More (29m)
- 03. Architecture Design: Are Always On Availability Groups Right for You? (40m)
- 04. Hardware: How to Build Fast SQL Servers (30m)
- 05. Hardware: Server Sizing (23m)
- 06. Hardware: Find the Old Server’s Bottleneck with Wait Stats (28m)
- 07. Virtualization: How VMware and Hyper-V Manage Resources (20m)
- 08. Virtualization: Planning for Consolidation and Virtualization (32m)
- 09. Virtualization: Configuring SQL Server for Virtualization (47m)
- 10. Virtualization: Backup Mistakes with Virtual SQL Servers (11m)
- 11. Storage: How to Test and Compare Your Storage (34m)
- 12. Storage: SAN Pathing (21m)
- 13. Storage: How to Set Up Your SAN for SQL Server (22m)
- 14. Storage: Using Solid State Drives with SQL (30m)
- 15. Storage Advanced Features: Tiering (12m)
- 16. Storage Advanced Features: Snapshots, Replication, Migrations (22m)
- 17. Go-Live Checklists and Testing (22m)