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!

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

Tempdb.mdf

Status
Not open for further replies.
ThomH

ThomH

Vendor
Jun 9, 2003
22
0
0
US
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
 
Sort by date Sort by votes
Restart the SQL Server service :)
That way TempDB is recreated.

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.
 
Upvote 0 Downvote
We have restarted the SQL Server twice, but can't keep doing this every ohter day, and need to know why it is continually growing so big.

Thank you
 
Upvote 0 Downvote
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
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

crot
  • Locked
  • Question
TEMPDB.MDF size
Replies
1
Views
12
jester777
jester777
NickN
  • Locked
  • Question
moving tempdb.mdf in SQL 2000
Replies
9
Views
26
tlbroadbent
tlbroadbent

Part and Inventory Search

Sponsor

Back
Top