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 |
|
carumuga
Posting Yak Master
174 Posts |
 Posted - 2009-12-31 : 09:10:36
|
| Hi,One of my transaction log is growing during the day time and because of the growth one of the drive almost drives to full capacity.Would really interested in identifying the root cause of it and any query you have handy?Thanks in advance. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-12-31 : 09:41:40
|
| either start backing up the transaction log or switch to simple recovery |
 |
|
|
carumuga
Posting Yak Master
174 Posts |
Posted - 2009-12-31 : 09:52:10
|
| Thats fine, My question is, I'm interested in the "Source/transaction" that fills up the log file... |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-12-31 : 10:02:23
|
| can use profiler to capture queries with the most writes |
|
|
|
carumuga
Posting Yak Master
174 Posts |
Posted - 2009-12-31 : 10:48:27
|
| Apart from the profiler, Can you please advise if there is any query which performs similar operation. |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
|
|
|
|
|
Log file growth