Tracking down log file growth with SQL Monitor

PeterOCPeterOC Posts: 5 New member
edited December 7, 2015 9:21PM in SQL Monitor Previous Versions
Hi,
Could someone explain how I can use SQL Monitor to identify the queries that caused large log file growth on sql server.
An incident occurred yesterday where the log file grew from 60Gb to 116Gb. The were no large data imports at the time.
The database in question uses full detail logging. It's also set up for log shipping so the log file won't automatically get shrunk.
I understand that I can rewind to the time the event happened and I can see some long running queries but a long running query isn't necessarily going to grow the log.

I appreciate your feedback.

Cheers,
Peter
Sign In or Register to comment.