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
  Mapping or unmapping best practices
• 3
  SQL Server failover cluster instances
• 4
  Creating volumes
• 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
  Replication and remote recovery
• 6
  Integrated copy data management

• 1
  Appendix: Technical support and resources