Check active queries in MS SQL

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.