3

I have a SQL Server 2008 database with a transaction log that grows very rapidly each day. Is anyone aware of any tool that could be used to analyze in greater detail what transactions that make up the greater part of the log bulk? This so I know where to direct my attention.

Any help greatly appreciated!

Best regards Marcus

Marcus Johansson
  • 31
  • 2
  • `sys.dm_tran_database_transactions` has some relevant columns. You could poll this but for multi statement transactions I'm not sure if you could automatically tie this back to the individual statement that generated the logging activity. – Martin Smith Apr 15 '11 at 11:08

1 Answers1

0

It's not really an analyzer, but ApexSQL has tools to read log files; the other option is to use Profiler to monitor the activity.

I would also recommend getting to know the tables in the database, take record counts daily and see where your growth is.

SqlACID
  • 4,024
  • 20
  • 28