March 23, 2016 at 3:21 pm
Hi All ,
I have temp db drive which is of 125 GB and out of them 76 GB is free .
But for curiosity want to know it usually sits free around something 85 GB free so what are the ways to get Temp db clean and also suggest ways to keep it proper . Thanks In advance .
March 23, 2016 at 4:03 pm
Hi
Imho you can find some useful information about shrinking tempdb there:
https://support.microsoft.com/en-us/kb/307487
Regards
Mike
March 24, 2016 at 8:56 am
But, something you've done or are doing on your server has grown the tempdb out to this size. Unless you know for certain what that was and that it won't be repeating, I wouldn't go and shrink tempdb.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 24, 2016 at 1:17 pm
One sure-fire way to shrink tempdb back to it's original size is to bounce the SQL Server service. Tempdb will be rebuild with it's original size.
However, what Grant said is very true. Something caused it to grow and if it runs again, it'll probably cause it to grow again. Better off to just leave it alone. The real way to prevent it from growing in the first place is to find what caused it to grow and see if it can't be optimized a bit to not consume so much temporary space. This isn't always possible.
March 24, 2016 at 11:10 pm
Check out the following links to shrink temp db in various ways: http://dbadiaries.com/how-to-shrink-tempdb
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply