Tracking SQL Server IO performance

Tracking SQL Server IO performance can give valuable insight on database files that have become hotspots and this post shows how to track them down.

I’ve finally got around to this, the third part of my SQL Server and Disk IO series of posts: The sys.dm_io_virtual_file_stats DMV and fn_virtualfilestats function are great tools for extracting granular information about SQL Server IO performance, right down to the individual file in each database. It gives details of the number of physical reads/writes, […]