Chapter 20. Virtualizing SQL Server

Organizations, for the past several years, have been on a mission to virtualize everything, it seems, especially servers. It isn’t hard to understand why: virtualization offers a lot of flexibility, more compact data centers, interesting options for HA, and more. Over those last few years, myths and inaccurate information have been perpetuated about virtualizing SQL Server. Let’s clear it up and see how well SQL Server responds to being virtualized!

20.1. Why virtualize?

There are dozens of reasons to virtualize a server. VMs can be easily moved from host machine to host machine, helping to rebalance workloads, make maintenance easier, and even provide for fault tolerance. Once a server is running on a VM ...

Get Learn SQL Server Administration in a Month of Lunches now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.