Mostly commonly asked question related to sql server blocking – how to find blocking and blocked session (spid) in sql server? There are number of way to find blocking in sql server, you can use either system stored procedure (sp_who2), sql script, sql server activity monitor, sql server profiler and DMVs Find blocking sessions using sp_who2 ...