Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 PRADEEP CHOWDARY PYDI (PradeepPydi)
Anthem
Senior PEGA DEVOPS and Cloud Administrator
Anthem
US
PradeepPydi Member since 2017 240 posts
Anthem
Posted: Jul 25, 2019
Last activity: Jul 27, 2019
Posted: 25 Jul 2019 16:54 EDT
Last activity: 27 Jul 2019 7:13 EDT
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.

To see attachments, please log in.
Low-Code App Development
System Administration

Posted: 5 years ago
Posted: 27 Jul 2019 1:31 EDT
Udhay Raman (ramau)
Cognizant Technology Limited
Lead Technical Architect
Cognizant Technology Limited
IN

Hi,

During the server recycle you can truncate the lock table and try.

To see attachments, please log in.
Posted: 5 years ago
Posted: 27 Jul 2019 4:33 EDT
Abhinav Gupta (Abhinav7)
PEGA
Manager, Technical Support - Platform Service Engineering
Pegasystems Inc.
IN

Hi ,

Have you observed any database exception.It might be due to DB deadlock .Run below script.

ALTER DATABASE <pegadb> SET READ_COMMITTED_SNAPSHOT ON;

Thanks,

Abhinav

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice