title: Is sp_who2 for the entire server and why is it not detecting all high priority processes?
body: <p>I'm looking at sp_who2 and it appears as though all processes are in a sleep mode and our website is extremely slow.   I was wandering if sp_who2 looks at only the current database, or is it looking at another database can be causing the problem and sp_who2 only looks at the current database.</p>
  
  <p>Also is there a way to detect if a sql process is running at a higher priority and blocking other processes.  When I ran sp_who2 we had several processes that are normally in a runnable state, but they were all in a sleeping state and I was trying to figure out what was blocking them.  It would nice to detect if a process was blocking other sql processes out.</p>
  
  <p>There is also a BlkBy column where we set to the same process ID of 77 which I think means block all other processes but am not sure.  Does anyone know what BlkBy means?</p>
  
  <p>I placed asterics ** ** around what I think is the culprit.  Is there a way to change priority or blocking so it no longer blocks. thx</p>
  
  <pre><code>SPID    Status                          Login       HostName        BlkBy   DBName  Command CPUTime DiskIO  LastBatch   ProgramName SPID
  76      sleeping                        db\uname    UNAME             .     db  AWAITING COMMAND    0   0   02/24 09:15:54  srv / db                                        76   
  77      sleeping                        db\uname    UNAME             .     db  SELECT              705422  0   02/24 09:25:49  srv / db                                        77   
  77      sleeping                        db\uname    UNAME             .     db  SELECT              16  0   02/24 09:25:49  srv / db                                        77   
  77      sleeping                        db\uname    UNAME           **77**      db  SELECT              32  0   02/24 09:25:49  srv / db                                        77   
  77      sleeping                        db\uname    UNAME           **77**      db  SELECT              31  0   02/24 09:25:49  srv / db                                        77   
  77      sleeping                        db\uname    UNAME             .     db  SELECT              16  0   02/24 09:25:49  srv / db                                        77   
  </code></pre>
  
  <p>Thanks.</p>