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