Learn more about SQL Server tools

mssqltips logo
 

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Scripts          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

 

SQL Server Disk Configuration Checklist


By:   |   Last Updated: 2008-06-29   |   Comments   |   Related Tips: 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




Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Email me updates 


Signup for our newsletter
 I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.



    



Learn more about SQL Server tools