What is this process?

[Patrick Tiller]

Lateley we have been getting blocking in our Production database. The head blocker is running this process several times between a FETCH API...

(@P1 int)SELECT * FROM OH with (UPDLOCK) WHERE OH_Idnr = @P1

I know OH is the Object table, and it is getting an IDNR, seems to be from the system, but I'm not sure where it is coming from it causes blocking for a few minutes.

[Darren Sniezak]

There's more than a few routines that could be modifying a column in the OH; I'd say get TCP/IP=2, DB=4 trace during a period of this and capture both the victim and blockers - that should be enough to open a case and get RCA