Lenovo Database Configuration for Microsoft SQL Server TB

(1)

HIGHLIGHTS



Standard 37 TB SQL

DWFT solution from

Lenovo



High Performance SAS

SSD storage with Guardian

Technology™



Balanced and Optimized

configuration



Certified by Microsoft



Reduced time to value

Data Warehouse problem and a solution

The rapid growth of technology means that the amount of available data and the ability to collect that data increased to a level unthinkable as little as five years ago. As the volume and velocity of data increased, however, extracting meaningful insight in a timely manner became more complex. Therefore, opportunities are being missed and effort is being wasted. To compete, businesses in the 21st century are demanding the tools to derive true value from their data.

This Microsoft Data Warehouse Fast Track (DWFT) configuration for SQL Server 2014 improves time-to-value for data warehousing needs with a new scalable architecture. This solution in the Lenovo portfolio uses the high performance System x3650 M5 server combined with SanDisk Optimus Max High Performance SAS solid state drives to solve SQL database warehouse needs up to 37 TB in size.

Microsoft Data Warehouse Fast Track program makes it easy to reduce costs, save time, and reduce risk with reliable, pretested hardware and best practices for data warehousing. This solution features the following highlights:

 Reduce time to value with pretested hardware configurations.

 Reduce hardware testing and reduce tuning immediately.

 Reduce total cost of ownership through better price and performance, rapid deployment, and advanced hardware.

 Optimize performance with pretested System x3650 M5 hardware configurations.

 Consolidate storage and match IT investment-to-information-value with SanDisk Optimus MAX High Performance SAS solid state drives

The configuration that is listed in this document has the following Microsoft certified performance rating:

 Fast Track RowStore measured I/O throughput: 4,712 MBps

 ColumnStore throughput: 192 Queries/Hr/TB

Reference configurations for DWFT for SQL Server bring together the right mix of technology and software, integrating the latest powerful Lenovo System servers, robust System Storage and the data warehouse capabilities of SQL Server 2014 Enterprise Edition. Each offering, from Basic (<10 TB DW) to Standard (10–40 TB DW) to Advanced (>40 TB DW), consists of:

 Pretested server and in-server flash storage configuration, specifically balanced and optimized for data warehousing

 Microsoft SQL Server 2014 Enterprise Edition for a scalable enterprise data warehouse platform

WWW.LENOVO.COM

Lenovo Database Configuration for

Microsoft SQL Server 2014 – 37TB

(2)

Enterprise data warehouse with faster time-to-value

DWFT for SQL Server 2014 for Lenovo System offerings are methodically tested and tuned to save months of configuration, setup, testing, and tuning. With this offering from Lenovo and SanDisk the following tasks can now be completed:

 Buy all the hardware needed from only one vendor including servers, storage (SanDisk Optimus Ascend SSDs are standard Lenovo offerings in this and other platforms), and networking.

 Build, tune, and deploy with confidence by using established data warehouse best practices. Select from different levels of performance, scalability, and price to suit business needs.

 Choose from 4 to 120 Intel Xeon processor cores.

 Run targeted query workloads that are patterned for large sequential data sets rather than small random transactions.

 Eliminate bottlenecks with optimized rapid data reads and query aggregations.

Better data compression and query time

The clustered column store index (CCI) in SQL Server 2014 is designed for use with data warehouses to deliver better data compression and sub-second query response time, which enables interactive analytics on the data. There is no need to pre-aggregate the data for the anticipated queries or reports.

CCI offers the following performance benefits:

 CCI is optimized for query performance. It gives 10x better query response time and 7x higher compression ratio.

 CCI can be updated, which allows two types of concurrent insert of new data while the query workload is running. This capability reduces the data latency from the time data is born to when it is available for querying.

 By using CCI, SQL Server 2014 delivers industry-leading TPC-H benchmark numbers for data warehouse workloads.

(3)

Powered by System x3650 M5 and SanDisk Optimus

Max high performance 4TB SAS SSDs

Lenovo System servers, such as the System x3650 M5 server, feature the latest Intel Xeon E5-2600 v3 series processors. With more cores and more memory, the new M5 family is fast. The greatly increased processing power is provided by the latest Intel Xeon E5-2600 v3 processors. Lenovo System x3650 M5 servers include the following features:

 Two times the memory capacity of previous generation processors, with 24 DIMM sockets in the x3650 M5.

 Support for 64 GB TruDDR4 Memory LRDIMMs, up to 1.5 TB of memory in the x3650 M5.

 Increased flash capacity enables efficient consolidation and smarter use of CPU resources, such as the SanDisk Optimus Max SAS SSD for Lenovo System servers, which closely align the performance of storage with the power of the processors.

The 37 TB version of the Lenovo Database Configuration for Microsoft SQL DWFT Server 2014 features the System x3650 M5 with SanDisk Optimus Max SAS SSD which improves productivity through data consolidation, availability performance, and scalability.

The Optimus MAX SSD utilizes the latest 19nm eMLC NAND flash technology combined with the innovative Guardian Technology™ Platform to deliver high performance, superior reliability and enhanced endurance for maximum application scalability and total cost of ownership (TCO) savings. The reference configuration is a 2-socket system that uses the DWFT V3 methodology.

