Here is an custom query for checking all running queries on an MS SQL server.

the custom writing in this script is just that it runs the sp_who two times and makes an diff on CPU time and DiskIO.


Download the file under, and run it in MS SQL Server Managmenet Studio.