Dell PowerEdge M420 Bedienungsanleitung PDF herunterladen (Seite 14)

A Principled Technologies test report 14

Blade server database performance: Dell PowerEdge M420

CHECK_EXPIRATION=OFF,

CHECK_POLICY=OFF

9. Set the database recovery model back to full.

10. Create the necessary full text index using SQL Server Management Studio.

11. Create a database user, and map this user to the SQL Server login.

12. Perform a full backup of the database. This backup allowed us to restore the databases to a pristine state

relatively quickly between tests.

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 track the

last OPM reported by each client/instance pair. We used four client machines, each client targeting one SQL Server

clustered instance.

Each complete test cycle consisted of the general steps listed below. For each scenario, we ran three test cycles,

and chose the median outcome.

1. Clean up prior outputs from the host system and all client driver systems.

1. Drop all databases from all target SQL Server cluster instances.

2. Restore all databases on all target SQL Server cluster instances.

3. Move all SQL Server cluster resources to node A.

4. Reboot node B.

5. Move all SQL Server cluster resources to node B.

6. Reboot node A.

7. Take all SQL Server cluster resources offline.

8. Bring all SQL Server cluster resources online.

9. Move SQL Server instances 1 and 2 to node A.

10. Move SQL Server instances 3 and 4 to node B.

11. Let the test server idle for ten minutes.

12. Start the DVD Store driver on all respective clients.

We used the following DVD Store parameters for testing the virtual machines in this study:

ds2sqlserverdriver.exe --target=<target_IP>\<target_instance_name> --

run_time=30 --n_threads=30 --db_size=40GB --think_time=0 --warmup_time=5

1 2 ... 9 10 11 12 13 14 15

Keine Kommentare

Dell PowerEdge M420 Bedienungsanleitung Seite 14