finding blocking session/query details

Posted by Professionaluser under Sql Server category on | Points: 40 | Views : 169
exec sp_who2

returns all the current processes connected to SQL Server. if any of the value in the column BlkBy is having any integer value, then we have blocking in SQL Server.

sp_who2 help you in identifying blocking sessions/queries. So based on this information, we can analyse further

Comments or Responses

Login to post response