Edited : Why are sessions reporting being blocked but waiting with
PAGELATCH_*, and not
LCK_M_ related wait types?
I previously assumed that SQL server would only report blocking sessions in the blocking_session_Id column. If the blocked sessions were waiting for a logical lock and not anything else such as a