Reference Architecture: Microsoft SQL Server

This reference architecture covers Microsoft SQL Server 2017 using Lenovo ThinkSystem servers, storage and network switches. With Microsoft’s announcement of the end of life for Microsoft SQL Server 2008, this reference architecture can help address what is needed to migrate existing SQL Server databases to a modern Lenovo infrastructure. The intended audience is IT professionals, technical architects, sales engineers, and consultants to assist in planning, designing, and implementing Microsoft SQL Server.

This document provides an overview of the business problem and business value that is addressed by Microsoft SQL Server. A description of customer requirements is followed by an architectural overview of the solution and a description of the logical components. The operational model describes the architecture and components for deploying Microsoft SQL Server in small to very large Enterprises. Performance and sizing information is provided with the best practices for deploying Microsoft SQL Server.

Introduction
Business problem and business value
Requirements
Architectural overview
Component model
Operational model
Deployment considerations
Appendix: Bill of Materials
Resources

To view the PDF, click the Download PDF button.

Changes in the June 13 update:

• Updated with improved performance results and better coverage of both local drive and shared storage configurations including use of second-generation Intel Xeon Scalable Processors.

Related product families

Product families related to this document are the following:

• Microsoft Alliance
• Microsoft SQL Server