May 11, 2005 at 6:55 am
Good evening friends!
I have some problem with tempDB.It size getting big and for this allocated space is 6.2 GB so it is not going beyond that space after restarting sql server.I have tried shrinking file also.My question is
1.should i can change the allocated size of this DB before restarting server? (ie,If i change it to 2GB then after restarting the server DB size will reduse to 2GB or not)
2.if so what is the minimum allcated size required by tempdb?
2. which is the better way to allow file growth, in MB or by percent?
Thanks in advance
Rafi-
May 15, 2005 at 10:26 pm
Rafeeque,
You dont really need to restart the sql server first of all.
My assumption is, there are some database procedure/call uses tempdb heavily and it requires 6.2 GB maximum. and after the transaction is completed,
the actual space used by tempdb data may not be the same.
1.
If you have problem with tempdb transaction log file growth, check this up
If you have sql server 2000, just change the "Recovery Model" options to Simple
or if you have SQL Server 7, check if you have "truncate log on check point" option.
or if you have tempdb data file growth, preallocate 7 GB for your data file.
It does not meen that you are using it all the space.
2. After SQL Server installation, the initial tempdb size is always 8 MB for data and 1 MB for log.
3. if you have a lot of temporary table transactions, it is always better you should find out the maximum threshold size and you can preallocate the space instead of waiting for automatic grow.
and allow the file growth by some 100 MB.
Hope this helps
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply