Quick Reference Guide

Dell Quickstart Data Warehouse Appliance 2000
Page 9
Conclusion
Microsoft Fast Track Reference Guidelines helped achieve an optimized database architecture on the
Quickstart Appliance with balanced CPU and storage bandwidth. Table 3 shows performance metrics of
the reference configuration.
Table 3: Performance Metrics
Category Value Description
FTDW Rated Data Warehouse
Capacity
12 TB This capacity rating is based on “up-to” capacity,
but adjusted to account for Fast Track Rated
I/O.
FTDW Rated I/O 1909 MB/s Core performance metric for validation.
Averages physical and logical I/O.
Benchmark Scan Rate -
Logical
2164 MB/s Reflects actual user query throughput which
includes reads from RAM/Buffer cache
Benchmark Scan Rate -
Physical
1654 MB/s Reflects physical I/O read from disk during
benchmark.
FTDW Peak I/O 3481 MB/s Maximum observed I/O rate.
FTDW Rated CSI 4337.5 MB/s Represents potential throughput using
ColumnStore Index.