July, the 31 Days of SQL Server DMO’s – Day 18 (sys.dm_io_virtual_file_stats)
- by Tamarick Hill
The sys.dm_io_virtual_file_stats Dynamic Management Function is used to return IO statistic information about each of your database files on your server. As input parameters, this function takes a database_id and a file_id. If you want to return IO statistic information for all files, you can simply pass in NULL values for both of these. Let’s have…