Does lastBatch in sp_who2 really mean the time the user execute a SQL batch

• sqlfriend

  SSC Guru

  Points: 52794

  More actions

  May 12, 2021 at 4:52 am

  #3882175

  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.

  Thanks

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738347

  More actions

  May 12, 2021 at 3:42 pm

  #3882401

  This comes from sys.sysprocesses. If you check the docs (https://docs.microsoft.com/en-us/sql/relational-databases/system-compatibility-views/sys-sysprocesses-transact-sql?view=sql-server-ver15), this is listed as the last time that the user executed something.

• sqlfriend

  SSC Guru

  Points: 52794

  More actions

  May 15, 2021 at 12:24 am

  #3883645

  Thank you, yes,  I get to know sysprosses result the same as sp_who2.

  But if I run sp_whoIsActive, I click during the lastbatch time, but no records shows.

  So I am wondering if those users are only connect to the database, or left desk and leave the connection open without doing anything.

  Thanks