Identify and resolve SQL Server problems BEFORE they happen with SQL diagnostic manager

SQL Server Disk Configuration Checklist

By: Chad Boyd | Read Comments | Print Chad is an Architect, Administrator and Developer with technologies such as SQL Server, .NET, and Windows Server. Related Tips: More

{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

 

Related Tips: More | Become a paid author

Last Update: 6/29/2008

Share:

Share

Tweet

Free SQL Server Learning Building Blocks for Your SQL Server Career Database development best practices What Are You Waiting For?

Comments and Feedback:

Post a Comment or Question

Keep it clean and stay on the subject or we may delete your comment.
Your email address is not published. Required fields are marked with an asterisk (*)

*Name

*Email

Notify for updates

Comments *** NOTE *** - If you want to include code from SQL Server Management Studio (SSMS) in your post, please copy the code from SSMS and paste the code into a text editor like NotePad before copying the code below to remove the SSMS formatting.
*Enter Code

 

Sponsor Information

"SQL doctor is the best SQL product on the market, by far. All of Idera's tools are great, but this is the icing on the cake!" Web-based SQL Server monitoring whenever, wherever. Make the most out of SQL Server - Guaranteed Results - Innovative SQL Server DBAs Solving SQL Server problems for millions of DBAs and Devs since 2006. Join now. Learn SQL Server 2008, Performance Tuning, Development, Administration, Replication and more - free webcasts