
A Principled Technologies test report 16
Database performance and resiliency in the Intel processor-powered
Dell PowerEdge R630 running Microsoft SQL Server 2014
Figure 8: Our initial file size modifications.
Running the test
Test start and run times
We ran the workloads separately and recorded all performance counters for this report. The specific testing
parameters we used for the benchmark are included below.
About running the DVD Store tests
We created a series of batch files, SQL scripts, and shell scripts to automate the complete test cycle. DVD Store
outputs an orders-per-minute metric, which is a running average calculated through the test. In this report, we report
the last OPM reported by each client/target pair.
Each complete test cycle consisted of the general steps listed below.
1. Clean up prior outputs from the target system and the client driver system.
2. Drop the database from the target servers.
3. Restore the database on the target servers.
4. Shut down the target.
5. Reboot the host and client systems.
6. Wait for a ping response from the server under test (the hypervisor system), the client system, and the
target.
7. Let the test server idle for 10 minutes.
8. Start the DVD Store driver on the client.
We used the following DVD Store parameters for testing:
ds2sqlserverdriver.exe --target=<target_IP> --ramp_rate=10 --run_time=30 --
n_threads=32 --db_size=40GB --think_time=20 --detailed_view=Y --
warmup_time=5 --report_rate=1 --csv_output=<drive path>
Comentarios a estos manuales