Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kirknew2SQL
Posting Yak Master
194 Posts |
 Posted - 2008-02-08 : 17:53:37
|
| I have had my first experience with shrinking the tempdb by following the procedure in:http://support.microsoft.com/kb/307487#appliestoIs there a way to incorporate this procedure or a standard way to schedule a maintenance program that will shrink the TempDB once a month or something? thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-02-08 : 20:03:14
|
| You should not shrink any databases automatically. If there is a problem with lack of free space, then add additional disk space to support the sizes of the databases that are needed to support your data and queries.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
kirknew2SQL
Posting Yak Master
194 Posts |
Posted - 2008-02-10 : 22:50:22
|
| I have been trying to figure out how my tempDB ballooned to over 18G. I think I know why but I want to get expert opinion on my thoughts. The tempdb database is re-created every time SQL Server starts. On my server SQL Server is a Automatic service. Since the server is never turned off SQL never restarted even though the application is closed every night. Since the tempdb is set to automatically grow it ballooned because the server was never restarted.does this sound correct? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-10 : 23:10:22
|
| Tempdb grows when sqk needs it, just leave it unless you have disk space issue. In that case, better to move it to big disk than shrink it. |
|
|
|
kirknew2SQL
Posting Yak Master
194 Posts |
Posted - 2008-02-10 : 23:22:04
|
| Yes I it grows when needed. The question is did it get that big because SQL was never restarted? |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2008-02-11 : 01:17:47
|
| Not necessarily, most peoples SQL Servers never restart. It got big because there is something in your application causing that, whether that is something unavoidable, or whether there is something silly going on in your app code (like big global temp tables that never get cleaned up) is impossible to tell from here.(Also, what's a blote ?)Damian"A foolish consistency is the hobgoblin of little minds." - Emerson |
|
|
|
kirknew2SQL
Posting Yak Master
194 Posts |
Posted - 2008-02-11 : 13:55:40
|
| Sorry that was a typo. Meant 'bloat' |
|
|
|
|
|
|
TempDB Blote problem