Long runtimes of usp_lock_release_multiple in stdlog

Products

• CA Service Desk Manager
• CA Service Management - Service Desk Manager

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 SDM-SERVER 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

Release : 17.3

Component : Svc Desk Performance

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.

https://techdocs.broadcom.com/us/en/ca-enterprise-software/business-management/ca-service-management/17-3/administering/administering-ca-service-management/offline-reporting-through-microsoft-sql-server-database-replication/implement-replication/manual-configuration.html