Question
3
Replies
164
Views
Posted: September 25, 2019
Last activity: September 30, 2019
Closed
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?
what is your Pega version? Here is another related post: https://community1.pega.com/community/pega-support/question/heavy-sql-db-resources-consumption-delete-dboprsyslocks