Click the following thumbnails to view the full-sized image.
sp_who output
spid and the column under it – The System Process Identifier (spid) uniquely identifies an active connection to SQL Server.
Status and the column under it – Identifies the status of the program.
loginame and the column under it – Loginname identifies the SQL Server login or Windows NT login that is connected.
hostname – Hostname identifies the computer from which the connection was made.
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.
dbname – Dbname identifies in the database that you are logged in to.
cmd – Cmd provides a high-level understanding of what the process is currently doing.