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_reporte2.dat --ioengine=windowsaio --direct=1 odepth=8 --size=40G --time_based --runtime=3=6 --iodepth=8 --size=40G --time_based --runtime=3=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


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=608MiB/s,w=393MiB/s][r=77.8k,w=42.5k IOPS][eta 00m:00s]
sql-data1: (groupid=0, jobs=24): err= 0: pid=2580: Tue Feb 3 16:03:08 2026
  read: IOPS=98.6k, BW=770MiB/s (808MB/s)(226GiB/300003msec)
    slat (usec): min=3, max=3785, avg=12.64, stdev= 8.26
    clat (usec): min=16, max=5003.1k, avg=1059.89, stdev=3239.28
     lat (usec): min=268, max=5003.1k, avg=1072.52, stdev=3239.30
    clat percentiles (usec):
     |  1.00th=[  553],  5.00th=[  676], 10.00th=[  742], 20.00th=[  824],
     | 30.00th=[  889], 40.00th=[  955], 50.00th=[ 1012], 60.00th=[ 1090],
     | 70.00th=[ 1156], 80.00th=[ 1254], 90.00th=[ 1418], 95.00th=[ 1582],
     | 99.00th=[ 1926], 99.50th=[ 2089], 99.90th=[ 2671], 99.95th=[ 3687],
     | 99.99th=[ 6718]
   bw (  KiB/s): min=185096, max=1157400, per=100.00%, avg=798886.40, stdev=2398.34, samples=12244
   iops        : min=23128, max=144664, avg=99853.15, stdev=299.79, samples=12244
  write: IOPS=53.9k, BW=501MiB/s (525MB/s)(147GiB/300003msec); 0 zone resets
    slat (usec): min=4, max=26028, avg=56.75, stdev=255.39
    clat (nsec): min=200, max=5005.1M, avg=1144686.34, stdev=5131167.03
     lat (usec): min=274, max=5005.1k, avg=1201.44, stdev=5147.21
    clat percentiles (usec):
     |  1.00th=[  570],  5.00th=[  701], 10.00th=[  775], 20.00th=[  865],
     | 30.00th=[  930], 40.00th=[  996], 50.00th=[ 1057], 60.00th=[ 1139],
     | 70.00th=[ 1221], 80.00th=[ 1319], 90.00th=[ 1516], 95.00th=[ 1713],
     | 99.00th=[ 3294], 99.50th=[ 4146], 99.90th=[ 5276], 99.95th=[ 5735],
     | 99.99th=[ 7111]
   bw (  KiB/s): min=145615, max=962050, per=100.00%, avg=519413.73, stdev=3558.22, samples=13363
   iops        : min=14660, max=87987, avg=54616.25, stdev=161.76, samples=13363
  lat (nsec)   : 250=0.01%, 500=0.01%, 750=0.01%, 1000=0.01%
  lat (usec)   : 2=0.01%, 4=0.01%, 10=0.01%, 20=0.02%, 50=0.04%
  lat (usec)   : 100=0.01%, 250=0.01%, 500=0.42%, 750=9.57%, 1000=34.94%
  lat (msec)   : 2=53.58%, 4=1.17%, 10=0.23%, 20=0.01%, 50=0.01%
  lat (msec)   : 100=0.01%, 1000=0.01%, >=2000=0.01%
  cpu          : usr=1.69%, sys=8.14%, ctx=0, majf=0, minf=0
  IO depths    : 1=0.1%, 2=1.7%, 4=39.8%, 8=58.5%, 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.9%, 8=0.1%, 16=0.0%, 32=0.0%, 64=0.0%, >=64=0.0%
     issued rwts: total=29576930,16175205,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=770MiB/s (808MB/s), 770MiB/s-770MiB/s (808MB/s-808MB/s), io=226GiB (242GB), run=300003-300003msec
  WRITE: bw=501MiB/s (525MB/s), 501MiB/s-501MiB/s (525MB/s-525MB/s), io=147GiB (158GB), run=300003-300003msec