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-07-11 : 00:39:08
|
| Hi All,I was in little dilama on this concept and how to exactly react to such situations.Very often clients will be coming and asking us the txn log is growing very rapidly. Mostly when sharepoint content database are concerned.Sometimes the tlogs will grow up to 33 Gigs and may also next day it is growing 67 gigs.I came to know a crawling job is being run and it is taking 7 hours and sometimes it keeps on running.normally full crawling should take 2-3 hours and incremental crawling would take 10-15 mins.But we have observed that incremental itself it is taking 7 hours and never ended.finally we had look into log_reuse_wait_desc column in sysdatabases and had to take a log backup and managed to shrink tlog to 1 gigs.But i wanted to know how to react in such situations and what are preemptive actions can be taken go forward.Basically i was not able to know why the tlog has grown such drastically.In such situations how should we troubelshoot the issue and figure out the reason for the tlog growth.How to monitor the activities on a particular database and casuing the growth of tlog and finally we should be able to figure out which one is the actual culprit.I know this is something which is environment specific but am looking for some generosu answers who can help me out in handling such situations.What are all the possible solutions we can look for and how to capture all information and put forward the management and answer bcz of this, the TLOg has been growing rapidly ??Thanks in advance. |
|
|
Sachin.Nand
2937 Posts |
Posted - 2011-07-11 : 01:42:05
|
| There can be lot of reasons for that.Is there a very long running transaction in the job ?Is your database part of replication and the o/p of the job getting published on the subscriber ?Did you try setting up profiler for the job ?Is the job going into some what never ending loop ?What was the o/p for the log_reuse_wait_desc ?Is your job and the backup schedule getting excuted at the same time ?PBUH |
 |
|
|
frank.svs
Constraint Violating Yak Guru
368 Posts |
Posted - 2011-07-15 : 00:54:06
|
| Thanks for the help. |
|
|
|
|
|
|
TLog growth analysis