SQL Server 2019 Best Practices on PowerEdge Servers and PowerStore T Model Arrays

• 1

  Executive summary
• 2

  Document purpose
• 3

  Audience

• 1

  Market environment

• 1

  Solution overview
• 2

  The approach
• 3

  Benchmark tool
• 4

  Test methodology
• 5

  Best practices category

• 1

  Physical architecture
• 2

  Server
• 3

  Fibre Channel Switch
• 4

  Storage array
• 5

  Software architecture
• 6

  SQL Server 2019
• 7

  VMware
• 8

  Red Hat Enterprise Linux

• 1

  Baseline configuration
• 2

  CPU reservation
• 3

  SQL Server Configuration

• 1

  Storage best practice
• 2

  PowerStore: Add Multiple LUNs
• 3

  VMware: Use vVols for SQL Server 2019
• 4

  PowerStore: Volume Performance Policy

• 1

  Server best practices
• 2

  PowerEdge R750xs: Database Optimized Performance Workload Profile
• 3

  PowerEdge R750xs: Dell Controlled Turbo
• 4

  PowerEdge R750xs: Enabling Processor x2APIC Support
• 5

  PowerEdge R750xs: Disable Unused Integrated Devices
• 6

  VMware vSphere: Power Management Policy

• 1

  Consolidated: RHEL and SQL Server 2019 best practices
• 2

  Red Hat Enterprise Linux: SQL Server Tuned Profile
• 3

  Red Hat Enterprise Linux: Last Accessed Time (atime)
• 4

  SQL Server 2019: CPU Affinity
• 5

  SQL Server 2019: Forced Unit Access
• 6

  Recommendation

• 1

  Conclusion
• 2

  We value your feedback