Post reply

DBCC OPENTRAN

  • September 25, 2014 at 7:39 am

    #311884

    Hi Experts,

    We recently faced issue with tempdb space and found a long running process using DBCC OPENTRAN. We killed the process and we were able to get able almost 110GB after shrinking the log files. My question is ,is it advisable to KILL a transaction found under DBCC OPENTRAN,the transaction was in 'sleeping' state.

    Please comment

    TIA

  • September 25, 2014 at 9:23 am

    #1748228

    It depends, if you have no other option, ie applications and other databases will be affected if you don't take action, then you must kill the transaction. As long as you fully understand what the transaction was doing, who was running it and why, then you can take steps to stop this happening in the future. Ideally before killing the query, first contact the person who started the transaction (if it was not yourself) to inform them they need to stop what they're doing.

  • September 26, 2014 at 1:58 am

    #1748393

    Thanks cunningham.

    The processes was basically from application server.

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

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