Chapter 5. Architecting for Performance: Design

A database can be one of the most resource-intensive systems in an environment. When I think about architecting a virtualized database for performance, I think about it in the same terms as I think about good nutrition. A healthy body requires the right intake and foundation of foods, more commonly known as the basic food groups. A properly performing virtualized database requires the right balance of memory, disk, CPU, and network resources, as shown in Figure 5.1. Without enough of any single one of these essential resources, you will never have a properly performing system. How you balance these resources is the key to getting optimal performance from your virtualized database.

Figure 5.1

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.