Investigating table locks

If performance is slow, a possible cause is that there's something amiss with the database tables. Investigating the statistics for the current lock requests is one possible way to detect problems with database tables.

  1. Navigate to main page> Transaction Server> Lock Statistics.
  2. Normally the statistics are disabled because the performance may be degraded. Click Enable to start recording information about all transactions, if needed.
  3. After gathering some statistics, evaluate the lock statistics for the active jobs

    If the number of lock requests, or the waiting time seems out of the ordinary, contact the database administrator to check on the status of the corresponding table.