SQL Server Disk Configuration Checklist


By:   |   Updated: 2008-06-29   |   Comments   |   Related: More > Clustering

{SERVERNAME} - Disk Configuration

Basic/Internal Disk Information
Attribute Value
System Name  
Disk # and Info.  
Partitions  
Number of Internal Drives  
Size of Each Physical Drive  
Speed of Physical Drives  
Type of Disks (IDE, SCSI, Mixed)  
SQL Server Disk Information
Attribute Value
Are Files/Filegroups Used? (Yes/No)  
Detail File/Filegroup Config per Database  
Number of tempdb data files expected, size, and storage locations  
External Array Information

NOTE: Cut and paste this section if more than one external array exists.

Attribute Value
Type of External Array (SAN/DAS)  
Manufacturer  
Model Number  
Driver Version  
Type of Disk Subsystem (SCSI/Fibre)  
Total Number of Physical Drives  
Size of Each Physical Drive  
Speed of Physical Drives  
Total Number of LUNs/Partitions/Volumes Used  
Do Other Systems and/or Applications Share the Array? (Yes/No), (Systems Shared)  
Disk Cache Size  
Disk Cache Setting (i.e., read/write ratio)  
Important Notes  
 System Name:

Logical Disk is the drive letter that the operating system uses.

Partition/LUN/Volume Label or Number is the number or label of a particular LUN on the disk subsystem. A LUN may contain more than one logical disk.

Number of Physical Drives Used for LUN is the number of drives in the array used to create the LUN.

RAID Level is the type of RAID used on the LUN.

Total Space is the total amount of drive space available for use by the logical disk.

Current Free Space is the total amount of drive space used by all files on the logical disk.

Purpose is for detailing the specific use of a particular logical drive.

 

NOTE: Remember to get a worksheet from the hardware vendor of the configuration below this logical level.

 
Logical Disk Volume Label or # (if SAN/DAS) Spindle count for LUN RAID Level Total Space Current Free Space Offset and Allocation Unit Size MBR/GPT disk Purpose/Description
                 
                 
                 
                 
                 
 

Last Updated: 2008-06-29


get scripts

next tip button



About the author
MSSQLTips author Chad Boyd Chad Boyd is an Architect, Administrator and Developer with technologies such as SQL Server, .NET, and Windows Server.

View all my tips
Related Resources





Comments For This Article





download


Recommended Reading

Step-by-step Installation of SQL Server 2016 on a Windows Server 2016 Failover Cluster - Part 1

Getting started with SQL Server clustering

Configure Network Binding Order for a Windows Server 2016 Failover Cluster

Install SQL Server 2017 on Windows Server 2016 Failover Cluster - Part 2

Force Start a Windows Server Failover Cluster without a Quorum to bring a SQL Server Failover Clustered Instance Online





get free sql tips
agree to terms


Learn more about SQL Server tools