• I did run this query on server

    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')

    I got no rows. Is that means we don't have allocation contention on tempdb?