Database Reference
In-Depth Information
Figure 19-4.
Deadlock due to the scans, Step 2
If you ran the query shown in Listing 19-1 at the time when both sessions were blocked and before the Deadlock
Monitor task woke up, you would see the results shown in Figure
19-5
.
Listing 19-1.
Lock requests at the time when both sessions were blocked
select
tl.request_session_id as [SPID]
,tl.resource_type as [Resouce Type]
,tl.resource_description as [Resource]
,tl.request_mode as [Mode]
,tl.request_status as [Status]
,wt.blocking_session_id as [Blocked By]
