Database Reference
In-Depth Information
DVD Store database. The first step in this process is to remove the DS2 database from
the AlwaysOn Availability Group. The reason for removal is the script we use to reset
the database will fail if you attempt to run it while DS2 is part of an AlwaysOn
Availability Group. Once the DS2 database is removed, open the
sqlserverds2_cleanup_20GB.sql
file located in the
\ds2\sqlserverds2\build
directory.
We will run the script from the SQL Server on which we built the database via the
Microsoft SQL Server Management Studio, as shown in
Figure 11.121
. Once the script
is loaded, click the
Execute
button to begin.
Figure 11.121
Resetting the Dell DVD Store test.
This concludes the section on running the Dell DVD Store test with SQL Server 2012
running on Windows 2012.
Now that you have successfully run the test, we encourage you to reset the configuration
and rerun the test several times, testing various features native to the vSphere platform
and SQL Server itself. For example, test vMotion while the system is running to see the
effect on an active node or a passive node. Test the anti-affinity rule to see how it
works. Test vSphere HA by powering down an ESXi host. Test SQL Server resiliency
by simulating failovers. Test your backup/recovery procedures to determine the best
way to recover from a failure. You now have a test environment that can be leveraged
for repeated testing, so use it!
Summary
In this chapter, we walked through a complete, end-to-end configuration of a SQL
Server performance test on vSphere 5.5 with SQL 2012 as our database engine and
Windows Server 2012 as our guest operating system. This chapter builds on all the
previous chapters in this topic; however, it does not include all the possible variations
and tweaks. We set up a “base” installation from which you are able to manipulate
various levers within vSphere, Windows, and SQL to find the optimal configuration for
your environment.
