Filter
Top Products
A Principled Technologies test report 15
Virtualized database performance comparison: Dell PowerEdge
R815 vs. IBM System x3850 X5
We recompiled the ds2_create_orders.c module on Linux, following the instructions in the header
comments. We used the following command line:
gcc –o ds2_create_orders ds2_create_orders.c –lm
Editing the ds2_create_cust.c module
We had to make the same changes to the ds2_create_cust.c module that we made to the
ds2_create_orders.c module. On the command line for the ds2_create_cust.c module, we specified the size.
The available options were S (small), M (medium), and L (large). We added the case P for the 2.5GB database.
In the switch statement that sets the values for the variables max_cust_id and max_prod_id, we added cases
that assigned them the proper values for the 2.5GB database size.
We recompiled the ds2_create_cust.c module on Linux, following the instructions in the header
comments. We used the following command line:
gcc –o ds2_create_cust ds2_create_cust.c –lm
Generating the data for the 2.5GB database
We used shell scripts to run all four of the executables that generate the data. The distribution did not
include shell scripts for the 2.5GB size. We wrote shell scripts based on the ds2_create_cust_large.sh and
ds2_create_orders_large.sh scripts. The ds2_create_prod and ds2_create_inv executables did not ship with
associated shell scripts, so we created shell scripts using the instructions in the readme files. We ran the shell
scripts in the following order to generate the data for the 2.5GB database:
1. ds2_create_orders_2.5gb.sh
2. ds2_create_inv_2.5gb.sh
3. ds2_create_prod_2.5gb.sh
4. ds2_create_cust_2.5gb.sh
We waited until the processes finished before we moved onto the next step.
Creating the database
We modified the database creation SQL Server scripts in the DVD Store distribution package to build
the database schema, which includes the file structure, tables, indices, stored procedures, triggers, and so on.
We built a master copy of the 2.5GB database version for SQL Server 2008 R2 and then used that master copy
to restore our test database to the server between each test run. We stored the backup file on the C: drive of
each server for quick access.
We followed these steps to create the database: