Consolidating Legacy OLTP Application Servers with the Dell 12th Generation PowerEdge R720 Server Consolidating Legacy OLTP Application Servers with the Dell 12th Generation PowerEdge R720 Server Luis Acosta Solutions Performance Analysis Group
Consolidating Legacy OLTP Application Servers with the Dell 12th Generation PowerEdge R720 Server This document is for informational purposes only and may contain typographical errors and technical inaccuracies. The content is provided as is, without express or implied warranties of any kind. © 2012 Dell Inc. All rights reserved. Dell and its affiliates cannot be responsible for errors or omissions in typography or photography. Dell, the Dell logo, PowerVault, and PowerEdge are trademarks of Dell Inc.
Consolidating Legacy OLTP Application Servers with the Dell 12th Generation PowerEdge R720 Server Contents Executive Summary ................................................................................................. 4 Introduction .......................................................................................................... 4 Test methodology ................................................................................................... 4 Test Results ................................
Consolidating Legacy OLTP Application Servers with the Dell 12th Generation PowerEdge R720 Server Executive Summary With the introduction of the Dell™ 12th generation server product line, customers have an opportunity to lower total cost of ownership (TCO) by consolidating their legacy database application servers. Reasons to consolidate database servers include: system underutilization, hardware/software end of life (EOL), reducing costs associated with power and cooling, or improving overall performance.
Consolidating Legacy OLTP Application Servers with the Dell 12th Generation PowerEdge R720 Server R2 Enterprise, and Microsoft SQL Server 2012 RC1. Figure 1shows the test configuration topology for each of the tests. Figure 1. Hardware Configuration Figure 2 is a physical representation of the RAID configuration layout where the database was built. Figure 2.
Consolidating Legacy OLTP Application Servers with the Dell 12th Generation PowerEdge R720 Server Test Results Latency Average Query Response Time (AQRT) is the time it takes for SQL Server to respond to the query. This metric establishes the performance criteria for our Service Level Agreement (SLA) of 2 seconds. At 14,750 concurrent users, the legacy environment met our maximum SLA of 2 seconds AQRT, while the R720 has an AQRT of just 508 milliseconds at the same user load.
Consolidating Legacy OLTP Application Servers with the Dell 12th Generation PowerEdge R720 Server Figure 4.
Consolidating Legacy OLTP Application Servers with the Dell 12th Generation PowerEdge R720 Server The R720 at 26% utilization is able to handle the OLTP workload of 10 Legacy PowerEdge 2950 Servers, a 10:1 Consolidation at 26% Utilization. The R720 paired with two PowerVault MD1220(s) can do 60% more IOPs than the legacy PowerEdge 2950 / 2x PowerVault MD1120 solution. Figure 6. Consolidation Scenario Conclusion A consolidation project is not a simple task.
Consolidating Legacy OLTP Application Servers with the Dell 12th Generation PowerEdge R720 Server Appendix - test configuration Table 1 describes the software and hardware configuration that was used throughout testing on both the simulated legacy production environment and the 12G test environment. Table 1. Component System System Configuration Legacy environment PowerEdge R720 environment PowerEdge 2950 III PowerEdge R720 Two Intel Xeon X5460, 3.16 GHz quad Two Intel Xeon E5-2670, 2.
