We are importing one object via a REST call, but getting a tremendous amount of DB blocking - to the point the AWI becomes unavailable to users.
The head blocker has this statement:
(@P1 int)SELECT * FROM OH with (UPDLOCK) WHERE OH_Idnr = @P1
Does anyone have experience with the import of a JSON causing the system to grind to a hault?