• The blocking occur intermittent

    i have also set sp_configure 'blocked process threshold', 10. .

    and when the blocking happened , i try to select other rows in the config table , it return the result .

    But when i try to select the row which condition where Getdate() > eff_start_dt and sys_key= 'LAST_USED_LOG_ID' , it will keep loading because these particular key was blocked by the update statement .

    But what have cause the blocked for these update statement ? I can see exclusive lock . but there are no other insert or update to the config table except the only one which blocked .