How to get the list of processes which are blocked in SQL SERVER?

 Posted by Bandi on 9/30/2013 | Category: Sql Server Interview questions | Views: 1453 | Points: 40

There are two ways to get this sp_who and sp_who2. You cannot get any detail about the sp_who2 but its provide more information than the sp_who. And other option from which we can find which process is blocked by other process is by using Enterprise Manager or Management Studio(SSMS), these two commands work much faster and more efficiently than these GUI-based front-ends.

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response