"AppInsight for SQL: Alert me when my database file disk I/O latency is high" - Generate a report

TimWhite_LC2

I would like to generate a report for high volume latency on my SQL volumes that somewhat replicates the alert "AppInsight for SQL: Alert me when my database file disk I/O latency is high"

This alerts when the volume latency is 15ms or more.  I would like to view the latency over time.

My initial thoughts were from the Orion.VolumeStats or Orion.VolumePerfomanceHistory tables.

I have excluded VolumeStats as that is a point in time table.

VolumePerformance Hostory does provide metrics over time.

However, neither provide 'latency' information.  The closest is disk queue length and that really does not relate to latency.

Could anyone assist with a query that will allow me to report volume latency over time?

TimWhite_LC2

Update for anyone else looking for this data:

The AvgDiskTransfer in the VolumePerformanceHistory table provides the volume latency data in seconds.