Monitoring SQL  «Prev 

sp_who output

Click the following thumbnails to view the full-sized image.
sp_who output
sp_who output
  1. spid and the column under it – The System Process Identifier (spid) uniquely identifies an active connection to SQL Server.
  2. Status and the column under it – Identifies the status of the program.
  3. loginame and the column under it – Loginname identifies the SQL Server login or Windows NT login that is connected.
  4. hostname – Hostname identifies the computer from which the connection was made.
  5. blk – Blk indicates if the process is blocked by another process. A zero means that the process is not blocked and any other number identifies the process that is holding the lock.
  6. dbname – Dbname identifies in the database that you are logged in to.
  7. cmd – Cmd provides a high-level understanding of what the process is currently doing.