we are faicng an issue recent high bloting on pr_sys_locks we did alter autovaccum still not completely avoid the blot issue even though size is 52 MB .
Related topics
| Conversation | Replies | Views | Activity | |
|---|---|---|---|---|
| lock request timeout period exceeded in dbo.pr_sys_locks | 3 | 100 | June 18, 2024 | |
| Pega Lock mechanism | 17 | 13636 | March 22, 2024 | |
| Archiving-related UPDATEs on PR_METADATA keep running and locking the database even though all archiving jobs are disabled | 1 | 45 | March 15, 2026 | |
| Database Locking-Not supported | 1 | 127 | February 19, 2024 | |
| Transaction (Process ID ) was deadlocked on lock | communication buffer resources with another process | 6 | 544 | October 16, 2024 |