Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Tempdb Service Broker Problem Expand / Collapse
Author
Message
Posted Thursday, March 26, 2009 9:42 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, August 6, 2014 7:38 AM
Points: 159, Visits: 518
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!
Post #684279
Posted Monday, October 28, 2013 10:40 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, August 15, 2014 5:08 AM
Points: 38, Visits: 304
Hi,

Sorry to drag up an old post, but did you ever find the cause to this?
Experiencing a similar issue.

Thanks,
Matt.
Post #1509032
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse