How to capture Query Status(Sleeping, Background, Running) in SQL Server Profile trace
Profiler does not capture point in time information (ie, what is the status of this query or wait times/types or current blocks, however you can get deadlock events). But rather, it captures activity/event information (ie, this activity/event occurred so record it). As such, it will not be able to give you that kind of information since it is always runnable when those activities are occurring.