lock request timeout period exceeded in dbo.pr_sys_locks.
we are facing this issue in almost all platforms,though this issue is common.
i can see this is happening frequently and causing deadlock.
this will impact application performance.
any solution for this issue?
@DevipriyaA , Hope this will help.
basically you can write a custom activity to kill the long running requestors and also clear the syslock table with the un necessary entries
this you write with a standard agent and schedule it so that it will automatically run after certain period and will not block the database
Run a job scheduler than will run multiple times a day which will query through the pr_sys_locks table and release the oldest locks.