[Webinar] Learn how to a build a cloud-first strategyRegister Now


Number of Disks calculation

Posted on 2014-07-15
Medium Priority
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
  • 2

Author Comment

ID: 40199372
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 17

Accepted Solution

Gerald Connolly earned 2000 total points
ID: 40199496
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

ID: 40210814

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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.
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
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…
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?

865 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