Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Tempdb Service Broker Problem Expand / Collapse
Posted Thursday, March 26, 2009 9:42 AM


Group: General Forum Members
Last Login: Tuesday, November 29, 2016 2:12 PM
Points: 166, Visits: 577
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?

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

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

Post #1509032
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse