Blocking object that is causing a shared lock is not seen in Blocking History.
Scenario
There are two queries master database that are waiting 100% of the time for a lock. Normally those queries are visible somewhere in the blocking chain on Blocking History and the user can see who these queries were waiting on. But when looking at Blocking History only these two are the leader blockers (not waiting on anything).
Is there something wrong with the data it gathered?
© ALL RIGHTS RESERVED. Feedback Nutzungsbedingungen Datenschutz Cookie Preference Center