Blocking on pr_sys_locks and pr_sys_locks_sla tables
I'm DBA managing PEGA databases, recently we've noticed increased blocking on our SQL server database on these two pr_sys_locks and pr_sys_locks_sla tables. The below delete command is running but not doing anything for long time blocking other transactions.
(@P0 varchar(8000))delete from dbo.pr_sys_queue_sla where pzInsKey = @P0
Any idea why it's holding locks for so long? shouldn't it delete the row immediately?
Pegasystems Inc.
US
what is your Pega version? Here is another related post: https://collaborate.pega.com/question/heavy-sql-db-resources-consumption-delete-dboprsyslocks
Pegasystems Inc.
IN
Hi,
You can refer below Article. It may be useful
https://community.pega.com/support/support-articles/delete-prsyslocks-causing-db-blockage
Pegasystems Inc.
IN
Can you please check if you are getting any exceptions from DB side? That may give us some idea on this.