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 |
|
mageshks
Yak Posting Veteran
59 Posts |
 Posted - 2007-08-21 : 10:41:39
|
| Hi all,We are using temp tables (loacal Temporary tables) in our business logic(stored procs).During the load test , the temp DB log gets full.How to avoid this?.Thanks in advance. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-08-21 : 12:17:34
|
| Add more disk space to the drive where tempdb LDF file exists.How big does it get? How big is the drive? How much free space on the drive?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-21 : 21:59:08
|
| Did you let tempdb log file auto grow? |
|
|
|
|
|
|
Temp DB log full during load test