Specifications

A Principled Technologies test report 42
Dell Active System 800 converged infrastructure solution: User
collaboration performance
19. Enter and confirm a password for the system administrator account.
20. Click Add Current user. This may take several seconds.
21. Click the Data Directories tab and enter the appropriate drive and folders for database and logs.
22. Click Next.
23. At the Error and usage reporting screen, click Next.
24. At the Installation Configuration Rules screen, check that there are no failures or relevant warnings, and click
Next.
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 server (DVD Store) 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.
Configuring database workload client
For our testing, we used two to four client machines for the Microsoft SQL Server client, depending on whether
we were running the medium or high utilization scenario. To create these clients, we installed Windows Server 2008 R2
SP1, 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 40GB 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 40GB 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 40GB 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.