Post reply

SQL Server 2008/R2 TempDB locked by Service Brokers being enabled

  • July 16, 2015 at 11:57 am

    #300317

    We have a strange but fatal error going on where we enabled service brokers on our production SQL Server but even with no brokers being used, tempdb will get locked by some phantom process. Our ERP will throw lock errors every few minutes and we aren't even running any queues.

    When you try to get tempdb's properties, it errors out.

    This makes no sense as we haven't implemented our code just enabled the standard brokers.

    Desperate for ideas,

    Rodd

  • July 16, 2015 at 12:13 pm

    #1813099

    Were you able to identify the blocking process?

  • July 16, 2015 at 1:39 pm

    #1813122

    Yes, its the ERP apparently inappropriately abandoning the transaction. I believe its a but they have but in the meantime, we have an issue of it recreating itself.

    Working on changing user behavior to stop the transaction from being initiated until a fix can be created.

    Any ideas on how to kill a specific lock on a transaction without killing everyone else's legit work?

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

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