Quick Reference Guide

Dell Quickstart Data Warehouse Appliance 1000
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
5 TB This capacity rating is based on “up-to” capacity,
but adjusted to account for Fast Track Rated
I/O.
FTDW Rated I/O 950.75 MB/s Core performance metric for validation.
Averages physical and logical I/O.
Benchmark Scan Rate -
Logical
745 MB/s Reflects actual user query throughput which
includes reads from RAM/Buffer cache.
Benchmark Scan Rate -
Physical
1156.5 MB/s Reflects physical I/O read from disk during
benchmark.
FTDW Peak I/O 1512 MB/s Maximum observed I/O rate.
FTDW Rated CSI 1662.5 MB/s Represents potential throughput using
Columnstore Index.