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 |
|
frank.svs
Constraint Violating Yak Guru
368 Posts |
 Posted - 2011-08-09 : 17:12:04
|
| Hi All,Can anyone give clue for the below scenario.Tempdb is growing high.Observation is the tempdev.mdf 1Gb which is acceptable but when i saw the temp.ldf it has grown upto 35 Gigs.I have no idea about this. Can help in figuring out why the ldf file is growing that much but actaul data file (.mdf) hardly grows to 1 gig.Looking for possible scenario's over here and how to troubleshoot such issues.I managed to shrink the ldf file back to 3 gigs.But i want to understand why there is a huge difference between mdf and ldf file.Any help would be much appreciated.Thanks in Advance. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-08-09 : 20:45:16
|
| Lots of temp tables?Index rebuilds? |
 |
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2011-08-09 : 23:08:36
|
| SORT_IN_TEMPDB option checked for index rebuilds will cause that to happen also. Open transactions on a process with a table being created in tempdb is another. |
|
|
|
Sachin.Nand
2937 Posts |
Posted - 2011-08-10 : 05:19:50
|
| What does select log_reuse_wait_desc from sys.databases return ?PBUH |
|
|
|
frank.svs
Constraint Violating Yak Guru
368 Posts |
Posted - 2011-08-10 : 05:30:49
|
| Thanks a lot for sharing your views. |
|
|
|
|
|
|
tempdb log is eating space