Very strange Service Broker and TempDB problem

Here’s a real-world scenario that Mr. Denny has encountered. People who have encountered or will encounter (hope not) a similar situation will thank him.

Symptom/Problem/Issue:

The symptoms that we were having in a nut shell was that the tempdb was taking all the drive space which was allocated to it.  On this system, tempdb is sitting on it’s own 50 Gig drive, so SQL can take the entire thing if it needs to.  The problem was that sp_spaceused was showing that the entire database was empty, but we were getting out of space errors when running queries which needed to use tempdb.

SOLUTION:

Read the Rest of the article here: A very strange Service Broker and TempDB problem 

-Marlon Ribunal

 

 

About these ads