Virtualization, SANs, and Hardware for SQL Server

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 6-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
  • Updated March 2014: added another hour of videos covering virtualization backups, storage tiering, SAN snapshots, SAN replication, and updated hardware sizing with the latest recommendations for 2-socket and 4-socket servers.
[maxbutton id=”40″]


Architecture Design Modules:

  • Building an Architecture Strategy for RPO and RTO (18 minutes)
  • Architecture Tactics: Clustering, AlwaysOn, Mirroring, and More (29m)
  • Are AlwaysOn Availability Groups Right for You? (39m)
  • How to Build Fast SQL Servers (30m)
  • Server Hardware Sizing (22m)

Virtualization Modules:

  • How VMware and Hyper-V Manage Resources (20m)
  • Planning for Consolidation and Virtualization (32m) and inventory worksheet
  • Configuring SQL Server for Virtualization (47m)
  • Backup Mistakes with Virtual SQL Servers (10m)

Storage – SAN and SSD Modules:

  • How to Test and Compare Your Storage (34m)
  • SAN Pathing (20m)
  • How to Set Up Your SAN for SQL Server (22m)
  • Using Solid State Drives with SQL Server (30m)
  • Storage Tiering (12m)
  • SAN Snapshots, Replication, and Migrations (21m)

Bonus Plus: One Month Go-Live Checklist (22m) – my personal time-tested process for stress testing and failover testing to make sure your new server deployment process goes smoothly. One month sounds like a long time – and it is – but I assume that you’ve only got a limited amount of time each week to work on this new server or cluster. It includes recommendations like:

  • Why you should pull the network cables out of your server
  • Why you should try backing up with 1, 2, and 4 backup files
  • The simple ways to measure exactly how much faster this new server will be
  • And much more!
[maxbutton id=”40″]