In one of our boxes a particular Update statement get locked up frequently and we usually kill the session. How do we go about resolving this.

Thanks