• Karen

    While that script is useful for identifying which are your most expensive and/or most used queries for tuning, it doesn't help with identifying what is running at the moment. You could write your own script using sys.dm_exec_requests and other DMVs, or just use sp_whoisactiveor sp_who2 or Activity Monitor, which does that for you.

    John