Have you ever looked at sys.dm_os_virtual_file_stats and saw horrible latency for your database files? Generally speaking, you want to see latency below 20 ms on your database files.  much above that and there are some problems somewhere that need some tuning. But, how do you know what queries are causing your issue? What’s causing those … Continue reading Correlating IO Wait with Queries