Lock request timeout

• bobrooney.81

  SSC-Addicted

  Points: 468

  More actions

  February 3, 2021 at 1:25 pm

  #3840500

  Hi All,

  Appreciate you help on below.

  End users are experiencing "Lock request timeout" very often and we are getting blame as database is unstable.

  Need some guidance on how to go about troubleshooting and alleviate such concurrency issues. We do see some blocking but we don't see any long term blocking.

  Error shared by app team :

  SIP-10322 Cannot lock table [xxxxxxxx] because the table is locked by another process.

  Is this because of too many concurrent sessions accessing an object or long transaction?

  App users have increased the timeout value from front end. However they still seeing Lock request timeouts.

  Any perfmon counters to be looked at ? what steps to be taken to build a story of why there are seeing the lock timeouts.

  Best Regards,

  Bob

• Site Owners

  SSC Guru

  Points: 80330

  More actions

  February 4, 2021 at 2:10 pm

  #3840974

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.