Question

4
Replies
157
Views
PradeepPydi Member since 2017 204 posts
Anthem
Posted: 1 year ago
Last activity: 1 year 2 months ago
Closed

Heavy SQL DB resources consumption @ delete from dbo.pr_sys_locks .

Hi Team,

Heavy SQL DB resources consumption (along with deadlocks) has been observed during the below mentioned query execution (Nothing reported by AES though)

delete from dbo.pr_sys_locks where pzInsKey = @P0 and pxOwnerId = @P1

Please suggest the scenarios during which this issue might happen and remediation recommendations ?

(PRPC731,MSSQL and Tomcat)

Thank you.

Low-Code App Development System Administration
Moderation Team has archived post
Share this page LinkedIn