troubleshootingsql.com
Sleeping session ID: Where art thou?
This has been an age old confusion ever since the Dynamic Management Views changed the way SQL Performance monitoring was done. A SPID/Session ID will show up as Sleeping/Awaiting Command when it h…