High IO on SQL Server 2010
Posted on 2014-04-25
We find that the SQL server IO is high in this afternoon. Using the query below, there is not too much task running on the server and some of the tasks are 'suspended'. I just wonder whether the query has included all the running processes or job running on the SQL Server. Will there be a possiblity that the high IO task is coming from the suspended job as the query only show the CPU. It can't show IO at all.
FROM sys.dm_exec_requests req
CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS sqltext