Dell EMC SC Series: Microsoft SQL Server Best Practices

This document describes best practices when using Dell EMC™ SC Series arrays with Microsoft® SQL Server®.


Dell EMC SC Series: Microsoft SQL Server Best Practices - cover page
Brand
Dell EMC
Category
Disk Array
Document type
Other
Language
English
Pages
22
File format
PDF
File size
576 KB
Published
25 November, 2023
Updated
25 November, 2023
MD5 checksum
93C3FEE5892410069D536FF52DB780E9

About this manual

This document describes best practices for running Microsoft SQL Server (versions 2008 and later) with Dell EMC SC Series arrays. It is intended for database, system, storage administrators, and architects who analyze, design, and maintain database and storage systems.

It covers sizing for SQL Server, validating the storage design, storage setup and configuration, Windows and server setup, and optimizing SQL Server I/O. Topics include I/O performance metrics, write penalty, RAID considerations, SSD use, snapshots, MPIO, partition alignment, memory, compression, and database design.

What's inside

  • SQL Server on SC Series arrays
  • Sizing for SQL Server
  • Validating the storage design
  • Storage setup and configuration
  • Windows setup and configuration
  • Server setup and configuration
  • Optimizing SQL Server I/O
  • Additional resources

Specifications

Supported SQL Server versions2008 and later
Connectivity options32Gb Fibre Channel and 100Gb iSCSI
Default write RAID typeRAID 10
RAID 10 write penalty2 I/Os

Frequently asked questions

Which SQL Server versions are covered by this document?

Microsoft SQL Server versions 2008 and later.

What connectivity options are mentioned for SC Series arrays?

32Gb Fibre Channel and 100Gb iSCSI.

What RAID type is used by default for writes to SC Series volumes?

RAID 10.

How long should performance statistics be captured when sizing storage?

At least 24 hours, including the system peak workload.

Download PDF (576 KB)

More Dell EMC Manuals


View all Dell EMC manuals →