How to query Max I/O Wait value from Spotlight Statistics database? (4220390)

To obtain Max I/O Wait value from Spotlight back-end database (SpotlightStatisticsRepository), one needs to query against the virtual file statistics data that's stored in 'virtualfilestats' table.

This table contains the following columns: dbandfgname, dbfilename, dbname, disk, filename, iorate, iostallreadms, iostallwritems, iowaitms, iowaitrate, kbondisk, kbread, kbtotal, kbwritten, numberreads, numberwrites, readsrate, readswaitrate, writesrate, writeswaitrate

Spotlight Reporting and Trending Guide includes a section 'Browse dimension tables and retrieve data' that outlines how to retrieve data from this table and build a custom query against it. 

Download the latest PDF version of Spotlight Reporting and Trending Guide from here:
https://support.quest.com/spotlight-on-sql-server-enterprise/technical-documents