Dell H730P Manual de usuario Pagina 16

  • Descarga
  • Añadir a mis manuales
  • Imprimir
  • Pagina
    / 18
  • Tabla de contenidos
  • MARCADORES
  • Valorado. / 5. Basado en revisión del cliente
Vista de pagina 15
A Principled Technologies test report 16
Database performance and resiliency in the Intel processor-powered
Dell PowerEdge R630 running Microsoft SQL Server 2014
Logical name
Filegroup
Initial size (MB)
Database files
primary
PRIMARY
4
cust1
DS_CUST_FG
12,288
cust2
DS_CUST_FG
12,288
cust3
DS_CUST_FG
12,288
cust4
DS_CUST_FG
12,288
ind1
DS_IND_FG
4,628
ind2
DS_IND_FG
4,628
ind3
DS_IND_FG
4,628
Ind4
DS_IND_FG
4,628
ds_misc
DS_MISC_FG
200
orders1
DS_ORDERS
6,144
orders2
DS_ORDERS
6,144
orders3
DS_ORDERS
6,144
orders4
DS_ORDERS
6,144
Log files
ds_log
Not Applicable
20,480
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>
Vista de pagina 15
1 2 ... 11 12 13 14 15 16 17 18

Comentarios a estos manuales

Sin comentarios