Database Solutions

LENOVO DATABASE SOLUTIONS

Lenovo Database Solutions for Microsoft SQL

The rapid growth of technology means the ability to collect vast amounts of data and support high rate
online transactions. As the volume and velocity of data increases, extracting meaningful insight in a
timely manner or supporting online transactions has become more complex. 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.

The below Lenovo Database Solutions for Microsoft® SQL Server® bring together the right mix of
technology and software to align with a range of data warehouse and transactional database use cases. The
configurations integrate a variety of Lenovo Systems and appliances, robust Lenovo Storage options and the
capabilities of Microsoft SQL Server 2016/2017 Enterprise and Standard Editions to provide the following
benefits:

Improved time to value with pretested hardware configurations

Optimized SQL server deployment with a significant reduction in hardware testing and tuning

Reduced total cost of ownership through better price and performance, rapid deployment, and advanced
hardware

Consolidated storage and matched IT investment-to-information-value with several high performance
storage options

As a certified reseller of Microsoft SQL Server and Microsoft Windows Server software, Lenovo can
provide customers with a consolidated purchase experience of both hardware and software across this
broad portfolio of Microsoft based database solutions.

Microsoft SQL TCO Study

A Total Cost of Ownership (TCO) study providing a quantitative assessment of Microsoft SQL solutions from
Lenovo was recently conducted by Cabot Partners, an IT analyst firm focusing on emerging computing
technologies. The economic benefit of Data Warehousing and Online Transaction Processing (OLTP) databases
using Microsoft SQL Server is large. This paper focuses on the cost and value drivers for Microsoft SQL
Server based offerings and how Lenovo solutions provide added value when compared with other options
available in the market.

Lenovo Database Benchmarks

Lenovo has published the best performance result ever on the non-clustered TPC-H benchmark @10,000GB scale. This new result showcases the capability of the Lenovo ThinkSystem SR950 with the latest Intel Xeon processor technology running Microsoft SQL Server 2017.

Lenovo Database Configuration for Microsoft SQL Server DWFT – 50 TB

This version of the Lenovo Database Configuration for Microsoft SQL Server DWFT uses the high performance 2U Lenovo ThinkSystem SR650 server to support data warehouse requirements up to 50 TB in capacity. This high capacity and performance were achieved by employing the ThinkSystem SR650 architecture combined with high end components like the Intel P4510 NVMe solid state drives. With this solution Lenovo is the industry’s first company offering an Intel Select Solution for a Microsoft SQL Server based data warehouse application. It is also an industry first Microsoft certified database solution featuring Microsoft SQL Server 2017 Enterprise Edition software deployed on Microsoft Windows Server 2019.

Lenovo offers a Microsoft SQL Server DWFT solution featuring the highly available Lenovo ThinkSystem SN550
compute node deployed in the Lenovo Flex System Enterprise chassis. For storage, this solution also
features the Lenovo ThinkSystem DS6200 SAN which is designed for I/O intensive applications. Enabled with
Microsoft SQL Server 2017, this solution improves time-to-value for data warehouse analytics applications
with a scalable architecture.

This data warehouse solution features a pair of the highly available Lenovo ThinkSystem SR650 servers deployed with the Lenovo ThinkSystem DM7000 Series All-Flash Array. This system has been configured and networked to support the I/O intensive duty cycles demanded by a Microsoft SQL Server DWFT workload. Enabled with the Enterprise Edition of Microsoft SQL Server 2017, this solution improves time-to-value for data warehouse analytics applications.

Through the Intel Select Solution program, Lenovo offers a growing portfolio of high
availability Microsoft SQL Server OLTP solutions featuring the robust ThinkSystem SR630 and SR650 servers.
These transactional database offerings combine high-performance and cost effective server platforms with
Microsoft SQL Server software. These solutions are based on the Intel Select Solution specifications and
performance results have been verified by Intel. To deliver the uptime performance businesses demand in
today’s competitive operational environment, these solutions are deployed in two server high
availability configurations.

Key benefits of investing in an Intel Select Solution from Lenovo include:

Fast and easy deployment. With pre-defined settings and rigorous system-wide
tuning, Intel Select Solutions are designed to increase efficiency in the IT testing process, speed
time to service delivery, and increase confidence in solution performance.

Workload-optimized performance. The Intel Select Solution configurations offered
by Lenovo are jointly designed by Lenovo and Intel to deliver performance at a specified workload
threshold and are built on the latest Intel architecture foundations.

Lenovo Database Configuration for Microsoft SQL Server OLTP on Flex System with DS6200

Lenovo offers a Microsoft SQL Server OLTP solution featuring the highly available Lenovo ThinkSystem SN550
compute node deployed in the Lenovo Flex System Enterprise chassis. For storage, this solution also
features the Lenovo ThinkSystem DS6200 SAN which is designed for I/O intensive applications. Enabled with
Microsoft SQL Server 2016, this solution improves time-to-value for transactional needs with a new scalable
architecture to solve SQL database transactional needs up to 50,000 batch requests per second.

Based upon the Lenovo ThinkSystem platform, this solution features the latest generation of SSDs to provide
high IOPs, low latency and high storage capacity for virtualized Microsoft SQL Server databases.
Virtualization of databases using VMware ESXi hypervisors and vSAN storage enables the creation more
database instances on a single platform and with a higher density level than otherwise possible, thus
reducing the required number of servers. This tested and advanced configuration leverages the high
performance capabilities of the Lenovo ThinkSystem SR650 and SR630 servers for database computing and
in-server virtual storage providing:

