Virtualizing SQL Server with VMware®: Doing IT Right

Chapter 7. Architecting for Performance: Memory

In Chapter 5, “Architecting for Performance: Design,” we introduced the concept of the “IT food group,” shown in Figure 5.1. We discussed how important it is to provide your database the right balance of memory, disk, CPU, and network. Without enough of any single one of these essential resources, you will never have a properly performing system. We also stressed how important it is for you to balance these resources to ensure you get optimal performance from your virtualized database. All this must be done in the context of a shared resource environment.

In this chapter, we focus on leveraging memory as a resource, with the goal being to optimize the performance on your virtualized SQL Server database. ...