Long runtimes of usp_lock_release_multiple in stdlog
Article ID: 228364
Updated On:
Products
Issue/Introduction
Performance issues are being observed in the stdlogs, in the form of multiple references to this message:
11/12 09:34:08.74 <servername> sqlagt:Procedure0 5272 SIGNIFICANT sqlclass.c 1063 The following statement took 20992 milliseconds: Clause ({ ? = call dbo.usp_lock_release_multiple;1( ?, ?, ?, ? ) }) Input (<int>1636705397|<int>0|<string>*)
Environment
Service Desk Manager 17.3 and up
Cause
usp_lock_release_multiple is a stored procedure that is defined within the MDB database that is used with the SDM application for lock management.
The above message is often seen with environments where there is database replication for reporting, but the replication has included certain tables that should not be part of the replication process.
Resolution
This document link lists the tables which should be excluded from replication.
Feedback
