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.
- Performance Benchmark Result: TPC-H 30TB Benchmark Result for System x3950 X6
- o Lenovo ThinkSystem SR950 Achieves World Record Non-Clustered TPC-H@10,000GB Benchmark Result
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:
- Configuration Brief: Lenovo Database Configuration for Microsoft SQL – 9 TB
- Predefined configurations may be found in the Lenovo Enterprise Solutions Configurator
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:
- Configuration Brief: Lenovo Database Configuration for Microsoft SQL – 50 TB
- Predefined configurations may be found in the Lenovo Enterprise Solutions Configurator
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:
- Configuration Brief: Lenovo Database Configuration for Microsoft SQL – 50 TB HA
- Predefined configurations may be found in the Lenovo Enterprise Solutions Configurator
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:
- Configuration Brief: Lenovo Database Configuration for Microsoft SQL – 65 TB HA
- Predefined configurations may be found in the Lenovo Enterprise Solutions Configurator
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 (4-socket configuration) combined with Lenovo PX04PMC 4TB NVMe Mainstream Flash Adapters to support data warehouse requirements up to 90 TB in capacity. With this solution Lenovo extends its portfolio of Microsoft certified database solutions featuring Microsoft SQL Server 2017 Enterprise Edition software.
Learn More:
- Configuration Brief: Lenovo Database Configuration for Microsoft SQL – 90 TB
- Predefined configurations may be found in the Lenovo Enterprise Solutions Configurator
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:
- Configuration Brief: Lenovo Database Configurations for Microsoft SQL Server 2016 OLTP
- Configuration Brief: Lenovo Database Configuration for Microsoft SQL Server 2017 OLTP
- Predefined configurations may be found in the Lenovo Enterprise Solutions Configurator
- Information on this program may be found on the Intel Select Solution Website
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:
- Configuration Brief: Lenovo Database Configuration for Microsoft SQL Server Enterprise OLTP on SR650
- Configuration Brief: Lenovo Database Configuration for Microsoft SQL Server Standard OLTP on SR650
- Configuration Brief: Lenovo Database Configuration for Microsoft SQL Server OLTP on SR950
- Predefined configurations may be found in the Lenovo Enterprise Solutions Configurator
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:
- Configuration Brief: Lenovo Database Configuration for Microsoft SQL Server OLTP on Flex System with DS6200
- Predefined configurations may be found in the Lenovo Enterprise Solutions Configurator
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:
- Design Brief: Lenovo Database Validated Design for Microsoft OLTP with VMware vSAN
- Reference Architecture: Lenovo Database Validated Design for Microsoft OLTP with VMware vSAN
- White Paper: Accelerate Applications with VMware vSAN and Lenovo Servers
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:
- Design Brief : Lenovo Database Reference Architecture for Microsoft SQL OLTP on ThinkAgile HX
- Reference Architecture : Lenovo Database Validated Design for Microsoft SQL OLTP on ThinkAgile HX
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:
- Configuration Brief: Lenovo Database Reference Architecture for Microsoft SQL OLTP on ThinkAgile SXM