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.

idefix_sql

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

sp_who2