The MAX5 Advantage: How IBM System x MAX5 Benefits Microsoft SQL Server Data Warehouse Workloads

This IBM® Redpaper™ publication describes the series of tests performed by the IBM System x® Performance Lab in Kirkland, Washington, that demonstrate the benefits of using IBM System x3850 X5 with MAX5 for a large-scale decision support system (DSS) workload.

Overview
Understanding the DSS workload
IBM System x3850 X5
IBM MAX5 for System x
Microsoft SQL Server 2008 R2
IBM High IOPS SSD PCIe adapters
Test environment
Analysis and test results
Conclusion

Related product families

Product families related to this document are the following:

• 4-Socket Rack Servers
• Microsoft Alliance
• Microsoft SQL Server
• Mission Critical Servers