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

     

    Lenovo Database Benchmarks

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

     

    Lenovo Database Validated Design for Microsoft SQL Server OLTP with 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 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– 9 TB 

    This version of the Lenovo Database Configuration for Microsoft SQL Server DWFT 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 – 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 – 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 – 44 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 44 TB in capacity. With this solution Lenovo is the industry’s first company offering a Microsoft certified database solution featuring Microsoft SQL Server 2017 Enterprise Edition software.

    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 – 90 TB 

    This version of the Lenovo Database Configuration for Microsoft SQL Server DWFT uses the high performance Lenovo ThinkSystem SR950 server to support data warehouse requirements up to 90 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 Configurations for Microsoft SQL Server OLTP

    Lenovo offers a pair 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 2016 Standard Edition and Enterprise Edition. To deliver the uptime performance businesses demand in today’s competitive operational environment, these solutions are deployed in two server high availability configurations.

    Learn More:

     

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

    The Lenovo Converged HX7500 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 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 HP Config for Oracle DB

    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. The Lenovo High Performance Configuration for Oracle Database 12c 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:

    Lenovo Scale Up Config for Oracle DB

    Oracle Database software products support both scale-up and scale-out computing. However, deploying Oracle Databases on scale-up servers offers a number of benefits, including reduced server licensing costs. When scaling-up, Oracle Real Application Cluster (RAC) is not required. Another benefit is machine resources (especially CPUs) are instantly available for sharing. Deploying a scale-up architecture enables data center administrators to add resources to existing servers without requiring them to rewrite applications to harness the additional compute power. For large databases, scale-up architectures can provide higher levels of performance than those afforded by large numbers of scale-out distributed databases.

    Lenovo has created a configuration guide that addresses a Lenovo scale-up database configuration.  It describes a validated reference configuration to successfully implement Oracle Database 12c running on Oracle Linux 7.2 and Oracle Unbreakable Enterprise Kernel (UEK), all hosted on a clustered pair of Lenovo System x3950 X6 servers. This configuration is intended for enterprise-level businesses with scaled-up, converged infrastructures, in which cost-effectiveness and productivity are a must. This guide addresses many benefits of this architecture, including:

    • Reduced software licensing costs: With many software packages licensed on a per-processor or per-core basis, reducing the number of systems can significantly lower software support costs. 
    • Improved IT staff productivity: Scale-up servers reduce the total number of processors and servers being managed. With fewer physical servers, and the added automation and manageability features, administrators’ work is less cumbersome. 
    • Reduced end-user productivity losses: Scale-up servers with mission-critical RAS capabilities (such as the System x3850 X6 and the System x3950 X6) incur less unplanned downtime than do scale-out servers. 
    • Accelerated application deployment: With virtualized scale-up servers, you can accelerate application deployment. Projects that previously took weeks to size, purchase, install and configure, can now be ready in hours.

    Learn More:

      

    Oracle
    Oracle
    System x3950 X6
  • 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:

    Database Solutions – MongoDB
    Database Solutions – MongoDB