Implementation Guide—SQL Server 2019 Best Practices on PowerStore

• 1

  Business case
• 2

  Document purpose
• 3

  Audience
• 4

  Best practices goals
• 5

  Test approach
• 6

  Benchmark tool
• 7

  Test methodology
• 8

  Best practices

• 1

  Physical architecture
• 2

  Hardware components
• 3

  Software components

• 1

  Baseline configuration
• 2

  System installation and configuration
• 3

  VM network: Distributed Network switches
• 4

  Virtual machine setup and configuration
• 5

  Datastore configuration
• 6

  SQL Server installtion and configuration
• 7

  Install the SQL Server command-line tools
• 8

  Configure the devices and partition
• 9

  SQL Server configuration

• 1

  Storage best practices overview
• 2

  PowerStore: Adding Multiple Storage LUNs
• 3

  PowerStore: Volume Performance Policy

• 1

  Server best practices overview
• 2

  PowerEdge R750xs: Database Optimized Performance Workload Profile
• 3

  PowerEdge R750xs: Enabling Processor x2APIC Support
• 4

  VMware vSphere: Power Management Policy
• 5

  PowerEdge R750xs: Dell Controlled Turbo
• 6

  PowerEdge R750xs: Disable Unused Integrated Devices

• 1

  Red Hat Enterprise Linux and SQL Server 2019
• 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

  VVols Overview
• 2

  Migration

• 1

  Summary
• 2

  We value your feedback