Open Transactions Locking Database

  • Hi

    I have a SQL server 2000 sp3 - Datacentre platform with the following..

    If there is an open transaction against the Database I connot browse the DB objects with EM or Query Analyser. I get a lock request time out. This means if the DB has explicit trans open I cannot get into the DB. These are not huge transactions and I commit often.

    Any ideas about this behaviour?.....

     


    Andy.

  • What is isolation level of your transaction and what resources it locking?

    if

    SET TRANSACTION ISOLATION LEVEL SERIALIZABLE

    go

    begin tran

    insert into dbo.LSKLADI values(0,0,0,'qwe','qwe')

    WAITFOR DELAY '00:00:20:000'

    rollback tran

    than in other connections I can't exec select * from dbo.LSKLADI

  • I am using the default -  -READ COMMITTED

    My problem is that the entire database gets locked. You cannot even browse the sp'S.

     

     


    Andy.

  • those locking issues are very common on cases where "select into" is used with long performing queries. My advice: Try to change those to INSERT INTO instead

     

    HTH

     

     


    * Noel

Viewing 4 posts - 1 through 3 (of 3 total)

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