search cancel

Long runtimes of usp_lock_release_multiple in stdlog

book

Article ID: 228364

calendar_today

Updated On:

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