gs gs116 Performance Tuning and Optimization - SQL Server Blocking - Quiz No.1

P1 & P2 trying to get to 2 resources R1 & R2. P1 gets a lock on R2 and P2 gets a lock on R2 THEN P1 tries to get a lock on R2 but can’t because it is locked by P2 and P2 tries to get a lock on R1 but can’t because it is locked by P1 

 P1 & P2 trying to get to 2 resources R1 & R2. P1 gets a lock on R1 and P2 gets a lock on R1 THEN P1 tries to get a lock on R2 but can’t because it is locked by P2 and P2 tries to get a lock on R1 but can’t because it is locked by P1 

SELECT OBJECT_NAME(p.object_id) AS TableName , i.name AS IndexName FROM sys.partition AS p INNER JOIN sys.indexes AS i ON p.object_id = i.object_id AND p.index_id = i.index_id WHERE partition_id = 72057594038845440 

SELECT OBJECT_NAME(p.object_id) AS TableName , i.name AS IndexName FROM sys.partitions AS p INNER JOIN sys.index AS i ON p.object_id = i.object_id AND p.index_id = i.index_id WHERE partition_id = 72057594038845440