October 6, 2003 at 4:59 am
I have a sql7 sp2 server with drives CDEFG.
C is program files for operating system
D houses sql server and system databases
E F used for user databases and G for backups to disk.
Drive D is getting low on free disk space 70mb free. Im a little anxious as the tempdb is 1.2GB set to autogrow 10%. The disk will become full if this happens.
My user databases total approx 10gb.
A predecessor of mine configured tempdb to 1gb on this 2 GB drive.
I was proposing to shrink the tempdb to 1GB.
Does this seem reasonable or could you suggest alternative action?
Thanks in anticipation.
October 6, 2003 at 8:03 am
You don't give the sizes of the different drives.
But it does sound reasonable, unless you have a lot of transactions.
One thing to change is the way the TEMPDB grows. I never set my databases/logs to grow by percent. Figure out how your TEMPDB grows on the average, and set it to grow by that much (ie. 250 MB).
-SQLBill
October 6, 2003 at 9:08 am
Bill Thanks for your post
I have 2 gb free on E & F and 13 gb free on G.
Does the tempdb need to be so large at 1.2GB?
How can I estimate what size I can shrink it to? The log file on tempdb is only 3mb but the datafile the remaining 1197mb.
October 6, 2003 at 10:11 am
Try this....stop the MSSQLSERVER service (and the SQLSERVERAgent service if it's running) and then restart them.
That will rebuild the TEMPDB. It will start at the same size as MODEL.
TEMPDB is just that - a temporary database.
-SQLBill
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply