{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 |
| |
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
About Chad Boyd
Chad is an Architect, Administrator, and Developer with technologies such as Sql Server (and all related technologies), Windows Server, and Windows Clustering. He currently works as an independent consultant and also spends a significant amount of time writing, talking, presenting and blogging about Sql Server in person and online at http://mssqltips.com. In the past, Chad has worked with companies and organizations such as Microsoft Corporation and The American Red Cross, and provided consulting/support services at companies such as Bank of America, HP, Citigroup, Qualcomm, Scottrade, TJX, SunTrust, and Zurich Financial Services. For over 3 years with Microsoft Corporation Chad was responsible for providing onsite and remote support, guidance, and advice with SQL Server products to some of Microsoft’s foremost enterprise customers running the largest, most complex SQL Server installations and configurations in the world. This included all SQL Server products and versions, including SQL Server 7.0, 2000, 2005, and recently 2008, the SQL Server database engine, Reporting Services, SSIS/DTS, Notification Services, and Analysis Services on both 32 and 64 bit systems. Chad's primary responsibilities today include troubleshooting critical server situations, performance tuning and monitoring, disaster recovery planning and execution, architectural guidance for new Sql Server related deployments, and delivering deep technical workshops/presentations/proof-of-concept sessions covering a variety of technologies and functionality. Chad regularly posts Sql Server related content, tools, and advice with the mssqltips team at http://blogs.mssqltips.com/blogs and http://mssqltips.com. Chad can be contacted via his blog or email at chad dot boyd dot tips at gmail dot com.
