Appendix, Summary of microsoft sql server fast track results – Dell PowerEdge R510 User 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