How do I find out what is causing the Internal_objects size to grow in tempdb.
I have dbcc running each night and update stats runs each night. I would expect tempdb to calim this space back when it has completed.
Is there a way to monitor the tempdb internal objects or view/list them?