How to make tempdb smaller

[andreis]

Hi:

I increased the size of my production SQL Server 2000 tempdb hoping to improve performance, but the performance got worse because of memory shortage. Now I can't get tempdb smaller using ALTER DATABASE. How can I return to the initial size of tempdb?

Thanks.

 

[Catadmin]

Lookup DBCC ShrinkFile and DBCC ShrinkDatabase in Books Online. These two commands should help you out.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[gyfu]

You could also delete the tempdb, and SQL server will re create it when you start it again.

-- gyfu --
Crystal Ver 10
Microsoft SQL

 

[SQLBill]

Stop and start your SQL Server services. That deletes the TEMPDB and rebuilds it based on Model.

-SQLBill

Posting advice: FAQ481-4875