Dell Compellent Storage Center and Microsoft SQL Server Best Practices Guide

A Dell Best Practices Guide for Dell Compellent Storage Center and Microsoft SQL Server introduces the best practices for Dell Compellent Storage Center and Microsoft SQL Server.


Dell Compellent Storage Center and Microsoft SQL Server Best Practices Guide - cover page
Brand
DELL
Category
Storage
Document type
Other
Language
English
Pages
22
File format
PDF
File size
297 KB
Published
25 November, 2023
Updated
25 November, 2023
MD5 checksum
018433BA43BEB05DC1363B00BF5A3F59

About this manual

This Dell best practices guide describes running Microsoft SQL Server versions 2005 and later with a Dell Compellent Storage Center. It discusses SQL Server on Dell Compellent storage, sizing, storage design validation, storage setup, Windows and server configuration, and ways to reduce SQL Server I/O.

The document is intended for database administrators, system administrators, storage administrators, and architects who analyze, design, and maintain database and storage systems. It also includes customer support contact details and additional resources.

What's inside

  • Introduction
  • SQL Server on Dell Compellent storage
  • Sizing for SQL Server
  • Validating the storage design
  • Storage setup and configuration
  • Windows Setup and configuration
  • Server setup and configuration
  • Reducing SQL Server I/O
  • Additional resources

Specifications

Supported SQL Server versions2005 and later
Connectivity options16Gbps fibre channel and 10Gbps iSCSI
Storage media supportSolid state disks (SSD)

Frequently asked questions

What versions of Microsoft SQL Server does this guide cover?

It covers Microsoft SQL Server versions 2005 and later.

What connection types does the document mention between the database server and the Storage Center?

It mentions 16Gbps fibre channel and 10Gbps iSCSI.

How long should performance statistics be captured when sizing storage?

For at least 24 hours, including the system peak workload.

Who is the intended audience for the guide?

Database administrators, system administrators, storage administrators, and architects who analyze, design, and maintain database and storage systems.

Download PDF (297 KB)

More DELL Manuals


View all DELL manuals →