database_name | file_id | type | last_number_reads_per_min | avg_number_reads_per_min | max_number_reads_per_min | sdev_number_reads_per_min | last_number_writes_per_min | avg_number_writes_per_min | max_number_writes_per_min | sdev_number_writes_per_min | last_bytes_read_per_min | avg_bytes_read_per_min | max_bytes_read_per_min | sdev_bytes_read_per_min | last_bytes_written_per_min | avg_bytes_written_per_min | max_bytes_written_per_min | sdev_bytes_written_per_min | last_iostallms_per_min | avg_iostallms_per_min | max_iostallms_per_min | sdev_iostallms_per_min | pct_iostallms_per_min | logical_drive | physical_file |
controlctr | 1 | data | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 2502.00 | 2555.25 | 5643.00 | 249.53 | 156.00 | 120.25 | 1405.00 | 105.26 | 0.00 | 0.04 | 1.00 | 0.20 | 0.00 | S | X:\SQLData\controlctr_data.mdf |
controlctr | 2 | log | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 6.00 | 5.05 | 42.00 | 4.05 | 63.00 | 69.64 | 252.00 | 19.29 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | T | Y:\SQLLog\controlctr_log.ldf |
master | 1 | data | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 2645.00 | 2155.99 | 4920.00 | 310.05 | 216.00 | 201.09 | 1453.00 | 23.26 | 1.00 | 0.52 | 15.00 | 1.55 | 0.00 | S | X:\SQLData\master.mdf |
master | 2 | log | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.02 | 5.00 | 0.35 | 14.00 | 16.12 | 34.00 | 5.15 | 241.00 | 335.29 | 29155.00 | 1565.02 | 0.00 | 0.16 | 10.00 | 1.19 | 0.00 | S | X:\SQLData\mastlog.ldf |
model | 1 | data | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1006.00 | 905.52 | 2133.00 | 125.59 | 102.00 | 101.33 | 204.00 | 9.22 | 0.00 | 0.14 | 11.00 | 0.29 | 0.00 | S | X:\SQLData\model.mdf |
model | 2 | log | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 14.00 | 14.63 | 22.00 | 2.12 | 91.00 | 92.03 | 122.00 | 5.59 | 0.00 | 0.00 | 3.00 | 0.25 | 0.00 | S | X:\SQLData\modellog.ldf |
msdb | 1 | data | 1.00 | 0.23 | 2.00 | 0.42 | 1.00 | 0.95 | 1.00 | 0.15 | 192635.00 | 120021.55 | 401519.00 | 53119.40 | 19521.00 | 15351.25 | 64595.00 | 2944.26 | 45.00 | 22.64 | 129.00 | 22.20 | 0.15 | S | X:\SQLData\MSDBData.mdf |
msdb | 2 | log | 0.00 | 0.00 | 0.00 | 0.00 | 15.00 | 12.42 | 25.00 | 1.29 | 3291.00 | 1526.12 | 4693.00 | 1024.03 | 56566.00 | 20154.99 | 120924.00 | 5251.14 | 21.00 | 134.29 | 2535.00 | 369.54 | 0.50 | S | X:\SQLData\MSDBLog.ldf |
reportdb | 1 | data | 1.00 | 0.09 | 2.00 | 0.31 | 0.00 | 0.02 | 2.00 | 0.15 | 52520.00 | 15125.21 | 59360.00 | 2995.45 | 3626.00 | 4150.22 | 25352.00 | 3626.23 | 14.00 | 5.04 | 42.00 | 6.30 | 0.03 | S | X:\SQLData\reportdb.mdf |
reportdb | 2 | log | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.01 | 2.00 | 0.14 | 656.00 | 1166.51 | 20269.00 | 2562.15 | 1595.00 | 1999.22 | 22235.00 | 2614.59 | 0.00 | 2.03 | 35.00 | 4.55 | 0.01 | T | Y:\SQLLog\reportdb_log.ldf |
tinyDB | 1 | data | 3.00 | 1.25 | 3.00 | 1.12 | 0.00 | 0.00 | 0.00 | 0.00 | 224525.00 | 102925.21 | 224525.00 | 54641.69 | 4510.00 | 4435.50 | 5159.00 | 535.52 | 20.00 | 44.50 | 111.00 | 31.26 | 0.01 | S | X:\SQLData\tinyDB_data.mdf |
tinyDB | 2 | log | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1462.00 | 1313.31 | 1523.00 | 355.20 | 2055.00 | 1906.50 | 2321.00 | 345.29 | 1.00 | 1.63 | 5.00 | 1.36 | 0.00 | T | Y:\SQLLog\tinyDB_log.ldf |
metricsDB | 1 | data | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 5296.00 | 2505.94 | 6229.00 | 1205.22 | 2554.00 | 1305.92 | 3055.00 | 634.04 | 2.00 | 0.52 | 2.00 | 0.62 | 0.00 | S | X:\SQLData\metricsDB_data.mdf |
metricsDB | 2 | log | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.64 | 30.00 | 4.25 | 554.00 | 533.32 | 15654.00 | 2205.25 | 1365.00 | 1324.52 | 16262.00 | 2202.35 | 0.00 | 1.52 | 53.00 | 5.55 | 0.00 | T | Y:\SQLLog\metricsDB_log.ldf |
maindb | 1 | data | 50.00 | 13.52 | 52.00 | 15.22 | 102.00 | 20.29 | 251.00 | 41.34 | 5159145.00 | 2563263.29 | 10695264.00 | 1220210.05 | 1012042.00 | 224055.13 | 3354200.00 | 565912.20 | 3203.00 | 1029.49 | 10920.00 | 1412.95 | 5.35 | S | X:\SQLData\maindb.mdf |
maindb | 2 | log | 0.00 | 0.52 | 13.00 | 1.35 | 149.00 | 220.15 | 1350.00 | 334.90 | 224210.00 | 226211.95 | 6905650.00 | 1122155.50 | 221512.00 | 250639.20 | 6225225.00 | 1159661.25 | 301.00 | 1252.61 | 143316.00 | 14416.23 | 9.21 | T | Y:\SQLLog\maindb_2.ldf |
maindb | 3 | data | 33.00 | 5.60 | 43.00 | 5.25 | 4.00 | 4.25 | 42.00 | 4.43 | 945452.00 | 662560.95 | 2510622.00 | 303306.11 | 43051.00 | 126954.99 | 1533465.00 | 149252.34 | 262.00 | 206.90 | 932.00 | 226.21 | 1.02 | S | X:\SQLData\maindb_1.ndf |
tempdb | 1 | data | 39.00 | 203.65 | 4525.00 | 425.44 | 35.00 | 224.20 | 4232.00 | 453.44 | 2132595.00 | 12306256.62 | 229529226.00 | 29534233.55 | 2292522.00 | 14342059.66 | 313535405.00 | 30540112.36 | 625.00 | 3912.35 | 52225.00 | 2533.52 | 20.43 | S | X:\SQLData\tempdb.mdf |
tempdb | 2 | log | 0.00 | 0.00 | 0.00 | 0.00 | 153.00 | 69.91 | 325.00 | 69.24 | 0.00 | 6.05 | 403.00 | 39.94 | 9401442.00 | 4006232.40 | 19525469.00 | 4325313.66 | 452.00 | 253.22 | 1521.00 | 315.55 | 1.43 | S | Y:\SQLLog\templog.ldf |
tempdb | 3 | data | 39.00 | 203.55 | 4522.00 | 425.31 | 35.00 | 223.59 | 4229.00 | 453.25 | 2122611.00 | 12301626.34 | 229533422.00 | 29526052.42 | 2223950.00 | 14340110.46 | 313569029.00 | 30531535.22 | 622.00 | 3209.55 | 54506.00 | 2255.54 | 19.29 | S | X:\SQLData\tempdev2.ndf |
tempdb | 4 | data | 39.00 | 203.52 | 4521.00 | 425.25 | 35.00 | 223.22 | 4225.00 | 453.23 | 2126992.00 | 12304560.62 | 229523324.00 | 29525295.20 | 2223253.00 | 14341226.53 | 313511425.00 | 30531445.62 | 592.00 | 3294.59 | 55242.00 | 2411.50 | 20.33 | S | X:\SQLData\tempdev3.ndf |
tempdb | 5 | data | 39.00 | 203.61 | 4522.00 | 425.35 | 35.00 | 223.25 | 4229.00 | 453.35 | 2132126.00 | 12305569.22 | 229595259.00 | 29533429.11 | 2296422.00 | 14343246.59 | 313635211.00 | 30540036.52 | 600.00 | 3216.12 | 55651.00 | 2233.09 | 19.92 | S | X:\SQLData\tempdev4.ndf |
virtualDBA | 1 | data | 1.00 | 0.14 | 2.00 | 0.36 | 1.00 | 0.30 | 2.00 | 0.42 | 504506.00 | 293223.51 | 232556.00 | 150923.92 | 12262.00 | 20525.29 | 323624.00 | 44626.22 | 50.00 | 32.90 | 220.00 | 25.02 | 0.15 | S | X:\SQLData\virtualDBA_system.mdf |
virtualDBA | 2 | log | 0.00 | 0.00 | 0.00 | 0.00 | 2.00 | 1.22 | 2.00 | 0.90 | 253.00 | 105.03 | 1059.00 | 165.32 | 36696.00 | 41156.69 | 341236.00 | 22210.13 | 4.00 | 13.15 | 562.00 | 44.05 | 0.05 | T | Y:\SQLLog\virtualDBA_log.ldf |
virtualDBA | 3 | data | 0.00 | 0.21 | 2.00 | 0.25 | 0.00 | 0.00 | 0.00 | 0.00 | 5463.00 | 145251.20 | 605152.00 | 150513.50 | 39.00 | 140.25 | 3640.00 | 402.53 | 1.00 | 23.04 | 465.00 | 40.39 | 0.12 | S | X:\SQLData\virtualDBA_audit.ndf |
virtualDBA | 4 | data | 2.00 | 0.24 | 2.00 | 0.42 | 4.00 | 6.65 | 12.00 | 1.25 | 241505.00 | 126252.51 | 262965.00 | 20224.96 | 112322.00 | 163049.55 | 332422.00 | 50314.92 | 55.00 | 29.53 | 945.00 | 22.41 | 0.45 | S | X:\SQLData\virtualDBA_data.ndf |
migratedb | 1 | data | 0.00 | 0.00 | 2.00 | 0.15 | 0.00 | 0.02 | 22.00 | 1.25 | 415.00 | 3422.93 | 939144.00 | 53634.15 | 250.00 | 4491.52 | 4241920.00 | 335235.69 | 0.00 | 0.20 | 322.00 | 25.55 | 0.00 | S | X:\SQLData\migratedb.mdf |
migratedb | 2 | log | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.05 | 23.00 | 10.21 | 0.00 | 515.21 | 292254.00 | 25522.56 | 259.00 | 263.01 | 3566245.00 | 226214.03 | 0.00 | 0.09 | 645.00 | 52.12 | 0.00 | t | Y:\SQLLog\migratedb_log.ldf |