224 percent roi in 3 years, The dell poweredge r810 performance story, 24 databases, 4 instances, 1 server – Dell R810 User Manual
Page 9
Servers: Database consolidation on Dell PowerEdge R810 servers
9
Savings continue after the payback period. By the end of year one,
we project savings of $7,715 with the Dell PowerEdge 810 solution.
The Dell PowerEdge R810 solution used a little less than 1/7th of
the power, 1/24th of the Microsoft Windows Server and Microsoft
Windows SQL Server licenses, under 1/10th of the data center rack
space of the 24 HP ProLiant DL385 solutions, and requires less
administrator time to manage fewer servers and storage arrays.
for more information on these savings and
calculations.
224 percent ROI in 3 years
We calculate the return on the investment in the Dell PowerEdge
R810 solution by dividing the savings after 3 years, $212,747, by
the acquisition costs, $94,801. ROI is 224 percent after 3 years.
The Dell PowerEdge R810 performance story
24 databases, 4 instances, 1 server
Our multiple-instance testing with DVD Store
Using our new hardware environment, which consisted of a single
Dell PowerEdge R810 and two Dell EqualLogic PS5000XV iSCSI
SAN arrays, we installed multiple instances of SQL Server 2008 R2
to simulate the benefits of consolidating multiple SQL Server 2000
workloads from the HP ProLiant DL385 solutions to the Dell
PowerEdge R810 solution. To simulate a real-world multi-instance
consolidation effort, we installed four SQL Server instances and
consolidated six of the legacy workloads per instance on the Dell
PowerEdge R810. The total number of legacy workloads we were
able to consolidate while still maintaining, on average, the same
overall throughput as before, was 24.
About DVD Store
DVD Store Version 2 is an open-source application with a back-end
database component, a front-end Web application layer, and a
driver layer that actually executes the workload. DS2 models an
online DVD store. Simulated customers log in; browse movies by
actor, title, or category; and purchase movies. The workload also
creates new customers. Browsing movies involves select
operations, some of which use full-text search and some of which
do not. The purchase, login, and new customer stored procedures
involve update and insert statements, as well as select statements.
The DS2 benchmark produces an orders per minute metric (OPM),
which we report in this Guide. For more details about the DS2 tool,
see