O'Reilly logo

Virtualizing SQL Server with VMware®: Doing IT Right by Michael Webster, Jeff Szastak, Michael Corey

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

To this point we have provided deep dives on 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 the configuration below has also been shown to work with Windows 2008 R2 as the operating system supporting SQL 2012 and Windows 7 as the desktop generating the workload.

Introduction

Before we begin discussing what is needed for ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required