First you should choose the highest-performing disk type you can afford for your environment. While there have been improvements in disk technologies such as iSCSI and Fibre Channel over the past several years, SCSI drives still offer the best performance. For optimal disk performance, consider solid-state RAM drives, but be prepared to pay for their superior I/O performance.
For small databases that will largely be stored in RAM, you may find that performance is insensitive to the disk type.
Also try to purchase the fastest disks you can, preferably Fibre Channel, which offers the greatest data transfer speed.
Ensure that all disks are rated for the same speed and they are all the same model. Different speeds or models can slow down your entire disk array through a phenomenon known as hardware impedance mismatch, where the overall speed of the disk solution will be lower than the lowest member. Currently the fastest disk speed is 15 KB.
Check out this Fast Guide to Storage Technologies for a better understanding of various disk types and storage technologies.
When sizing your disks, they should be large enough to hold the expected size of the database files over the lifetime of your database. Consult with your developers and business customers to determine long-term growth needs.
Your disks should also be able to hold several backups and transaction log dumps. Keep in mind that most indexing processes result in large transaction logs and log dumps.
The larger your disk size is, the more insurance you buy yourself during restore operations; having a backup on disk enables faster restore times than restoring from tape or tape drive units. You must also account for some performance degradation in the event you run out of space on a drive and have to extend your database files to span multiple physical disks.
Spec your SQL Server hardware needs
Invest in good application design
Understand your workload
Know your memory support limitations
Choose a reliable hardware brand
Take advantage of 64-bit
Take advantage of storage area networks
Properly configure your RAID arrays
Use separate disk controllers
Choose and optimize your disks wisely
Optimize CPU activity and speed
|ABOUT THE AUTHOR:
| Hilary Cotter
Hilary Cotter has been involved in IT for more than 20 years as a Web and database consultant. Microsoft first awarded Cotter the Microsoft SQL Server MVP award in 2001. Cotter received his bachelor of applied science degree in mechanical engineering from the University of Toronto and studied economics at the University of Calgary and computer science at UC Berkeley. He is the author of a book on SQL Server transactional replication and is currently working on books on merge replication and Microsoft search technologies.
Copyright 2006 TechTarget