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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-02-19 : 09:25:23
|
| Frank writes "Is there a "rule of thumb" or sizing guidlines for tempdb?I've read that the size of tempdb should be 25% of the largest database on the SQL Server. Is there a percentage of the total tempdb size for the Transaction Log file?On one of my servers, there is a 4 GB database. tempdb is 1 GB.However the data portion is 255 MB and the log portion is 814 MB. This seems wrong to me (I would expect an 814 data portion and a 255 log portion)."By default, tempdb is 8 MB with a .5 MB log file (or 6.25%). Is this an acceptable percentage for tempdb log files?" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-02-19 : 09:47:33
|
| If the server hasn't been restarted lately, tempdb's log will still have records of all the temp table and other working table activity since last restart. You can restart the SQL Server and tempdb will start fresh.There's a section on transaction logs on SQL Team here:http://www.sqlteam.com/FilterTopics.asp?TopicID=116And I found this:http://www.sqlteam.com/item.asp?ItemID=5371Also search for "tempdb" on SQL Team, there's some more articles on it.You should definitely increase the default size of the tempdb log file, 10 MB is probably a good start.Edited by - robvolk on 02/19/2002 09:48:44 |
 |
|
|
|
|
|
tempdb sizing guidlines