SR-IOV


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=24): [m(22),W(2)][100.0%][r=1036MiB/s,w=664MiB/s][r=133k,w=72.5k IOPS][eta 00m:00s]
sql-data1: (groupid=0, jobs=24): err= 0: pid=4324: Tue Feb 3 13:02:39 2026
  read: IOPS=131k, BW=1025MiB/s (1075MB/s)(300GiB/300017msec)
    slat (usec): min=3, max=8936, avg=19.87, stdev=21.36
    clat (nsec): min=500, max=4659.9M, avg=783188.84, stdev=4050557.13
     lat (usec): min=256, max=4659.9k, avg=803.06, stdev=4050.59
    clat percentiles (usec):
     |  1.00th=[  379],  5.00th=[  449], 10.00th=[  494], 20.00th=[  562],
     | 30.00th=[  611], 40.00th=[  660], 50.00th=[  709], 60.00th=[  766],
     | 70.00th=[  832], 80.00th=[  922], 90.00th=[ 1074], 95.00th=[ 1254],
     | 99.00th=[ 2024], 99.50th=[ 2900], 99.90th=[ 6259], 99.95th=[ 8455],
     | 99.99th=[14091]
   bw (  MiB/s): min=  596, max= 1369, per=100.00%, avg=1036.51, stdev= 3.29, samples=12929
   iops        : min=76380, max=175261, avg=132663.92, stdev=420.83, samples=12929
  write: IOPS=71.4k, BW=656MiB/s (688MB/s)(192GiB/300017msec); 0 zone resets
    slat (usec): min=4, max=54528, avg=58.29, stdev=213.67
    clat (nsec): min=300, max=4659.5M, avg=853793.37, stdev=4359019.69
     lat (usec): min=278, max=4659.5k, avg=912.09, stdev=4371.63
    clat percentiles (usec):
     |  1.00th=[  408],  5.00th=[  486], 10.00th=[  529], 20.00th=[  594],
     | 30.00th=[  652], 40.00th=[  701], 50.00th=[  750], 60.00th=[  807],
     | 70.00th=[  881], 80.00th=[  979], 90.00th=[ 1156], 95.00th=[ 1418],
     | 99.00th=[ 3097], 99.50th=[ 3785], 99.90th=[ 6456], 99.95th=[ 8586],
     | 99.99th=[14353]
   bw (  KiB/s): min=436950, max=902205, per=100.00%, avg=678838.43, stdev=1946.22, samples=14115
   iops        : min=44964, max=94337, avg=72295.55, stdev=199.68, samples=14115
  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=9.18%, 750=45.80%, 1000=29.40%
  lat (msec)   : 2=14.06%, 4=1.17%, 10=0.29%, 20=0.03%, 50=0.01%
  lat (msec)   : 100=0.01%, 2000=0.01%, >=2000=0.01%
  cpu          : usr=3.25%, sys=17.24%, ctx=0, majf=0, minf=0
  IO depths    : 1=0.1%, 2=1.3%, 4=28.3%, 8=70.4%, 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=39359870,21434743,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=1025MiB/s (1075MB/s), 1025MiB/s-1025MiB/s (1075MB/s-1075MB/s), io=300GiB (322GB), run=300017-300017msec
  WRITE: bw=656MiB/s (688MB/s), 656MiB/s-656MiB/s (688MB/s-688MB/s), io=192GiB (206GB), run=300017-300017msec