Number of Disks calculation

Posted on 2014-07-15
Last Modified: 2014-07-21
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 ?

Scenario 1
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.

Scenario 2
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.
Question by:AXISHK

    Author Comment

    No, this is not an exam nor homework question. I'm evaluating the disk requirement for my server and I have come across these 2 case in a internet. Just wonder how it deliver the number of disks in these two cases..

    here are some some window counters measured on my SQL Server
    Max IOPS at peak hour
    Physical Disk 0 \ Disk Reads/s                 117
    Physical Disk 1 \ Disk Reads/s               2222
    Physical Disk 0  \ Disk Write/s                102
    Physical Disk 1   \ Disk Write/s               200
    Physical Disk 0 \Disk Read Bytes/s               2,746,925        (~ 2.7  MB)
    Physical Disk 1 \Disk Read Bytes/s               170,586,869    (~ 171 MB)
    Physical Disk 0 \Disk Write Bytes/s             1,659,712        (~ 1 .7    MB)
    Physical Disk 1 \Disk Write Bytes/s             10,324,181      (~ 10   MB)

    My concern is the throughput. How to evaluate the disks in order to cope with the throughput in peak hours ? How to estimate the RAID controller or bus to cope this this load ?

    LVL 16

    Accepted Solution

    How much storage is involved in these two scenario's?

    Scenario - 1 looks a bit overspec'd, with modern Enterprise disks doing 200 IOPS or 200MB/s, you could probably do it with 2 x 8 Disks RAID-5's

    Scenario - 2 looks more like a candidate for a SSD setup.

    Author Closing Comment


    Featured Post

    PRTG Network Monitor: Intuitive Network Monitoring

    Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

    Join & Write a Comment

    Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
    More or less everybody in the IT market understands the basics of Networking, however when we start talking about Storage Networks, things get a bit dizzier, and this is where I would like to help.
    This video Micro Tutorial explains how to clone a hard drive using a commercial software product for Windows systems called Casper from Future Systems Solutions (FSS). Cloning makes an exact, complete copy of one hard disk drive (HDD) onto another d…
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now