Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2003
    Posts
    21

    Wink Unanswered: How To Get A List Of Uncommited Transactions

    Hi

    Our transaction log has grown to a few gigabytes
    I suspect one of our server applications had started a transaction
    but never commited it.

    I cant shrink it since all this size is being used.

    I tried checkpointing it but with no effect

    Is there some way to get a list of all active transactions and
    their start date?

    Thanks.

  2. #2
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    use @@trancount to find out the no of active open transactions
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

  3. #3
    Join Date
    Jul 2003
    Posts
    21

    @@Trancount only works on the specified connection

    but I dont know which connection is causing this.

    I need some way to tell which application (which connection)
    Is preventing the transaction log from checkpointing.

    I need a list of all started transactions and their origin

    thanks

  4. #4
    Join Date
    Jul 2003
    Location
    England
    Posts
    152
    I assume that you want to reduce the size of the transaction log file? - Is that your goal? If this is the case then backup the log file. Use dbcc loginfo to see the active parts of the log file, as it gets reused by your app. Using dbcc shrinkfile (or ent manager) you can then eventually reduce the size of the trans log file.

    All that checkpointing does is flush all the committed tranactions back to the datafile(s). It does not impact the size of the transaction log file.
    Regards
    Dbabren

  5. #5
    Join Date
    Nov 2003
    Posts
    94
    select * from master.dbo.sysprocesses

    the column open_tran will show the number of open transactions, the SPID number will identify the process and connection.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •