SELECT session_id AS SessionID, wait_duration_ms AS Wait_Time_In_Milliseconds, resource_description AS Type_of_Allocation_Contention FROM sys.dm_os_waiting_tasks WHERE wait_type LIKE 'PAGELATCH_%' AND (resource_description LIKE '2:%:1' OR resource_description LIKE '2:%:2' OR resource_description LIKE '2:%:3')