Solved

Help Calculating IOPS.

Posted on 2011-02-21
6
1,301 Views
Last Modified: 2013-11-14
I need a little help when trying to calulate available IOPS in a raid array.  I have been looking at wmarrow's calculator (http://www.wmarow.com/strcalc/) and I am a little lost when it gets to read cache hit ratio and write cache hit ratio.  With four 7200rpm sata 3.0 drives in a raid 10 I get between 227 and 23000 IOPS (at 70%/30% read/write ratio) depending on how I manipulate these two fields.  How should I properly calculate these two fields?

I realize that in production I would want fast 15K SAS drives, and as many as possible, but this is for a lab environment and I do not have the budget for SAS drives.  Just need to get an estimate of how many iops I will have to deal with so I don't overtax the box.  It will be running vSphere Hypervisor 4.1.
0
Comment
Question by:arstacey
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 6

Assisted Solution

by:Gugro
Gugro earned 250 total points
ID: 34945163
leave the read and write cache ratio at 0.
Disks have normally only a small cache ( typical 8-32 MB ), the chance that you will hit data in this cache ( and the data was NOT found in the OS or DB cache ) is almost zero.
0
 
LVL 3

Accepted Solution

by:
driskollt earned 250 total points
ID: 35132834
Don't factor in caching for random loads.  Eventually everything has to hit the disk so you'll take the hit somewhere.  Also, when in doubt, assume random.  Most workloads are random.  Sequentual workloads are usually things like backups, logs, data warehousing.

To calculate total sustained IOPS that a set of disks can handle for SATA w/ RAID10 and 33% writes...
A single 7200 SATA can handle about 80 sustained random IOPS.
IOPS=(80IOPS * 4disks)/(.67 + (2 * .33))
240 IOPS.
 

0
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
LVL 3

Expert Comment

by:driskollt
ID: 35132860
Oops, sorry you wanted 70% read.

Anyway...

Total IOPS = (DriveIOPS * #Drives) / (ReadRatio + (RAIDWritePenalty * WriteRatio))
So.
246IOPS = (80 * 4) / (.7 + (2 * .3))

0
 

Author Comment

by:arstacey
ID: 35133522
Ok, so with that in mind, a RAID 10 array of 8 Sata 7200rpm 1tb drives gives me roughly 4TB of storage and 426 IOPS.  If a windows 7 desktop requires roughly 20 IOPS virtualized, then I should be able to run a Server 2008 Server Core running DC, File Shareing, DNS, and DHCP roles as well as at least 16 Win 7 desktops all virtualized under VMWare ESXi?  The server will probably only have 1 quad core xeon processor, an e5620 2.4 Ghz with Hyperthreading, and at least 24GB Ram.
0
 
LVL 3

Expert Comment

by:driskollt
ID: 35138023
You're probably fine.  Especially if it's just a lab.  If your lab doesn't have SLAs for response time/etc, then I wouldn't worry about it too much.  

Since it's a lab, your write/read ratio is probably going to be more like .85/.15 which will give you a little better performance.

The fact you're using RAID10 with SATA for a random workload is a good idea as well.

0

Featured Post

Plug and play, no additional software required!

The ATEN UE3310 USB3.1 Gen1 Extender Cable allows users to extend the distance between the computer and USB devices up to 10 m (33 ft). The UE3310 is a high-quality, cost-effective solution for professional environments such as hospitals, factories and business facilities.

Question has a verified solution.

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

The question appears often enough, how do I transfer my data from my old server to the new server while preserving file shares, share permissions, and NTFS permisions.  Here are my tips for handling such a transfer.
Giving access to ESXi shell console is always an issue for IT departments to other Teams, or Projects. We need to find a way so that teams can use ESXTOP for their POCs, or tests without giving them the access to ESXi host shell console with a root …
Teach the user how to configure vSphere Replication and how to protect and recover VMs Open vSphere Web Client: Verify vsphere Replication is enabled: Enable vSphere Replication for a virtual machine: Verify replicated VM is created: Recover replica…
This Micro Tutorial walks you through using a remote console to access a server and install ESXi 5.1. This example is showing remote access and installation using a Dell server. The hypervisor is the very first component of your virtual infrastructu…
Suggested Courses

623 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