Skip to Content

sap table locked / head lock

Dear Experts .

Recently we experience system hangs on our sap clients (teminal) due to database table lock for a long period of time .

Upon looking into the matter I see that there is presumably a select query that blocks other queries

e.g. :

when checking into spid 105 I see that database history has the following query as last run for this session id :

SELECT [OWTJ].[TimerEtyId],[OWTJ].[Status],[OWTJ].[JobHanConf],[OWTJ].[LastUpdate],[OWTJ].[StartDate],[OWTJ].[StartTime],[OWTJ].[JobHanType],[OWTJ].[Id],[OWTJ].[IsASync] FROM [Dyn2005]..[OWTJ] WHERE [OWTJ].[StartDate] IS NULL FOR BROWSE

if I kill session 105 (source host is the SAP sql Server ) everything works fine but of course sooner or later same problem occurs.

checking into OWTJ , I don't have any workflow set up for the company

any help is much appreciated.

Thank you ,

Nadav.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    May 28, 2015 at 06:01 PM

    Hi Nadav,

    Disallow page locking for those tables. For some tables, disallowing page locks improves the concurrency of accesses from different users to these tables, therefore avoiding deadlocks. You can do this using the SQL command:

    EXEC sp_indexoption <tablename>, "DisAllowPageLocks", "TRUE"

    Thanks,

    Kavitha Rajan.

    Add comment
    10|10000 characters needed characters exceeded