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.
Before we begin discussing what is needed for ...