Archive

Posts Tagged ‘diskio diff’

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.

idefix_sql

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

sp_who2

%d bloggers like this: