Dell PowerEdge R310 Manual de usuario descargar pdf (Pagina 2)

A Principled Technologies test report 2

Rack servers: Database price-performance

PROJECT OVERVIEW

The goal of the project was to determine which of the following systems had better database

price/performance as well as which server had more advanced hardware options:

 Dell PowerEdge R310

 HP ProLiant DL120 G6

Both servers ran Microsoft Windows Server 2008 R2 Enterprise Edition with Microsoft SQL Server 2005

x64. We used a single client running Microsoft Windows Server 2003 R2 to induce a heavy database load on

the server.

We also compared the upgrade capabilities of the online offerings of each server in order to determine

which system had superior hardware options.

WORKLOAD

DVD Store Version 2 (DS2) is an accessible, open-source, flexible framework with which we can model

a typical online transaction processing (OLTP) database. DS2, which simulates an online e-commerce DVD

store, has database components and Web server components, and includes driver programs that put heavy

loads on the server. We opted to use the included driver program to stress the database layer directly, and

bypassed the Web interface.

When DS2 is executing, simulated customers log in; browse movies by actor, title, or category; and

purchase movies. Each DS2 order consists of a customer login, a number of searches for movies, and a

purchase. Each search is by title, actor, or category. The title and actor searches use full-text search. The other

customer actions, including adding new customers, exercise a wide range of database functions.

The main DS2 metric is orders per minute (OPM), which the driver program calculates and reports via

the Windows Performance Monitor utility on the client machines. While the DVD Store client application

outputs OPM at 10-second intervals visually, we chose to collect this OPM metric via the performance monitor

counter on each client at 1-second intervals. We ran this workload on each server for 35 minutes, which

consisted of 5 minutes of warm-up time and 30 minutes of run time.

Each server under test ran a single Microsoft SQL Server 2005 x64 instance with a 5GB database that

we tuned to saturate the server’s processor and memory. We used the default DS2 parameters and setup

configuration, with the exceptions we note in the DVD Store setup section in the How we tested section of this

report.

1 2 3 4 5 6 7 ... 13 14

Sin comentarios

Dell PowerEdge R310 Manual de usuario Pagina 2