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, these two commands work much faster and more efficiently than these GUI-based front-ends.
Subscribe to:
Post Comments (Atom)
-
When SQL Server executes a query it uses a query plan to determine how to access data and complete the query. SQL Server offers DBAs and d...
No comments:
Post a Comment