The tempdb seems to be filling up on some of my SMS servers some of the time. It seems pretty sporadic. I can see in the logs that the collection evaluator is modifying the members of the collections. Then it gets to a point where it starts failing because the tempdb fills up. My SQL admin clears the tempdb and things run as usual. I am not sure why this only happens sometimes and not sure how to handle it. Any help would be appreciated.