Dell PowerEdge R510 - Manual (Page 24)

Dell R510 Reference Configuration for Microsoft SQL Server® 2008 R2 Fast Track Data Warehouse
Page 22
Appendix
Summary of Microsoft SQL Server Fast Track results
The performance of the system configuration was analyzed with RAID1 for simple, average & complex
query variants with 5, 10, 20, 40 sessions. Various maximum degrees of parallelism (MAXDOP) options
were tested to arrive at the optimal configuration for this workload with MAXDOP=6.
Following table shows the results for simple work load with MAXDOP = 6 (4 disk groups, RAID 1)
Session
Physical I/O throughput
total (MB/s)
Logical I/O throughput
(MB/s)
5 Session 915 1093
10 Session 939 1119
20 Session 919 1224
40 Session 872 1378
The results in the following table are for medium work load with MAXDOP = 6 (4 disk groups, RAID 1)
Session
Physical I/O throughput
total (MB/s)
Logical I/O throughput
(MB/s)
5 Session 704 1009
10 Session 767 1145
20 Session 756 1183
40 Session 650 1038
The following results show the benchmarked rates from memory, physical disks and peak for the
validated solution. These results can be used to compare solutions and choose an appropriate
configuration that meets the throughput requirements.
Benchmark Scan Rate
Logical MB/s
Benchmark Scan Rate
Physical MB/s
FTDW Rated I/O
MB/s
FTDW Peak I/O
MB/s
1204 838 1021 1378