| Author |
Topic |
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
 Posted - 2009-12-20 : 16:22:55
|
| I Have found that LDF file size has grown which is abnormal, but how to find what causes the LDF to grow suddenly.What are the parameters I need to monitor for any Data file is growing?Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
Posted - 2009-12-20 : 18:48:07
|
| DB is in FULL Recovery Model, and Tlog Backups for every 15 Minutes. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
Posted - 2009-12-20 : 19:54:20
|
| What I want is how to check the LDF Growth in the past days (Let's Say 1 Week's time) as I need to establish the cause like the transactions OR reindex.But I am sure the REINDEX and Transaction is not the cause.is there any method where I can query or Look into for the LDF has grown to a larger size than it was.Thanks TKizer |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
Posted - 2009-12-20 : 21:59:51
|
| No I am not doing it for any tracing, stillI need the Clue, as to how to get the information to know the growth of LDF Please. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
Posted - 2009-12-20 : 22:30:11
|
| Thanks But its too late to trace it, how I can do it. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-12-21 : 03:20:12
|
| If you did not have a trace running when the ldf grew, you cannot now go back and look for the reasons. The only way to find this kind of stuff is to have a trace running at the time that it happens. No trace = no information--Gail ShawSQL Server MVP |
|
|
|
tripodal
Constraint Violating Yak Guru
259 Posts |
Posted - 2009-12-21 : 13:37:52
|
| There are several expensive programs you can use to read the ldf files, but this will not be over quickly you will not enjoy this. |
|
|
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
Posted - 2009-12-21 : 15:53:44
|
| Thanks All Generously who participated here.It's an eye opener not to get into such imbroglio in future.Merry Christmas to all SQL Server related Team / Forum. |
|
|
|
|
MDF & LDF