LENOVO DATABASE SOLUTIONS

  • Microsoft

    Lenovo Database Configuration 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 Configurations 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 Enterprise Edition to provide the following benefits:

    • Improved time to value with pretested hardware configurations
    • Reduced 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

     

    Benchmark Results for Lenovo Database Configurations for Microsoft SQL Server DWFT

    The Microsoft SQL DWFT configurations utilize parts of TPC-H benchmark testing from tpc.org to assess platform performance. Two TPC-H benchmark test results for Lenovo database configurations for Microsoft SQL have been published in 2016:

     

    Lenovo Database Configuration for Microsoft SQL Server DWFT– 6 TB 

    This version of the Lenovo Database Configuration for Microsoft SQL Server DWFT portfolio uses the cost-effective 1U System x3550 M5 server that is combined with Micron M500DC 480 GB Enterprise Value SATA solid-state drives (SSDs) to address data warehouse requirements up to 6 TB in capacity.

    Learn More:

     

    Lenovo Database Configuration for Microsoft SQL Server DWFT – 7 TB 

    This version of the Lenovo Database Configuration for Microsoft SQL Server DWFT uses the high performance 2U System x3650 M5 server provisioned with SanDisk SATA solid-state drives (SSDs) to address data warehouse requirements up to 7 TB in capacity. 

    Learn More:

     

    Lenovo Database Configuration for Microsoft SQL Server DWFT – 22 TB 

    This version of the Lenovo Database Configuration for Microsoft SQL Server DWFT uses the high performance 2U System x3650 M5 server provisioned with Intel NVMe solid-state drive (SSD) PCIe adapters to address data warehouse requirements up to 22 TB in capacity. 

    Learn More:

     

    Lenovo Database Configuration for Microsoft SQL Server DWFT – 37 TB 

    This version of the Lenovo Database Configuration for Microsoft SQL Server DWFT uses the high performance 2U System x3650 M5 server provisioned with SATA solid-state drives (SSDs) to address data warehouse requirements up to 37 TB in capacity. 

    Learn More:

     

    Lenovo Database Configuration for Microsoft SQL Server DWFT – 40 TB 

    This High Availability version of the Lenovo Database Configuration for Microsoft SQL Server DWFT uses the high performance 2U System x3650 M5 server in conjunction with IBM FlashSystem V9000 storage to address data warehouse requirements up to 40 TB in capacity. 

    Learn More:

     

    Lenovo Database Configuration for Microsoft SQL Server DWFT – 45 TB 

    This version of the Lenovo Database Configuration for Microsoft SQL Server DWFT uses the mission critical 4U System x3850 X6 server provisioned with Intel NVMe PCIe adapters to address data warehouse requirements up to 45 TB in capacity. 

    Learn More:

     

    Lenovo Database Configuration for Microsoft SQL Server DWFT – 60 TB

    This High Availability version of the Lenovo Database Configuration for Microsoft SQL Server DWFT uses the high performance 2U System x3650 M5 server in conjunction with IBM FlashSystem V9000 storage to address data warehouse requirements up to 60 TB in capacity.

    Learn More:

     

    Lenovo Database Configuration for Microsoft SQL Server DWFT – 145 TB 

    This version of the Lenovo Database Configuration for Microsoft SQL Server DWFT uses the mission critical 4U System x3850 X6 server provisioned with Lenovo Enterprise io3 Flash PCIe adapters to address data warehouse requirements up to 145 TB in capacity. 

    Learn More:

     

    Lenovo Database Configuration for Microsoft SQL Server OLTP on HX Series 

    The Lenovo Converged HX7500 delivers a turnkey infrastructure solution for Microsoft applications. Run Microsoft SQL Server online transaction processing (OLTP) database 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 Configuration for Microsoft SQL Server OLTP on ThinkAgile CX

    Lenovo ThinkAgile CX Series simplifies the tasks of sourcing and implementing a converged infrastructure for your data center. Today’s data centers are an assortment of IT silos, often custom-built stacks for multiple applications. This customized and hardware-centric approach leads to spending most data center resources on maintenance and lifecycle management. Run Microsoft SQL Server online transaction processing (OLTP) database alongside other virtualized applications and benefit from:

    • Complete on-premises virtualized platform designed to optimize your workload’s performance
    • Factory-integrated, ready-to-go solutions that ship from the factory already configured
    • Designed for effortless integration into existing infrastructures, thereby reducing deployment time and saving money
    • Lenovo deployment services that are included with the solution

    Learn More:


    lenovo systems solutions database microsoft dwft
    lenovo systems solutions database microsoft dwft
    ThinkAgile CX
  • Oracle

    Lenovo Config for HP Oracle Database 12c

    Oracle users want reliability without sacrificing performance or increasing cost. Many of the high-performance solutions available today are cost-prohibitive to acquire and complex to maintain. This configuration delivers a simple and affordable solution that satisfies the requirements of demanding Oracle users. The Lenovo x3650 M5 server with Fusion ioMemory SX350 storage cards provides a reliable, high-performance solution for running Oracle workloads that efficiently use system resources to help drive down total cost of ownership.

    Lenovo has created a whitepaper that addresses a set of deployable solutions for accelerating various Oracle Database workloads with SanDisk PCIe based flash storage while simultaneously reducing TCO. Two database workloads are examined in this paper: An On-Line Transaction Processing (OLTP) workload, and a Decision Support System (DSS) workload. As shown in this whitepaper, using SanDisk PCIe based flash storage all but eliminates the processor’s spin-wait events and allows the system as a whole to perform significantly more operations per unit of time.  Additionally, this whitepaper

    • Examines how to reduce TCO by running Oracle workloads more efficiently
    • Provides deployable solutions for accelerating Oracle database workloads
    • Examines flash storage based server performance of on-line transaction processing and decision support system workloads on the Oracle Database 12c
    • Evaluates how employing flash storage dramatically reduces completion of database I/O requests

    Learn More:

    Oracle
    Oracle
  • EnterpriseDB

    Lenovo DB Configuration for EnterpriseDB

    Open Source for the Data Center.  The rising cost of managing data—whether from organic growth or hardware upgrades—has become a formidable challenge for IT leaders. Now there is an answer: The Lenovo Database Configuration for EnterpriseDB® Postgres Plus.  Together, the Lenovo x3850 X6 server and the EnterpriseDB Postgres Plus Advanced Server database offer a comprehensive configuration that enables IT leaders to efficiently and effectively meet the constantly evolving demands of today’s exploding data loads and diverse data. 

    Postgres Plus Enterprise Edition is a unique, open source-based software offering that features database compatibility for Oracle® environments. Combining world-class performance and simple-to-use migration tools, Postgres Plus on Lenovo servers is an ideal configuration for your demanding database workloads.

    Learn More:

    Database Solutions – EnterpriseDB
    Database Solutions – EnterpriseDB
  • MongoDB

    Lenovo DB Configuration for MongoDB

    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. 

    The Lenovo Database Configuration for MongoDB Enterprise utilizes the Lenovo System x3850 server for a novel “mid-scale up” approach, leveraging built-in hardware platform capabilities such as four Intel high-performance server processor sockets, large memory, and extensive I/O options. In addition, the scalability and enterprise RAS characteristics enable consolidation of MongoDB workloads onto fewer servers, reducing TCO and increasing performance. 

    Learn More:

    Lenovo Database Configuration for Microsoft SQL Server OLTP on ThinkAgile CX

     

    Lenovo ThinkAgile CX Series simplifies the tasks of sourcing and implementing a converged infrastructure for your data center. Today’s data centers are an assortment of IT silos, often custom-built stacks for multiple applications. This customized and hardware-centric approach leads to spending most data center resources on maintenance and lifecycle management. Run Microsoft SQL Server online transaction processing (OLTP) database alongside other virtualized applications and benefit from:

    • Complete on-premises virtualized platform designed to optimize your workload’s performance
    • Factory-integrated, ready-to-go solutions that ship from the factory already configured
    • Designed for effortless integration into existing infrastructures, thereby reducing deployment time and saving money
    • Lenovo deployment services that are included with the solution

    Learn More:

    Database Solutions – MongoDB
    Database Solutions – MongoDB