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?