A Principled Technologies test report 4
Consolidating older database servers with the Intel processor-powered
Dell PowerEdge R730xd using SanDisk DAS Cache
OUR TEST APPROACH AND FINDINGS
We set out to show that a single Dell PowerEdge R730xd, powered by Intel Xeon
E5-2660 v3 processors, with a combination of traditional hard disk drives (HDDs) and
solid-state drives (SSDs) with SanDisk DAS cache, could replace multiple IBM x3650 M3
servers using only HDDs. To do so, we used Benchmark Factory for Databases to build a
moderately sized database and ran a TPC-C-like online transactional processing (OLTP)
workload. (We present system configuration details in Appendix A and our precise
testing steps in Appendix B.)
First, we established a baseline set of parameters by testing the legacy server to
see how many databases it could support, using an assumption of 5,000 users per
database with default workload parameters. Our goal was to remain below 2 seconds of
application response time.
We found that the legacy server could support two databases (10,000
concurrent users) while providing a response time of 1.05 seconds. When testing three
and four databases, response times exceeded 8 seconds and 20 seconds respectively.
Therefore, we determined the maximum number of databases for the legacy server was
two.
Next, we used these established parameters—5,000 users per database using
default think time—and tested the Dell PowerEdge R730xd powered by Intel to evaluate
how many databases it could support using SanDisk DAS Cache with two SSD
configurations, both of which used 400GB SSD capacity for caching purposes. First, we
configured the Dell PowerEdge R730xd with two SATA SSDs to be used by DAS Cache as
the cache pool. In this configuration, the server supported 12 SQL Server databases and
60,000 concurrent users—six times as many as the legacy server—and achieved a server
response time of 0.42 seconds, 2.5 times as fast as that of the legacy server. Next, we
replaced the two SATA SSDs with two PCIe SSDs for the cache pool. In this configuration,
the server again supported six times as many databases and users as the legacy server
and server response time improved even more— 0.26 seconds, four times as fast as that
of the legacy server. We stopped consolidating at 12 SQL Server databases, as the
storage acceleration consistently pushed the CPU utilization to over 75 percent.
Figure 2 shows how both configurations of the Dell PowerEdge R730xd with DAS
Cache running SQL Server 2014—with SATA SSDs and with PCIe SSDs— supported six
times as many concurrent users as the legacy server supported.
(45 pages)
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Commentaires sur ces manuels