Number of Disks calculation
Posted on 2014-07-15
See the scenario to estimate disk requirement. Any idea how to estimate the disk required, ie 28 disks in case 1 & 250 disks in case 2 ?
A data warehouse that is used by a small number of users. Each query involves one hundred 64 KB random reads and little log activity. To support 25 users who all want one-second response time, the system would have to support 2500 I/Os per second (25 users × 100) or 160 MB/sec (2500 I/O per second × 64 KB).
A reasonable server configuration would have a dual-channel SCSI RAID controller on a PCI-X bus attached to a total of 28 disks using RAID5. Here, RAID5 is used because there is little write activity.
Heavyweight OLTP application where each transaction involves 200 – 8 KB random I/Os and a 400 KB of sequential log writes. To support 100 transactions per second, the data disks would have to support 20,000 random I/Os per second (100 × 200) or 160 MB/sec, and the log would have to sustain 40 MB/sec. The total bus would need to sustain 200 MB/sec (160 MB/sec + 40 MB/sec). A reasonable server configuration would have the server connected to a SAN via three fiber channel adapters on at least two PCI-X buses. The SAN would contain 250 disks on RAID1 for the data files and four disks using RAID1 for the log files.