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.