Virtualization, SANs, and Hardware for SQL Server

  • Instructor(s): Brent Ozar
  • Length: 6 hours
  • Cost: $299

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.
Buy it now for $299.Get 18 months streaming access.


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!
Buy it now for $299.Get 18 months streaming access.

About Brent

Specialities: performance tuning, SAN storage, VMware

Off duty: foodie restaurants, travel, bad pop music


Suggested Courses

How to Tune Indexes and Speed Up SQL Server

  • Length: 7 hours
  • Cost: $299
You want to become an expert at index tuning, but you can't find a good start-to-finish training course. Learn the basics, the gotchas, and the tricks of SQL Server indexing in 7 hours of training. You'll use interactive quizzes to test your knowledge as you learn:
  • How to create, analyze, and understand clustered and nonclustered indexes
  • When to use index includes, filtered indexes, and other special structures to speed up your queries.
  • How to use free tools to find hidden columns in your indexes
  • How to tune a workload using the SQL Server Dynamic Management Views
  • How to avoid common indexing anti-patterns that drag down your database server
  • How to find critical index changes in the Execution Plan Cache
  • How you can use data to prove that your changes improved performance

Buy it now and get started

How to Think Like SQL Server

  • Length: 90 minutes
  • Cost: $29
You're a developer or a DBA, and you're comfortable writing queries to get the data you need. You're much less comfortable trying to design the right indexes for your database server. In this series of videos with Brent Ozar, you'll learn how the SQL Server engine looks at your indexes and builds your query results.

Buy it now and get started

The Fine Print: Read our “Refund and Cancellation Policy for Training Videos” here. Want to pay by check or purchase order? Download our order form spreadsheet, pick out what you want, hand it to your company's accountants, and we'll set you up when we get your check.