Detect head blocker and how to retrieve job step name or job name for a SQL server Agent job. What will you do if you get blocking sessions:- using below script check head blocker --------------------------------------------------- SET NOCOUN…
How to detect Head Blocker How to detect head Blocker --------------------------------------------------------- SET NOCOUNT ON SET CONCAT_NULL_YIELDS_NULL OFF GO SELECT SPID, …