Question

3
Replies
164
Views
Close popover
Farooq Shaik (FarooqS0)
Aegon UK PLC

Aegon UK PLC
GB
FarooqS0 Member since 2019 1 post
Aegon UK PLC
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?

Data Integration
Moderation Team has archived post