Solved

Help Calculating IOPS.

Posted on 2011-02-21
6
1,268 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
6 Comments
 
LVL 118
ID: 34945157
0
 
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

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

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

If we need to check who deleted a Virtual Machine from our vCenter. Looking this task in logs can be painful and spend lot of time, so the best way to check this is in the vCenter DB. Just connect to vCenter DB(default DB should be VCDB and using…
Last article we focus in how to VMware: How to create and use VMs TAGs – Part 1 so before follow this article and perform the next tasks, you should read the first article how to create the TAG before using them in Veeam Backup Jobs.
Teach the user how to use create log bundles for vCenter Server or ESXi hosts Open vSphere Web Client: Generate vCenter Server and ESXi host log bundle:  Open vCenter Server Appliance Web Management interface and generate log bundle: Open vCenter Se…
This tutorial will walk an individual through the process of installing the necessary services and then configuring a Windows Server 2012 system as an iSCSI target. To install the necessary roles, go to Server Manager, and select Add Roles and Featu…

914 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

18 Experts available now in Live!

Get 1:1 Help Now