Published
22 Nov 2023Form Number
LP1856PDF size
27 pages, 1.7 MBAbstract
This document describes the reference architecture for Microsoft SQL Server on vSAN Express Storage Architecture from VMware. The Lenovo and VMware teams worked together on the architectural vision, testing and joint engineering effort to create this Reference Architecture. This paper in intended to provide the planning, design considerations, and best practices for implementing Microsoft SQL Server on VMware vSAN Express Storage Architecture with Lenovo products.
Table of Contents
- Introduction
- Business problem and business value
- Business problem
- Business value
- Architectural overview
- Component model
- VMware vSphere
- VMware vSAN Express Storage Architecture
- Lenovo ThinkAgile VX Series
- Microsoft SQL Server 2022
- Deployment considerations
- Hardware resources
- Software resources
- Network configuration
- Storage Configuration
- SQL Server HA considerations
- Best practices
- Solution validation
- Monitoring tools
- Database workload generation tool
- Scale-up OLTP workload test
- Scale-out OLTP workload test
- SQL Server data protection and snapshot test
- Conclusion
- Appendix: Lenovo Bill of materials
Resources
Document history
Trademarks and special notices
Configure and Buy
Full Change History
Course Detail
Employees Only Content
The content in this document with a is only visible to employees who are logged in. Logon using your Lenovo ITcode and password via Lenovo single-signon (SSO).
The owner of the document has determined that this content is classified as Lenovo Internal and should not be normally be made available to people who are not employees or contractors. This includes partners, customers, and competitors. The reasons may vary and you should reach out to the authors of the document for clarification, if needed. Be cautious about sharing this content with others as it may contain sensitive information.
Any visitor to the Lenovo Press web site who is not logged on will not be able to see this employee-only content. This content is excluded from search engine indexes and will not appear in any search results.
For all users, including logged-in employees, this employee-only content does not appear in the PDF version of this document.
This functionality is cookie based. The web site will normally remember your login state between browser sessions, however, if you clear cookies at the end of a session or work in an Incognito/Private browser window, then you will need to log in each time.
If you have any questions about this feature of the Lenovo Press web, please email David Watts at dwatts@lenovo.com.