LENOVO DATABASE SOLUTIONS

  • Microsoft

    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 Solution for Microsoft SQL Server

    The Lenovo Database Solution for Microsoft SQL Server has been developed with the focused intent of helping businesses migrate from older versions of Microsoft SQL Server to the latest version and take advantage of all the latest features. It features configurations employing Microsoft SQL Server for OLTP and OLAP (Data Warehouse Fast Track) applications with simplex and high availability options. This solution addresses configurations for small, medium and large business use cases. All configurations have been architected to support deployments with either Microsoft SQL Server 2017 Standard Edition or Microsoft SQL Server 2017 Enterprise Edition. Hardware addressed in this solution includes servers, storage and networking for data and storage.

     

    Lenovo Database Configuration for Microsoft SQL Server
    DWFT– 9 TB  

    This version of the Lenovo Database Configuration for Microsoft SQL Server Data Warehouse Fast Track portfolio uses the cost-effective 1U System ThinkSystem SR630 server that is combined with Lenovo PM863a Enterprise Entry SATA SSDs to address data warehouse requirements up to 9 TB in capacity. With this solution Lenovo is the industry’s first company offering a Microsoft certified database solution featuring Microsoft SQL Server 2017 Standard Edition software.

    Learn More:

     

    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.

    Learn More:

     

    Lenovo Database Configuration for Microsoft SQL Server
    DWFT – 50 TB HA  

    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.

    Learn More:

     

    Lenovo Database Configuration for Microsoft SQL Server
    DWFT – 65 TB HA  

    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.

    Learn More:

     

    Lenovo Database Configuration for Microsoft SQL Server DWFT – High Capacity


    This version of the Lenovo Database Configuration for Microsoft SQL Server DWFT uses the high performance Lenovo ThinkSystem SR950 server (4-socket configuration) combined with the Intel P4510 NVMe solid state drives to support high capacity data warehouse requirements. With this solution Lenovo extends its portfolio of Microsoft certified database solutions featuring Microsoft SQL Server 2017 Enterprise Edition software.

    Learn More:

     

    Intel Select Solutions–Lenovo Database Configurations for Microsoft SQL Server OLTP


    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:

    • Simplified evaluation. Intel Select Solutions are tightly specified in terms of hardware and software components to eliminate guesswork and speed decision-making.
    • 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.

    Learn More:

     

    Lenovo Database Configuration for Microsoft SQL Server OLTP on ThinkSystem Rack Servers

    These versions of the Lenovo Database Configuration for Microsoft SQL Server OLTP use high performance Lenovo ThinkSystem rack servers. These are an optimized OLTP designs that yield high transactional processing speeds for demanding SQL server workloads. Employing high performance write-intensive NVMe PCIe SSDs, these easy to deploy configurations are optimized for multiple database consolidation efforts and feature Microsoft SQL Server 2017.

    Learn More:

     

    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.

    Learn More:

     

    Lenovo Database Validated Design for Microsoft SQL Server OLTP on VMware vSAN

    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:

    • Reduced TCO while improving resiliency and performance of virtualized Microsoft SQL Server transactional systems with a software-defined validated design
    • Traditional storage and simplified delivery of purpose-built infrastructure for steady-state transactional systems
    • A hyperconverged infrastructure on demand with vRealize running XClarity software

    Learn More:

     

    Lenovo Database Validated Design for Microsoft SQL Server OLTP on ThinkAgile HX

    The Lenovo ThinkAgile HX delivers a turnkey infrastructure solution for Microsoft applications. Run Microsoft SQL Server alongside other virtualized applications and benefit from:

    • Higher performance and scalability: Start small and scale databases as your needs grow, but without the concessions of traditional infrastructure.
    • Improved availability: Keep key applications protected and running with frequent, easy-to-restore backups and affordable, simple disaster recovery.
    • Reduced operational complexity: Leverage simple, consumer-grade management, VM-centric operations and unprecedented insight into application and storage performance.

    Learn More:

     

    Lenovo Database Validated Design for Microsoft SQL Server OLTP on ThinkAgile SXM

    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
    • Unify application development across your entire hybrid cloud environment
    • Easily move applications and data across private and public clouds

    Learn More:

     

    lenovo systems solutions database thinksystem sr630 lenovo systems solutions database thinksystem sr650 lenovo systems solutions database thinksystem sr950 lenovo systems solutions database system x3550 m5 lenovo systems solutions database system x3650 m5 lenovo systems solutions database system x3850 x6 lenovo systems solutions database converged hx series
  • Oracle

    Lenovo has developed several 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 enhanced 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 allow administrators to provision infrastructure resources in a repeatable and consistent manner.

    The Lenovo Database Validated Designs for Oracle 12c run on ThinkSystem SR650 2-socket, ThinkSystem SR850 4-socket, or ThinkSystem SR950 8-socket servers with the ThinkSystem DM5000 all flash storage array. The resulting pre-tested and certified Oracle Validated Configurations enable faster deployment times, storage scalability and feature the infrastructure elements required for an Oracle 12c RAC database deployment. In addition to redundant servers and a storage system, this architecture features data networking and storage switching elements.

    All solutions feature the following key attributes:

    • A unified architecture to serve both Oracle transaction and data warehouse workloads
    • An 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

    Learn More:

     

    Oracle
    System x3950 X6
  • SAP HANA & BWA

    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-up with the new SAP HANA solution for ThinkSystem SR950 utilizing the latest Intel® Optane persistent memory, or 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.

    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.

    Configuration and Pricing

    Solution Briefs and Datasheets

    Reference Architectures and Product Guides

    White Papers

    Customer Case Studies

    Videos

     

    Enterprise Solution Services for SAP HANA

    Lenovo Enterprise Solution Services and qualified Lenovo Business Partners offer fast implementation services and ongoing maintenance of your SAP® HANA® solution. 24x7 managed services are available from Lenovo Enterprise Solutions Services.

    Lenovo Enterprise Solution Services for SAP HANA, solution reference number: DBSSAPX004

     

    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.

    1According to ITIC and TBR.

    Learn More:

     

    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.

    Learn More:

     

    SAP NetWeaver BWA Services

    Lenovo Services offer fast implementation services and on-going maintenance of your SAP NetWeaver BWA solution. 24x7 managed services are also available.

    Learn More:

     

    Oracle
  • MongoDB

    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.

    Learn More:

    Database Solutions – MongoDB
    Database Solutions – MongoDB