Dell PowerStore: Microsoft SQL Server Best Practices

• 1
  Overview
• 2
  Audience
• 3
  Revisions
• 4
  We value your feedback

• 1
  PowerStore and SQL Server
• 2
  PowerStore product overview
• 3
  Microsoft SQL Server product overview
• 4
  Prerequisite reading
• 5
  Terminology

• 1
  Introduction
• 2
  SQL Server scale-up
• 3
  SQL Server scale-out
• 4
  PowerStore scale-up
• 5
  PowerStore scale-out

• 1
  Introduction
• 2
  External SQL Server hosts
• 3
  AppsON

• 1
  Introduction
• 2
  SQL Server design considerations
• 3
  SQL Server deployment platforms
• 4
  RAID configurations and storage pools
• 5
  Validating the I/O path
• 6
  MPIO

• 1
  Overview
• 2
  PowerStore Node Affinity
• 3
  Virtualization
• 4
  AppsON
• 5
  Reducing SQL Server I/O

• 1
  Introduction
• 2
  Volume mapping and clustering
• 3
  Creating volumes
• 4
  Performance monitoring
• 5
  Allocation unit size
• 6
  Disk-format wait time
• 7
  Thin clones
• 8
  Data encryption
• 9
  Data reduction
• 10
  Scripting and automation

• 1
  Introduction
• 2
  Snapshots and recoveries
• 3
  Snapshots and application backup and restore
• 4
  Crash consistency and application consistency
• 5
  Native PowerProtect DD series appliance integration
• 6
  SQL Server application-consistent backup
• 7
  T-SQL snapshot backup overview
• 8
  T-SQL snapshot backup and restore for Windows
• 9
  T-SQL snapshot backup and restore for Kubernetes
• 10
  Replication and remote recovery
• 11
  Integrated copy data management
• 12
  SQL Server Ledger

• 1
  Dell Support and additional resources