RAID Level 0 provides the best I/O performance among all other RAID levels. A file has sequential segments striped across each drive in the array. Data is written in a round-robin fashion to ensure that data is evenly balanced across all drives in the array. However, if a media failure occurs, no fault tolerance is provided, and all data stored in the array is lost. RAID 0 should not be used for a production database where data loss or loss of system availability is not acceptable. RAID 0 is occasionally used for
tempdb to provide the best possible read and (especially) write performance. RAID 0 is helpful for random read requirements, such as those that occur on
tempdb and in data segments.
Although the data stored in