Post reply

Service Broker filling Tempdb

  • October 19, 2012 at 2:05 am

    #264355

    I’m new to SB. Never had issues with it previously.

    I have 2 service broker tasks/queues one works fine and I never see it appear when I run

    select * from sys.conversation_endpoints

    order by [lifetime]

    But a new broker task/queue was set up a few weeks ago. Which always appears in this query. It always has a state of ‘DI’ which would indicate that it is not closing the conversation properly. I have checked and there is only 1 SB contract on in the db. Should there be one for each process.

    If the conversation closing is the issue how do I check and resolve?

    Thanks

  • October 19, 2012 at 2:16 am

    #1550745

    Correction they are both appearing in this query, and can hang about for between 30 mins to 1 hour.

    Additional info-

    Alloc_pages in tempdb keeps growing with dealloc = 0 from CMD ‘BRKR TASK’

    How to get it to dealloc _pages ?

  • October 19, 2012 at 3:19 am

    #1550764

    Please don't cross post. It just wastes peoples time and fragments replies.

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1374671-1281-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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