Question

3
Replies
111
Views
FarooqS0 Member since 2019 1 post
Aegon UK PLC
Posted: 1 year ago
Last activity: 11 months 3 weeks ago

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
Share this page LinkedIn