Disk I/O read/write param
Posted: May 26th, 2010, 5:35
The Avg. Disk queue length on my SQL server disk is BIG. The avarage goes up to 50!!! Some applications do that. But I don't know which ones. When that happens everything slow down from 5 to 30 seconds and more. How can I see disk I/O read/write param on my disk for each application? I want to see which application do that to try to fix problem.