I usually use sp_who2 see who is connected and is active in the SQL server database.
When executing sp_who2, there is a column lastbatch, when each time I executed sp_who2, I see the time is updated almost the current time, may be a couple of minutes earlier, but I see those processes are in sleeping status . awaiting command.
Does that mean those users execute last batch of SQL a couple of minutes ago?
Could that be possible they just logged in many hours ago and did not log out ?
I know I can use sp_whoisActive, but I see no active ones in the result.