Virtualizing SQL Server with VMware®: Doing IT Right

Chapter 11. Configuring a Performance Test—From Beginning to End

To this point, we have provided deep dives into individual topics for virtualizing SQL Server. We are often asked, “How do I test SQL on vSphere?” In this chapter, we are going to put it all together and walk you, the reader, through setting up SQL 2012 on Microsoft Windows Server 2012. We will configure the AlwaysOn Availability Groups, and using an open source load-generation tool, Dell DVD Store, we will simulate workload. Furthermore, it should be noted this configuration has also been shown to work with Windows 2008 R2 as the operating system supporting SQL 2012 and Windows 8 as the desktop generating the workload.

Introduction

Before we begin discussing what is needed for ...