HELP: Lock timeout period exceeded...

  • Hello again,

    Can anybody tell me what shoul i check for the problem (image) that i put in one attached .zip file (FW EPG Manager - Problemas Bd's.zip)

    The point is that this guys are telling me that thay have a lot of timeouts when they are running one process inside management studio.

    I've already check if there are locks in the database and nothing.

    Q1-

    select * from sys.sysprocesses where blocked <> 0

    Q2-

    I've try to make one select in one table that they suppose have problems and this table return to me all records without any problem.

    use boepg

    go

    select * from dbo.Canais with (nolock)

    go

    Q3- i've check if there are any open transactions and nothing.

    use BOEPG

    go

    SELECT open_tran FROM sys.SYSPROCESSES WHERE blocked<>0

    go

    and

    dbcc opentran

    What should i check more.

    Thanks and regards,

    JMSM 😉

  • Can you post the contents of the email as a text document and seperate image docs so we don't have to open it in outlook?

    ed

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply