Database Reference
In-Depth Information
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 the test, let's cover why we are running
this test:
Is this a test to show the DBAs in the organization how well virtualized SQL can
perform on a vSphere infrastructure?
Is the test part of a bakeoff between physical and virtual configurations?
Is this simply a test of functionality?
Once we understand the “why,” we can set proper expectations for the test. This means
creating the proper documentation, detailing the test plan, identifying and monitoring of
key performance indicators, ensuring consistency between tests (for example, if
measuring physical versus virtual performance), and ensuring proper sponsorship.
So that we are on the same page, we are creating a performance test in this chapter that
has the ability to stress the infrastructure beyond its limits. Be mindful of where this
configuration is being stood up, the time of day, and the duration of the testing. We have
seen individuals set up performance tests using production equipment and bring the
production environment to its knees. Don't be that person.
Caution
To be clear, run the following test configuration against non-production
equipment.
It should be noted that some of the configuration options presented in this chapter do not
follow production best practices for implementing SQL Server. Be mindful of this when
you are configuring your implementation and make the appropriate changes to ensure
adherence to your company's policies. Be cognizant of the settings that are being chosen
 
 
 
Search WWH ::




Custom Search