The configuration features the following main components:

 Server: Lenovo System x3650 M5

 Processor: Two Intel E5-2690 v3 12C 2.6 GHz processors

 Memory: 384 GB of DDR4 memory

 Storage: Eighteen

SanDisk Optimus Max 4TB SAS SSDs for data, tempdb

 OS Storage: Two 500 GB SAS HDDs for the operating system (RAID 1)

 Logging: Two

SanDisk Optimus Max 4TB SAS SSDs

for log (RAID 1)

Lenovo System x3650 M5 High Performance Rack Server and SanDisk Optimus Max 4TB SAS SSDs

(4)

(5)

Bill of materials

Feature code Description Quantity

5462-AC1 Lenovo System x3650 M5 1

A5EW Lenovo System 900W High Efficiency Platinum AC Power Supply 2 A5EY System Documentation and Software-US English 1

A5FV Lenovo System Enterprise Slides Kit 1

A5FX Lenovo System Enterprise 2U Cable Management Arm (CMA) 1

A5EA Lenovo System3650 M5 Planar 1

A5B7 16GB TruDDR4 Memory PC4-17000 CL15 2133MHz LP RDIMM 24

A5FH System x3650 M5 Agency Label GBM 1

A5FM System x3650 M5 System Level Code 1

A4C2 HDD Filler ASM GEN 3 2

9206 No Preload Specify 1

A4C1 2U bracket for low profile-internal-storage adapter 1

A5FZ Lenovo System x3650 M5 Riser Filler 2

A1X6 3U bracket for low profile-internal-storage adapters 1

A2HP Configuration ID 01 2

A5V8 Lenovo System x3650 M5 2.5" HDD Bay ID Label (16 to 23) 1 A5FT Lenovo System x3650 M5 Power Paddle Card 1

A5G1 Lenovo System x3650 M5 EIA Plate 1

A5FC Lenovo System x3650 M5 WW Packaging 1

A5V5 Lenovo System x3650 M5 Right EIA for Storage Dense Model 1 A5EQ Addl Intel Xeon Processor E5-2690 v3 12C 2.6GHz 30MB 2133MHz 135W 1 A5GX Intel Xeon Processor E5-2690 v3 12C 2.6GHz 30MB Cache 2133MHz 135W 1 5977 Select Storage devices - no configured RAID required 1 A5TN Lenovo x3650 M5 24x 2.5" HS HDD Assembly Kit (Dual RAID) 1

A3YZ ServeRAID M5210 SAS/SATA Controller 2

A5FD Lenovo System x3650 M5 2.5" Base without Power Supply 1 A4TT 500GB 7.2K 6Gbps NL SAS 2.5" G3HS HDD 2 ASW6 3.84TB 6Gb SAS Enterprise Capacity G3HSÂ MLC SSD 20 6400 2.8m, 13A/125-10A/250V, C13 to IEC 320-C14 Rack Power Cable 2

(6)

Availability: Offers, prices, specifications and availability may change without notice. Lenovo is not responsible for photographic or typographical errors. Warranty: For a copy of applicable warranties, write to: Lenovo Warranty Information, 1009 Think Place, Morrisville, NC, 27560, Lenovo makes no representation or warranty regarding third-party products or services. Trademarks: Lenovo, the Lenovo logo, System x, ThinkServer are trademarks or registered trademarks of Lenovo. Microsoft and Windows are registered trademarks of Microsoft Corporation. Intel, the Intel logo, Xeon and Xeon Inside are registered trademarks of Intel Corporation in the U.S. and other countries.

High Performance at low cost with Lenovo x3650 M5 servers and SanDisk Optimus Max SAS SSDs

Why Optimus MAX SAS solid state storage from

SanDisk

The Optimus MAX SSD is the industry’s first SAS SSD to deliver high-density data storage and efficient data throughput for enterprise, cloud, and virtualized data centers, surpassing all maximum capacity SAS SSDs and SAS HDDs on the market today. This 4TB SSD provides SAS performance for the price of SATA SSD and enables organizations to transition to a leaner infrastructure model. The Optimus MAX SSD is designed for read-intensive applications such as data warehousing, media streaming, web servers, video on demand and web-based applications.

Why Lenovo System servers for Microsoft SQL

DWFT

Lenovo offers a wide range of servers and options. The Lenovo reference configurations for DWFT for SQL Server bring together the right mix of technology and software. The configurations integrate the latest powerful Lenovo System rack and enterprise servers, robust Lenovo Storage options, and the data warehouse capabilities of SQL Server 2014 Enterprise Edition.

Why Lenovo

Lenovo is a leading provider of x86 servers for the data center. Featuring rack, tower, blade, dense and converged systems, the Lenovo server portfolio provides excellent performance, reliability and security. Lenovo also offers a full range of networking, storage, software, solutions, and comprehensive services supporting business needs throughout the IT lifecycle. With options for planning, deployment, and support, Lenovo offers expertise and services needed to deliver better service-level agreements and generate greater end-user satisfaction.

For More Information

To learn more about the Lenovo Database Configuration for Microsoft SQL Server 2014 – 37TB solution, contact your Lenovo Business Partner or visit: