Hello. I'm currently employed as a DBA. Recently I faced a problem of poor activity monitor perception. We have tasks in the running state, some of them have resource waits. So if a task is not waiting for anything, why is it even taking time to execute? No cpu wait, no disk wait, why isn't it run instantaneously? Also, the resource wait column - does it display the last waiting resource? Because if a task is waiting, it is supposed to be in the suspended state. Additionally, sys.sysprocesses shows tasks in the running/runnable state, why doesn't activity monitor separate these two? Thanks!