The Lenovo ThinkAgile SX for Microsoft Azure Stack appliance delivers a pre-integrated, easy-to-deploy
rack-level solution for hybrid clouds to dramatically reduce time-to-value and total cost of ownership
(TCO). This appliance is based on Lenovo industry-leading data center hardware and Microsoft Azure Stack
which is an extension of Microsoft Azure Services to on premise environments. This solution addresses the
deployment of a Microsoft SQL Server OLTP workload on the Lenovo ThinkAgile SXM appliance. It’s the
perfect platform to:

Deliver Azure cloud services from the security of your own data center

Enable rapid development and iteration of applications with on-premises deployment tools to help
transform your organization

Lenovo has developed a pair of database solutions featuring the Enterprise Edition of the Oracle 12c software and the Lenovo ThinkSystem portfolio of Server, Storage and Networking platforms. These offerings are made highly available and scalable by featuring the Oracle Real Application Clusters (RAC) option that is available to deployments that use the Enterprise Edition of Oracle 12c. By employing Oracle RAC in a database deployment, no single server failure can bring down a database cluster. Additionally, Oracle RAC also allows enhances cluster maintenance by allowing servers to be taken offline for service without impacting cluster performance. These solutions enable businesses to deploy a cost effective yet highly reliable Oracle 12c RAC database and allows administrators to provision infrastructure resources in a repeatable and consistent manner. Additionally, these solutions feature the following key attributes:

A unified architecture to serve both Oracle transaction and data warehouse workloads

A Infrastructure design which scales uniformly based on the workload requirements

An Oracle validated configuration that yields a pre-tested architecture with optimized infrastructure components

Faster deployment with ease of management

Lenovo Database Validated Design for Oracle 12c on SR650

The Lenovo Database Validated Design for Oracle 12c on SR650 is a database offering developed by combining the Lenovo ThinkSystem SR650 2-socket rack server with the ThinkSystem DS6200 storage array. The resulting pre-tested validated design enables faster deployment times, storage scalability and features the infrastructure elements required for an Oracle certified 12c RAC (Real Application Cluster) database deployment. In addition to redundant servers and a storage system, this architecture features data networking and storage switching elements.

Lenovo Database Configuration for Oracle 12c on SR850

Lenovo has developed a highly available database offering by combining the Lenovo ThinkSystem SR850 4-socket rack server with the ThinkSystem DM5000 storage array. The resulting pre-tested validated design enables faster deployment times, storage scalability and features the infrastructure elements required for an Oracle certified 12c RAC (Real Application Cluster) database deployment. In addition to redundant servers and a storage system, this architecture features data networking and storage switching elements. This solution starts at 2 servers and can scale with Oracle RAC for availability and capacity. By employing a Lenovo high availability server this solution enables businesses to deploy a high performance and highly reliable Oracle 12c RAC database.

Lenovo Solutions for SAP HANA: Simple & Scalable

You need new ways to accelerate decision making and gain insights into key trends locked in your data. With the Lenovo ThinkSystem and ThinkAgile solutions for SAP® HANA®, your organization will be able to instantly access, model, and analyze all of your SAP business transactional and analytical data from virtually any data source in real time.

Choose from a preconfigured solution or a custom Tailored Datacenter Integration (TDI) solution. Scale-out and effectively protect your data with integrated high-availability and synchronous disaster-recovery capabilities using IBM® Spectrum Scale, or leverage high availability features in SUSE Linux Enterprise Server for SAP Applications or Red Hat Enterprise Linux. Additionally, VMware® virtualization technology can be used for optimizing deployment and management of your Lenovo server application environment.

New SAP HANA solutions for ThinkAgile HX and ThinkAgile VX help speed deployment, simplify management and deliver dramatic data-center efficiency for SAP HANA workloads in Nutanix and VMware hyperconverged clusters, respectively. It comes fully backed by Lenovo Professional Services so that you can rely on Lenovo’s deep SAP HANA expertise to deploy and manage SAP HANA with confidence.

SAP HANA Offerings for the Mid-Market

SAP HANA, Edge edition, advanced version

The Lenovo Solution for SAP HANA®, Edge edition, advanced version for small and mid-sized enterprises (SME) combines the speed of in-memory processing with the ability to analyze massive amounts of data from every aspect of your organization – enabling small and mid-sized companies to eliminate time lag between business events and decisions. Built on Lenovo offerings that rank #1 in customer reliability and satisfaction1, and developed in close collaboration with SAP, the Lenovo Solution for SAP HANA, Edge edition, advanced version provides unique capability for SAP HANA® applications to drive enterprise-critical insights in real time.

SAP Business One with SAP HANA

Lenovo System solutions for SAP Business One® with SAP® HANA® enable smaller businesses and subsidiaries to take advantage of in-memory computing technology with an affordable in-memory analytics platform.

SAP NetWeaver Business Warehouse Accelerator

SAP NetWeaver® Business Warehouse Accelerator (BWA) provides a complete picture of your business from diverse data sources. It extends the reach of traditional SAP NetWeaver Business Warehouse environments and enables near real-time analytics for those not ready to move to SAP® HANA®.

Lenovo provides a choice of server solutions for SAP NetWeaver BWA depending on the size of your data and your scalability needs.

MongoDB Database Solutions

With the exponential growth of data from multiple new sources - for example, mobile, social, and web – new tools and technologies are needed to gather, analyze and visualize data in order to extract powerful insights from this data. In addition
to traditional structured data optimized for relational database management systems, these new sources of data are typically unstructured or semi-structured, meaning that schemas to harness the data must be flexible, distributed for horizontal scaling,
and on preferably low-cost industry-standard servers.