Guy Glantser helps us troubleshoot who is using tempdb space and for what purpose:
In the past two weeks I encountered 3 different scenarios in which tempdb has grown very large, so I decided to write about troubleshooting such scenarios.
Before I describe the methods for troubleshooting tempdb space usage, let’s begin with an overview of the types of objects that consume space in tempdb.
The answer, of course, was Professor Plum in the Aviary with the eager spool.