Useful IO profiles for simulating various workloads


A buddy of mine [Liang Yang] recently shared the following table with me and I thought you might also find it useful with trying to simulate various workloads.  In particular when testing and evaluating Hyper-V.


A tool like IOMeter [from www.iometer.org] can be programmed with the mixes of reads/wrtes and sequential/random IO’s detailed below.






































































Workload Category


I/O Size


Percentage of READ vs. WRITE


Percentage of RANDOM vs. SEQUENTIAL


Web File Server


4KB


95% RD vs. 5% WR


75% RAND vs. 25%  SEQ


Web File Server


8KB


95% RD vs. 5% WR


75% RAND vs. 25%  SEQ


Web File Server


64KB


95% RD vs. 5% WR


75% RAND vs. 25%  SEQ


Decision Support System DB


1MB


READ


RANDOM


Media Streaming


64KB


98% RD vs. 2% WR


SEQUENTIAL


SQL Server Log


64KB


WRITE


SEQUENTIAL


OS Paging


64KB


90% RD vs. 10% WR


SEQUENTIAL


Web Server Log


8KB


WRITE


SEQUENTIAL


OLTP DB


8KB


70% RD vs. 30% WR


RANDOM


Exchange Server


4KB


67% RD vs. 33% WR


RANDOM


Workstation


8KB


80% RD vs. 20% WR


80% RAND vs. 20% SEQ


Video on Demand


512KB


READ


RANDOM


 Enjoy – Tony Voellm


 

Comments (3)

  1. ckumar says:

    Why are the Decision Support System DB workloads catagorized as random?

  2. Yury Tugarev says:

    Tony i would like to precise one thing. In this table Exchange is definitely Exchange 2003. For Ex2007 emulation you should use 50/50 formula (of coz its about normal work, after chache is filled). For 2010 i really cant say now )