Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

tempdb fills up

Status
Not open for further replies.

mib147

MIS
Apr 11, 2003
148
US
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.
 
Thank you tbrennans. After doing some investigating and speaking with my DBA, we do have things set correctly. The backup is set to simple. Also, my DBA isn’t even running a backup because of the built in SMS backup task. The SMS backup runs between 10:30pm and 11:30pm. The collection evaluator seems to fill up the tempdb sometime in the morning (it’s random). Anywhere between 7am and 9am.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top