Powered by IBM X6 technology, the IBM Solution for Microsoft SQL Data Warehouse on X6 provides outstanding performance and scalability for your mission-critical big data and business intelligence applications.
X6 technology provides faster database performance through better bandwidth and lower latencies. Integrating an innovative design that locates up to 12 TB of ultra-low latency eXFlash memory-channel storage close to the processor, with higher I/O bandwidth that has been relocated for increased performance.
Microsoft SQL Server incorporates the xVelocity in-memory column store index to reduce I/O and CPU loads while improving memory utilization. Combining these Microsoft SQL Server advantages with the powerful X6 enterprise server, this solution will give your organization very fast access to business insights.
The X6 family is designed to be fast from the ground up.
Processing power, thanks to the latest Intel Xeon E7-4800 v2 and E7-8800 v2 processors
Huge memory capacity, with 96 DIMM sockets in the x3850 X6 and 192 DIMM sockets in the x3950 X6 (and with support for 64 GB LRDIMMs, you can have up to 6 TB of memory in the x3850 X6 or 12 TB in the x3950 X6)
New storage technologies, with IBM eXFlash memory-channel storage that closely aligns the performance of storage with the power of the processors
Intelligent storage caching, thanks to IBM FlashCache Storage Accelerator
Takeshi Numoto, Corporate Vice President, Server & Tools Marketing at Microsoft Corporation had this to say:
"Microsoft and IBM have collaborated for years to deliver the computing foundation for achieving enterprise business results on x86 servers. Today that work continues as SQL Server 2014 provides groundbreaking in-memory capabilities across all database workloads, Windows Server 2012 R2 with Hyper-V delivers breakthrough enterprise-grade virtualization technologies, and IBM presents new mission critical IBM X6 offerings. On this foundation—and with the new IBM eXFlash memory-channel storage—Microsoft and IBM are set to deliver performance-optimized data solutions with SQL Server 2014 and resilient enterprise virtualization with Windows Server 2012 R2 Hyper-V."
The IBM System x Performance Lab in Kirkland, Washington demonstrated the benefits of using IBM System x3850 X6 with SQL Server 2012 for a large-scale Decision Support System. The X6 results were compared with results from the earlier generation x3850 X5 server with four 10-core processors.
Reduced query average durations by an average of 58%
Increasing the average physical throughput by 194%
Read the performance report here
The IBM x3850 X6 running Microsoft SQL Server 2014 delivered the best performance ever on the TPC-E benchmark. The TPC-E benchmark is designed to enable clients to more objectively measure and compare the performance and price of various OLTP systems.
Read the x3850 X6 TPC-E Benchmark here
Additional IBM and SQL sources:
IBM System x Solution for Microsoft SQL Data Warehouse on X6 – Solution Guide (click on the first solution under Explore data management solutions & software)
Explore IBM and Microsoft Data Management Solutions
Randall Lundin is a World Wide Product and Marketing Manager for IBM System x. He manages the Enterprise 4 socket rack systems. Follow Randall on Twitter at @RWLUNDIN or view Randall's LinkedIn profile.