Dell POWEREDGE R720 - Manual (Page 16)

Microsoft SQL Server 2012 Fast Track Reference Configurations using PowerEdge R720 and PowerVault MD3620i
16
Reference architecture performance details
Table 5 shows the performance numbers reported for the recommended reference configuration.
Performance metrics Table 5.
Metric Value Description
FTDW Rated Capacity (TB) 10
This capacity rating is based on “up-to”
capacity but adjusted to account for Fast
Track Rated I/O.
FTDW Rated I/O (MB/s) 1690
Core performance metric for validation.
This is the midpoint of Physical and Logical
I/O.
Up-to User Data Capacity (TB) 14
Maximum user data capacity. Includes the
total disk capacity of all disks allocated to
primary data storage and does assume SQL
Server page compression ratio of 3.5:1.
This metric is not limited by rated
bandwidth.
Benchmark Scan Rate Logical
(MB/s)
2070
Reflects actual user query throughput
which includes reads from RAM/Buffer
cache.
Benchmark Scan Rate Physical
(MB/s)
1320
Reflects physical I/O read from disk during
benchmark.
FTDW Peak I/O (MB/s) 2460 Maximum observed I/O rate.
FTDW Rated CSI (MB/s) 4410
Represents potential throughput using
Columnstore Index.
Summary
Dell, in partnership with Microsoft, enables customers to enhance ROI (Return of Investment) on their
data warehouse systems using Fast Track Data Warehouse architectures. These uniquely-designed
architectures ensure optimally designed and architected BI solutions. The end to end database best
practices and recommendations enable the customer to achieve a balanced data warehouse
environment with greater performance than traditional data warehouse systems.
The Dell Microsoft Fast Track Architecture provides the following benefits to customers:
• Delivers a tested and validated configuration with proven methodology and performance behavior.
• Achieves a balanced and optimized system at all the levels of the stack by following the best
practices of hardware and software components.
• Avoids over-provisioning of hardware resources.
• Offers high availability at all levels of setup (host, switches, and storage).
• Helps customers avoid the pitfalls of an improperly designed and configured system.
• Reduces future support costs by limiting solution re-architect efforts because of scalability
challenges.