LENOVO DATABASE SOLUTIONS

  • Microsoft Data Warehouse Fast Track

    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 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
  • 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