Chapter 10. How to Baseline Your Physical SQL Server System

Check it before you wreck it.”

—Jeff Szastak

The bitterness of poor performance lasts long after the sweetness of a cheap price is forgotten.”

—Unknown

The title of this book is Virtualizing SQL Server on VMware: Doing IT Right. An essential part of “doing it right” is having a good understanding of the workload characteristics and configuration of the existing physical source systems that are to be virtualized. Remember that unlike in a physical environment, where it’s common practice to oversize the server, in a virtualized infrastructure it’s important you “right-size” the VM that houses your SQL Server database. You can always hot-plug a vCPU and hot-add memory if more is needed. ...

Get Virtualizing SQL Server with VMware®: Doing IT Right now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.