PARAVIRTUALIZED


fio --name=sql-data1 --filename=datafile1.dat --ioengine=windowsaio --direct=1 --rw=randrw --rwmixread=70 --bs=8K --numjobs=6 --iodepth=8 --size=40G --time_based --runtime=300 --group_reporting --thread ^--name=sql-data2 --filename=datafile2.dat --ioengine=windowsaio --direct=1 --rw=randrw --rwmixread=70 --bs=8K --numjobs=6 --iodepth=8 --size=40G --time_based --runtime=300 --group_reporting --thread ^--name=sql-data3 --filename=datafile3.dat --ioengine=windowsaio --direct=1 --rw=randrw --rwmixread=70 --bs=8K --numjobs=4 --iodepth=8 --size=30G --time_based --runtime=300 --group_reporting --thread ^--name=tempdb1 --filename=tempdb1.dat --ioengine=windowsaio --direct=1 --rw=randrw --rwmixread=50 --bs=8K --numjobs=4 --iodepth=8 --size=20G --time_based --runtime=300 --group_reporting --thread ^--name=tempdb2 --filename=tempdb2.dat --ioengine=windowsaio --direct=1 --rw=randrw --rwmixread=50 --bs=8K --numjobs=2 --iodepth=4 --size=10G --time_based --runtime=300 --group_reporting --thread ^--name=sql-log --filename=sql-log.ldf --ioengine=windowsaio --direct=1 --rw=write --bs=64K --numjobs=2 --iodepth=4 --size=20G --time_based --runtime=300 --group_reporting --thread
sql-data1: (g=0): rw=randrw, bs=(R) 8192B-8192B, (W) 8192B-8192B, (T) 8192B-8192B, ioengine=windowsaio, iodepth=8
...
sql-data2: (g=0): rw=randrw, bs=(R) 8192B-8192B, (W) 8192B-8192B, (T) 8192B-8192B, ioengine=windowsaio, iodepth=8
...
sql-data3: (g=0): rw=randrw, bs=(R) 8192B-8192B, (W) 8192B-8192B, (T) 8192B-8192B, ioengine=windowsaio, iodepth=8
...
tempdb1: (g=0): rw=randrw, bs=(R) 8192B-8192B, (W) 8192B-8192B, (T) 8192B-8192B, ioengine=windowsaio, iodepth=8
...
tempdb2: (g=0): rw=randrw, bs=(R) 8192B-8192B, (W) 8192B-8192B, (T) 8192B-8192B, ioengine=windowsaio, iodepth=4
...
sql-log: (g=0): rw=write, bs=(R) 64.0KiB-64.0KiB, (W) 64.0KiB-64.0KiB, (T) 64.0KiB-64.0KiB, ioengine=windowsaio, iodepth=4
...
fio-3.41
Starting 24 threads
sql-data1: Laying out IO file (1 file / 40960MiB)
sql-data2: Laying out IO file (1 file / 40960MiB)
sql-data3: Laying out IO file (1 file / 30720MiB)
tempdb1: Laying out IO file (1 file / 20480MiB)
tempdb2: Laying out IO file (1 file / 10240MiB)
sql-log: Laying out IO file (1 file / 20480MiB)
sql-log: Laying out IO file (1 file / 20480MiB)
Jobs: 24 (f=0): [f(24)][100.0%][r=895MiB/s,w=568MiB/s][r=115k,w=62.1k IOPS][eta 00m:00s]
sql-data1: (groupid=0, jobs=24): err= 0: pid=8628: Tue Feb 3 16:13:14 2026
  read: IOPS=135k, BW=1055MiB/s (1106MB/s)(309GiB/300027msec)
    slat (usec): min=4, max=7353, avg=19.18, stdev=24.93
    clat (nsec): min=500, max=5654.9M, avg=760253.29, stdev=4793652.66
     lat (usec): min=256, max=5655.0k, avg=779.44, stdev=4793.70
    clat percentiles (usec):
     |  1.00th=[  388],  5.00th=[  457], 10.00th=[  502], 20.00th=[  562],
     | 30.00th=[  611], 40.00th=[  660], 50.00th=[  709], 60.00th=[  766],
     | 70.00th=[  832], 80.00th=[  922], 90.00th=[ 1057], 95.00th=[ 1205],
     | 99.00th=[ 1532], 99.50th=[ 1713], 99.90th=[ 2376], 99.95th=[ 2900],
     | 99.99th=[ 4490]
   bw (  MiB/s): min=  683, max= 1400, per=100.00%, avg=1067.30, stdev= 3.03, samples=12944
   iops        : min=87489, max=179289, avg=136605.38, stdev=388.22, samples=12944
  write: IOPS=73.5k, BW=675MiB/s (708MB/s)(198GiB/300027msec); 0 zone resets
    slat (usec): min=5, max=12906, avg=56.20, stdev=194.31
    clat (nsec): min=300, max=5657.8M, avg=830312.99, stdev=6111648.02
     lat (usec): min=294, max=5657.8k, avg=886.51, stdev=6119.56
    clat percentiles (usec):
     |  1.00th=[  412],  5.00th=[  490], 10.00th=[  537], 20.00th=[  603],
     | 30.00th=[  652], 40.00th=[  701], 50.00th=[  750], 60.00th=[  807],
     | 70.00th=[  881], 80.00th=[  971], 90.00th=[ 1139], 95.00th=[ 1319],
     | 99.00th=[ 2507], 99.50th=[ 3195], 99.90th=[ 4146], 99.95th=[ 4490],
     | 99.99th=[ 5538]
   bw (  KiB/s): min=470677, max=1113101, per=100.00%, avg=699453.06, stdev=3614.09, samples=14123
   iops        : min=46770, max=103356, avg=74430.37, stdev=191.46, samples=14123
  lat (nsec)   : 500=0.01%, 750=0.01%, 1000=0.01%
  lat (usec)   : 2=0.01%, 4=0.01%, 10=0.01%, 20=0.01%, 50=0.04%
  lat (usec)   : 100=0.01%, 250=0.01%, 500=8.31%, 750=46.25%, 1000=30.38%
  lat (msec)   : 2=14.30%, 4=0.61%, 10=0.05%, 20=0.01%, 50=0.01%
  lat (msec)   : >=2000=0.01%
  cpu          : usr=3.40%, sys=17.93%, ctx=0, majf=0, minf=0
  IO depths    : 1=0.1%, 2=1.4%, 4=28.7%, 8=69.9%, 16=0.0%, 32=0.0%, >=64=0.0%
     submit    : 0=0.0%, 4=100.0%, 8=0.0%, 16=0.0%, 32=0.0%, 64=0.0%, >=64=0.0%
     complete  : 0=0.0%, 4=99.8%, 8=0.2%, 16=0.0%, 32=0.0%, 64=0.0%, >=64=0.0%
     issued rwts: total=40507413,22059442,0,0 short=0,0,0,0 dropped=0,0,0,0
     latency   : target=0, window=0, percentile=100.00%, depth=4

Run status group 0 (all jobs):
   READ: bw=1055MiB/s (1106MB/s), 1055MiB/s-1055MiB/s (1106MB/s-1106MB/s), io=309GiB (332GB), run=300027-300027msec
  WRITE: bw=675MiB/s (708MB/s), 675MiB/s-675MiB/s (708MB/s-708MB/s), io=198GiB (212GB), run=300027-300027msec