Dell R810 User Manual

Page 11

Advertising
background image

Servers: Database consolidation on Dell PowerEdge R810 servers


11

Figure 2. Consolidated SQL Server 2008 R2 instance layout
for our testing.


For client machines, we used desktop systems running Windows
Server 2003 R2 with SP2. Each of these client machines ran the
DS2 workload, which spawned 32 threads against each database
workload and ran with no think time. On the HP ProLiant DL385
server, we used one client and one SQL Server 2008 R2 instance,
containing one database. On the Dell PowerEdge R810 server, we
used four SQL Server 2008 R2 instances, each containing six
databases, for a total of 24 databases. We used 12 clients and
each targeted two databases. This simulated a heavily loaded
environment on all of our databases.

We ran the DS2 benchmark with a 10GB database. On average,
each SQL Server 2008 R2 database workload on the Dell
PowerEdge R810 solution delivered better performance than did a
single HP ProLiant DL385 solution with the same workload. We
then estimated the monthly costs for maintaining the 24 HP
ProLiant DL385 solutions and the single Dell PowerEdge R810
solution, and estimated the payback period for the investment in
the Dell PowerEdge R810 solution.

Advertising