At my work, we’ve recently had a few instances of heavy disk activity on one of our SQL servers, causing timeouts and general unresponsiveness. The hard drive lights on the front of the machine are pegged. In one case we were able to find a backup job that had fired at the wrong time; stopping it resolved the problem. Other times, we’ve been unable to locate any cause for the heavy activity.
Does anyone have any troubleshooting tips? Any easy way to isolate the origin of heavy disk activity?