A Principled Technologies test report 13
Performance and TCO: Dell PowerEdge R820 vs.
HP ProLiant DL585 G7
26. After installation completes, click Next.
27. Click Close.
28. Create a SQL Server login for the ds2user (see the Configuring the database (DVD Store) section for the specific
script to use).
29. Copy the pre-created DVD Store backup to the specified backup VHD volume.
30. Click StartAll ProgramsMicrosoft SQL Server 2008 R2Configuration Tools, and click SQL Server
Configuration Manager.
31. Expand SQL Server Network Configuration, and click Protocols for MSSQLSERVER.
32. Right-click TCP/IP, and select Enable if it is disabled.
Configuring additional VMs on VMware vSphere 5.0
1. Log into the vCenter Server, which manages the host.
2. Right-click the first VM, and choose Clone.
3. Name the new VM.
4. Choose the cluster, and select the host.
5. At the Storage screen, click Next.
6. At the Summary screen, click Finish.
7. Continue cloning each VM, modifying the customization specification as necessary for IP addressing and so on.
8. Ensure in each VM that the necessary virtual disks are all online, the hostname is renamed, and the IP addresses
are properly assigned.
9. To configure automatic start for your specified number of VMs, click the Host configuration tab in the vSphere
client, and click Virtual Machine Startup/Shutdown.
Configuring the database (DVD Store)
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 5GB 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 Install.pl script also generated the database schema.
After processing the data generation, we transferred the data files and schema creation files to a Windows-
based system running SQL Server 2008 R2 SP1. We built the 5GB database in SQL Server 2008 R2 SP1, 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
original database on the servers between test runs. We also updated the compatibility level of the database to SQL
Server 2012 RC0.
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 5GB 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.
(6 pages)
(16 pages)
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Commentaires sur ces manuels