Search Suggest

Head Blocker
Head Blocker

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, …