All of a sudden, the tempd.mdf is growing to 17 gig, Restarted the server, and shrank. This week same thing. Why would this happen all of a sudden, and what is the best way to keep this under contol? SQL2000
What recently changed? Sounds like you have one or more processes not working correctly or you need to keep the temp db large to handle current workload. You could have a query that is selecting a huge number of rows that someone just implemented or something that is repeating that shouldn't be.
"NOTHING is more important in a database than integrity." ESquared
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.