Tempdb Service Broker Problem

• Steve-443559

  SSCrazy

  Points: 2309

  More actions

  March 26, 2009 at 9:42 am

  #130147

  The Tempdb on one of my servers if growing. I ran a query to find out what is using it and it points to Internal Objects as the space hog. I ran another query to find out what SPID is using the most and it turned out to be SPID 12, which is a system process, BRKR EVENT HNDLR. I'm pretty sure this has something to do with Service Broker. I checked Transmission queue and there are no errors in the status. I also check Conversation_Endpoints and there's a minimal number in there. Anyone have any ideas on where else to look?

  Thanks!

• mwhite39

  SSC Rookie

  Points: 40

  More actions

  October 28, 2013 at 10:40 am

  #1662100

  Hi,

  Sorry to drag up an old post, but did you ever find the cause to this?

  Experiencing a similar issue.

  Thanks,

  Matt.