sp_who result

• Tsql-561486

  SSC Eights!

  Points: 821

  More actions

  December 6, 2007 at 4:20 am

  #377359

  Hi,

  while executing sp_who i got the below result

  Spid Status Login Host BlkDbname cmd

  22 sleeping sa XXXX 0User_DB Awaiting cmd

  sp_who displays the current active process, but in the above the status is sleeping.

  Please explain me if this process is currently active or idle.

  And also when i checked what the process is doing using inputbuffer, it is executing SELECT statement.

  Please explain what this result actually mean.

  Thanks.

• bluepaperbag

  SSCrazy

  Points: 2055

  More actions

  December 6, 2007 at 7:54 am

  #757677

  sleeping means it's waiting for a command to get process.