Monday, March 12, 2012

Find out what is written into transaction log

Hi,
My transaction log grows around 5 Gb an hour. I'm trying to find out what is
being written there and running SQL profiler. I can find very few
transactions with Writes other then 0. How can I find out what is being
written into transaction log in such huge volumes?
Have a look at getting a log viewer tool eg Lumigent's LogExplorer or
Redgate's LogRescue.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com

No comments:

Post a Comment