Thank you! Very useful

What I am missing?

I thought that status from sys.dm_exec_requests should match to status from sp_who2, and they are not?

SELECT

a.scheduler_id ,

b.session_id,

c.status,

start_time,

(SELECT TOP 1 SUBSTRING(s2.text,statement_start_offset / 2+1 ,

...

I see

Reporting Service 16 %

Sqlsrv 59 %

System Idle ...