Tag Info

New answers tagged

0

You should be able to dump the output from fn_dump_dblog into a table to sort if needed. I'd recommend you decrease your backup interval to maybe every hour or so to make it easier to analyze the data (plus it will improve your ability to recover and reduce the time each backup takes). I tested a 453mb log and it took 10 minutes to read all 6.7 million ...


0

Have you considered creating and running an extended event to monitor what queries are running to generate all those log records? The following post by Paul Randal touches upon two events to perhaps get started with. http://sqlperformance.com/2013/11/sql-performance/transaction-log-monitoring I haven't played with the transaction_log event or ...



Top 50 recent answers are included