Farooq Shaik (FarooqS0)
Aegon UK PLC

Aegon UK PLC
FarooqS0 Member since 2019 1 post
Aegon UK PLC
Posted: September 25, 2019
Last activity: September 30, 2019
Posted: 25 Sep 2019 7:13 EDT
Last activity: 30 Sep 2019 1:53 EDT

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?

Data Integration
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.