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 |
|
dewacorp.alliances
452 Posts |
 Posted - 2006-10-20 : 01:00:13
|
| Hi allI got this one database server that is used for datawarehousing (Cognos). The tempdb for some reason saying that the transaction log is full. Is there any guidelines for managing tempdb? At the moment, I set AUTO UPDATE STATISTIC and AUTO CREATE STATISTIC ON (based on SQL-PERFORMANCE.COM). Also, set as AUTOMATICALLY GROW SIZE BY 10% and UNRESTRICTED FILE GROWTH for data and transaction log.At the moment, the tempdb (used and free) for data is 3MB / 4845.25MB and for tran log is 2.44 MB / 4.3 MBThanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-10-20 : 01:21:02
|
| Add more disk space to your server. You need enough space in tempdb to accomodate a query that requires the largest amount of space in that database. So if you are receiving that error at any time, you need to add more disk space. You could always optimize your queries so that they don't require tempdb so much, but that might be a little harder to do.Tara Kizer |
 |
|
|
|
|
|
Managing tempdb