System information

A Principled Technologies test report 33
Comparing performance and cost: Dell PowerEdge VRTX vs.
legacy hardware solution
25. At the Ready to Install screen, click Install.
26. After installation completes, click Close.
27. Create a SQL Server login for the ds2user (see the Configuring the database (Data generation overview)
section for the specific script to use).
28. Copy the pre-created DVD Store backup to the specified backup volume.
29. Download and install any available updates for Microsoft SQL Server 2012. We installed SQL Server 2012 SP1
and CU5.
Configuring the database workload client
For our testing, we used a single client machine for the Microsoft SQL Server client. To create this client, we
installed Windows Server 2012, assigned a static IP address, and installed .NET 3.5.
Configuring the database
Data generation overview
We generated the data using the Install.pl script included with DVD Store version 2.1 (DS2), providing the
parameters for our 10GB database size and the database platform on which we ran: Microsoft SQL Server. We ran the
Install.pl script on a utility system running Linux. The database schema was also generated by the Install.pl script.
After processing the data generation, we transferred the data files and schema creation files to a Windows-
based system running SQL Server 2012. We built the 10GB database in SQL Server 2012, and then performed a full
backup, storing the backup file on the C: drive for quick access. We used that backup file to restore the server between
test runs.
The only modification we made to the schema creation scripts were the specified file sizes for our database. We
explicitly set the file sizes higher than necessary to ensure that no file-growth activity would affect the outputs of the
test. Besides this file size modification, the database schema was created and loaded according to the DVD Store
documentation. Specifically, we followed the steps below:
1. We generated the data and created the database and file structure using database creation scripts in the
DS2 download. We made size modifications specific to our 10GB database and the appropriate changes to
drive letters.
2. We transferred the files from our Linux data generation system to a Windows system running SQL Server.
3. We created database tables, stored procedures, and objects using the provided DVD Store scripts.
4. We set the database recovery model to bulk-logged to prevent excess logging.
5. We loaded the data we generated into the database. For data loading, we used the import wizard in SQL
Server Management Studio. Where necessary, we retained options from the original scripts, such as Enable
Identity Insert.
6. We created indices, full-text catalogs, primary keys, and foreign keys using the database-creation scripts.
7. We updated statistics on each table according to database-creation scripts, which sample 18 percent of the
table data.
8. On the SQL Server instance, we created a ds2user SQL Server login using the following Transact SQL (TSQL)
script: